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 is recommended #sqltip #sql14 — Jens Vestergaard (@vestergaardj) July 2, 2013 New user databases will…

Read More

Microsoft Connect Bug Reports

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 project parameter is set as sensitive, I get this error message when setting up the foreach…

Read More

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 properly on all pcks #SQLServer #SQLTip — Jens Vestergaard (@vestergaardj) February 12, 2013 Move your…

Read More

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 more disk to become available, you will maybe be tempted to stop the operation through…

Read More

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 : See #MSDN bit.ly/UD8Kdb #SQLTip #SQLServer #SQL2012 — Jens Vestergaard (@vestergaardj) December 4, 2012 ALTER DATABASE…

Read More