Tag Archives: SQLTip

SQL Server Quick Tip 21-25

Posted on 17/05/2013 by Jens Vestergaard
Share

if only I had read this a month ago… need to improve the code base #sqltip #amo #sqlserver amzn.com/k/20YEJ78S2A0MM #Kindle — Jens Vestergaard (@vestergaardj) February 26, 2012 You can partition an existing table by creating a clustered index on your … Continue reading →

Posted in Programming | Tagged , | Leave a comment

SQL Server Quick Tip 16-20

Posted on 31/03/2013 by Jens Vestergaard
Share

#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

SQL Server Quick Tip 11 – 15

Posted on 04/12/2012 by Jens Vestergaard
Share

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

SQL Server Quick Tip 6 – 10

Posted on 16/11/2012 by Jens Vestergaard
Share

Do not add flexible database roles as members of fixed roles. This could enable unintended privilege escalation. #SQLTip #SQLServer #SQL2012 — Jens Vestergaard (@vestergaardj) november 10, 2012   A SQL Server backup cannot be restored by a version of SQL … Continue reading →

Posted in Programming | Tagged , | Leave a comment

SQL Server Quick Tip 1 – 5

Posted on 09/11/2012 by Jens Vestergaard
Share

Here’s my first five SQL Server Quick Tips: Shrink database or shrink file operations CANNOT be run during a database or transaction log backup #sqltip #sqlserver #sql2012 — Jens Vestergaard (@vestergaardj) november 2, 2012   To edit an alert,you need … Continue reading →

Posted in Programming | Tagged , | Leave a comment