Recent content by andreis

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?