Tag Archives: SQLServer

SQL Server Quick Tip 21-25

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

History repeats itself…

This week, I will be attending my second SQLBits. I had my rookie year last year, where I learned the most important fact about SQLBits: Every session is a winner you don’t wanna miss. I had a hard time deciding … Continue reading

Posted in Programming | Tagged , , | 1 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

TBP – Tripple Businesskey Problem, the lesser known problem…

I have come across a rather, for me at least, unusual data composition, and wanted to share the solution to the business problem. Given is one single source file that contains facts and some dimensional identification. In this case, we … 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