Here’s a quick wrap up of the articles published on www.SQLServerCurry.com in the month of January 2011
Select TOP With TIES in SQL Server - The SQL Server TOP Expression returns only the first set of rows that is either a number or a percent of rows. If you want additional rows to be returned from the base result set if duplicate values exists in the qualified set of results, then use TOP..WITH TIES as shown in this post
Create Date in T-SQL - SQL Server - Here’s a very simple query that shows how to create a Date using T-SQL if you are given the Day, Month and Year
Rollback Transaction in SQL Server - In this article, I have explained how to use a Try..Catch block to commit and rollback transaction
Rollback Nested Transactions in Stored Procedure - SQL Server - In this article, we will use an example to see how to rollback nested transactions in Stored Procedures
MINUS Keyword in SQL Server – Alternatives - MINUS operator (in oracle) is used to subtract the rows which are available in the second result, from the first result set. SQL Server does not have a built-in MINUS keyword, but in SQL Server, it’s equivalent is the EXCEPT operator or using NOT EXISTS
Date Difference in SQL Server in Days, Hours, Minutes and Seconds - A lot of users often ask questions related to finding difference between two date. The results are expected in Days, Hours, Minute and Seconds. Here’s a query that shows how to find the difference between two dates in SQL Server
UNPIVOT example in SQL Server - The PIVOT operator allows you to rotate, or pivot, data between columns and rows, and performs aggregations where they are required on any remaining column values. The UNPIVOT operator performs the reverse operation of PIVOT, by rotating columns into rows.
SQL Server Administration Articles
Backup Compression in SQL Server 2008 - Backup Compression is a new database administration feature in SQL Server 2008 and higher which allows you to compress your database backup. In this article, I have listed some frequently asked questions (FAQ) about Backup Compression in SQL Server 2008.
Deny Delete on a Table to All Users Except a Few – SQL Server - I was speaking to a DBA friend of mine the other day on how do they Deny deletes on a table to all users, including admins. One of the solutions was to use a trigger as shown in this post
Find the Most Used Stored Procedures in SQL Server - Let us see how to use the sys.dm_exec_query_stats DMV to return the 3 most used stored procedures in your SQL Server database
Load Comma Delimited file (csv) in SQL Server - We often need to import data that comes from different data sources, into a database like SQL Server. Usually data comes in the form of a comma delimited file aka CSV file. These are the two easy ways to import data from a CSV file into a table of a SQL Server Database – Using Bulk Insert and Using SQL Server Management Studio.
SQL Server: Export Table to CSV - Exporting data from SQL Server to a .csv file is often needed to use that data into a different system. There are two easy ways to do this – using BCP and using SQL Server Management Studio.
Rename a SQL Server database - Sometimes we may need to rename a SQL Server database for testing purposes or when a testing database goes online, we may need to rename it on a production database.
SQL Server General Topics
Create a Business Intelligence Solution in SQL Server 2008 R2 – Free Training - The January 2011 update of the SQL Server 2008 R2 Developers Training Kit contains a FREE Training course designed for developers who want to learn how to build their first Business Intelligence solution with SQL Server 2008 R2.