SQL RESOURCES

Retrieving Random Rows

You can run script below and it will give random rows every single time you run it:   USE AdventureWorks2012 GO -- Method 1 SELECT TOP 100* FROM SalesOrderDetail ORDER BY NEWID() GO -- Method 2 SELECT TOP 100 * FROM SalesOrderDetail ORDER BY...

Read More

Tips to Speed up your database

10 SQL TIPS – to speed up your database http://www.catswhocode.com/blog/10-sql-tips-to-speed-up-your-database

Read More

USEFUL SQL TIPS

This is a whitepaper of Top Ten SQL Performance Tips I found this to be a very useful link: http://www.quest.com/whitepapers/10_SQL_Tips.pdf

Read More