Search results for query: *

Hi, got a puzzling question during an interview - how to find 2 rows that are different in 2 otherwise identical tables with 2 millions records each, no indexes, no primary keys. Since the tables are huge, SELECT * FROM t1 EXCEPT SELECT * FROM t2 won't work because it'll take too long to run...

Hi, we have ‘Short Stack Dump’ memory issue in our production SQL Server 2005 SP2 on 64-bit Windows 2003 R2 (VMWare). SQL Server freezes for hours before resuming normal functioning. Per somebody’s advice, we set SQL Server max memory to 2048 MB (out of 4 GB of RAM). Now, we are increasing RAM...

Hi, I need my SQL Server 2008 Standard Edition Integration package to send an email if my SELECT returns some rows - with these rows, and do not send email if the select returns no rows. How I make SSIS understand this condition? Thanks.

Hi, my SSRS (SQLServer 2008) subscribers are annoyed with reports that sometimes have no data. Is it possible to email them only a report only if it contains data?

Hi, our SQL Server 2005 e-mail notification (Database Mail) works fine, but pager doesn't. The pager works, I sent messages to it from regular email. All settings on Alert System property of SQl Agent seem fine. Do we need a third-party soft on mail server for pager to work? How can we get...

Hi, I deleted a test dataabse by accident that turned out to be very important, no backups. Is there a way (maybe some company that does it) to retreive deleted mdf file from Windows Server 2003 OS?

Hello, how do I give to a login read-only rights for one table only, in a database with a thousand or so tables, leaving the rest of the table invisible for this user?

Hi, we need to create a scheduled job that would grab binaries from SQl Server 2005 table and save them as viewable images (Employees Pictures) files. How can we do it? Thanks.

Hi, how do I let a user run an on-demand report using SQL Server 2005 Reporting Service? I have a report, can't just figure out how a user can run it whenever she wants it. Thanks.

Hi, on SQL Server 2000 db we have a huge table (10GB). We ran out of space, can't add space to data disk for whatever reason. I'm creating .ndf file to recreate indexes on another drive. What happens if I recreate a clustered index on another drive for such a huge table? When they say...

Hi, we kepp running out of space with our SQL Servers data an log files more often. What disk space monitoring software would be easy and reliable to alert us before databases run out of space? Is Big Brother good? Thanks.

Hi, we need to see pictures stored as varbinary(max) in SQL Server 2005, I know you can't just query it, is there some tool/trick to get the actual image?

Hello, we have a SQL Serer 2005 database with less than 3GB of space left on a 100GB partition. We need to give it more space but it’s on a cluster so that makes it multiple times more difficult to increase the size of the disk. Any recommendations? Thanks.

Hi, is it possible to do the following change to a SQL Server 2005 Reporting Service report, required by a customer: say, I have a table with columns Name, Month, Number of Hits. Name Month Hits Joe Jan 5 Joe Feb 10 Each name has 10-20 months rows with numbers of hits for each...

Hi, is there a script that allows me to lock (prevent from logging in) all database users (both NT and SQL Server), and then enable them back? I can do ALTER LOGIN USERNAME DISABLED, but I have about 200 users, so I'd like to have a script...

Hello, can I reinstall SQL Native Client for SQL Server 2005 SP3 64-bit on production, is it dangerous? During SP3 upgrade, I ran 32-bit version first by mistake, and it upgraded client. Then I ran 64-bit upgrade, and it upgraded server. Now, I can't connect to databases with SQL Server...

Hi, need help! On SQL Server 2005, SP3 64 bit SQL Server logins fail from withtin the box (when connectiong Query Analyzer, for example). NT logins are fine. When connecting from outside boxes - no problem for SQL or NT logins. TCP/IP. Named pipes enabled. Have 2 Native Clients installed, 32 and...

Hi: Is there a way to prevent our network Windows computers from unathorized installations of SQL Servers? How can we check periodically our network boxes to detect SQL Servers that were installed withour our permission? Thanks.

Hi, I need to write sp for SQL Server 2005 that fills either 10 or 12 columns of a table, depending on the input variables (10 or 12). How can I make a list of input parameter for sp dynamic (sometimes 10, sometimes 12, depending on a NULL value of one column, say, Price)? Thanks.

Hi, after running UPDATE STAITSTICS on SQL Server 2000 database to speed up report queries, we got them 3 times slower because Execution Plans have changed. Is there a way to return to old statistics from a backup? Is there another solution to this problem?