Tag Archives: SQL2012

SQL Server Quick Tip 26 – 30

[Blog]: So you think you need Enterprise Edition, huh? http://t.co/zRWoumqRQf #DBA #SQLServer #SQLTip #in — Jens Vestergaard (@vestergaardj) July 4, 2013 A ratio between the size of max_server_memory and the size of the buffer pool extension of 1:16 or less … Continue reading

Posted in Programming | Tagged , , | Leave a comment

Microsoft Connect Bug Reports

m4s0n501 Just posted two bug reports to Microsoft Connect We don’t take kindly to sensitivity ’round here… First, I perceive it as a bug, when a foreach loop fails to list variables when a project parameter is set as sensitive. When a … Continue reading

Posted in Programming | Tagged , , | Leave a comment

SQL Server Quick Tip 16-20

#SQLTip #SQLServer #TSQL amzn.com/k/P3Livr0TRReO… TRUNCATE TABLE resets the IDENTITY property to its original seed, while DELETE doesn’t. — Jens Vestergaard (@vestergaardj) March 1, 2013 When dealing with parent-child pcks in #SSIS, be sure to verify the ProtectionLevel prop is set … Continue reading

Posted in Programming | Tagged , , | Leave a comment

Run out of disk you say, eh?

In the rare occasion, that when you are executing a project from the Information Services Catalogs, and the SysAdmin didn’t foresee some, unforeseeable event causing the disk to run out of space. And the execution doesn’t fail, just waits for … Continue reading

Posted in Programming | Tagged , , | Leave a comment

SQL Server Quick Tip 11 – 15

You can validate a #SQLServer setup by running ‘Setup.exe /Action=RunDiscovery /q’, more info at #MSDN bit.ly/TGw9Yl #SQLTip #SQL2012 — Jens Vestergaard (@vestergaardj) December 4, 2012 The only way to access SSAS is by using XML for Analysis Services Listener : … Continue reading

Posted in Programming | Tagged , , | Leave a comment