rchantler - The gist of it, is that only a plan "stub" will be used the first time that a plan is created. This plan stub is smaller in size,...

We also just experienced this issue. In our case, it was due to our infrastructure team installing SNMP on the server, which in certain environments will stop the SQL Server...

Hmmm...I'll have to play around with those. Thanks!

-Jeremy

After reading this article - http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/dynamic-pivot-on-multiple-columns, I came up with the following solution:

SELECT [Account], [Date], [Amt]

, ROW_NUMBER() OVER (PARTITION BY DNUM ORDER BY EFTChkDate) AS rownum

INTO #pmts

FROM [Payments].[dbo].[PayData]

GO

DECLARE...

Thank you for the reply Sean. I will make sure to post the ddl and sample data in the future.

The example you've provided is interesting. I've never thought of...

I think a lot of people are getting this wrong because the question is a bit ambiguous. SQL Server cannot compress this data, but it can be NTFS compressed and...

Daniel,

From the article - "DBCC CHECKDB interprets the page contents (for example, validating row structures, validating column values, checking linkages in indexes), and so should always be able to detect...

Read through this: http://msdn.microsoft.com/en-us/library/ms176097.aspx. I think example H is what you are looking for.

This should not cause an issue, but you should definitely test a change like this before executing it in production.

I encountered a similar error recently while upgrading from 2008 to 2008 R2. In our case, it was because the Agent account was entered using the oldschool format of accountname@domain...

Judging from this portion of the log:

"2012-02-20 01:23:36.63 spid6s Cannot recover the master database. SQL Server is unable to run. Restore master from a full backup, repair it, or rebuild...

This command provides quite a bit of info on memory:

DBCC MEMORYSTATUS