Search results for query: *

thanks, George, this is a great hint, although, for whatever reason, I still have a feeling this is not the most elegant solution I was expected to present...

not until I know the answer

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...

Denny, this is from the SQL ERRORLOG: 2010-08-04 07:02:53.98 Server **Dump thread - spid = 0, PSS = 0x0000000000000000, EC = 0x0000000000000000 2010-08-04 07:02:54.04 Server ***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0003.txt 2010-08-04...

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.

This is clever, may I ask how you return message in the report if no data is present?

Standard. Does Enterprise one have such a feature?

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?

Denny, thanks, I beleive we enter email address of the pager, like 1234@567.com. SQL Server attempts to send out the message, but it doesn't arrive. Andrei.

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?

I'm a humble DBA/T-SQL coder, and I need to solve this puzzle for production needs, that's why I asked for some examples maybe. If not, I'll have to go begging our programmers to help me, and they are often not in the mood...

Thanks, is there a simple sample/tutorial that could help a T-SQL coder to do this, or I better ask a real programmer?

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.

Denny, thanks, but the problem with this one is that any user role, even browse, gives a user possibility not only to view/change properties of the report, but also go to other reports...

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...

We have two dozen SQL Servers with around a hundred databases, so all cases are different. More often it's log file (backed up every hour), but in several cases it's data files that grew, possble, after optimization job of reindexing. One can tell that the space is eaten up because database freezes.