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
SQL Server Best Practices
Here are some SQL Server Database programming guidelines, coding conventions, and best practices, keeping quality, performance and maintainability in mind.
Source: Vyas Kondreddi