- 0x8007232B DNS Name Does Not Exist Error on Windows Activation
- 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
Preventing the row count from displaying in SQL Server
In SQL Server 7.0, every time you execute a query, you receive an additional result set indicating the number of rows processed by your query. Because SQL Server must generate this value each time you run a query, it increases the workload on your server. Turning off this count of rows processed by your query (or stored procedure) can significantly increase the performance of your query. You can turn the count off for your current connection by executing the statement SET NOCOUNT ON. If you want to turn off the count for all connections, you'll need to modify the properties of your server in SQL Server Enterprise Manager.
Source: John Sewell