Newest Tips & Tricks...
- How to update a column with incrementing numbers
- How to get top N rows for each group?
- How to put a column into a delimited form
- How to export results of a stored procedure to a txt file
- Parsing delimited words from a column
- How to get N-th max value
- How to get a random row from a table
- How to dynamicaly rank rows
- How to get just date or just time from a datetime value
- Windows Media Player and folder.jpg Hell
Home :: Tips & Tricks :: Microsoft SQL Server
SQL Server Best Practices
http://www.sql-server-performance.com/vk_sql_best_practices.asp
Here are some SQL Server Database programming guidelines, coding conventions, and best practices, keeping quality, performance and maintainability in mind.
Source: Vyas Kondreddi