T-SQL and SQL Server Administration Articles Link List – January 2011

Here’s a quick wrap up of the articles published on www.SQLServerCurry.com in the month of January 2011

T-SQL Articles

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.

About The Author

Suprotim Agarwal, MCSD, MCAD, MCDBA, MCSE, is the founder of DotNetCurry, DNC Magazine for Developers, SQLServerCurry and DevCurry. He has also authored a couple of books 51 Recipes using jQuery with ASP.NET Controls and a new one recently at The Absolutely Awesome jQuery CookBook.

Suprotim has received the prestigous Microsoft MVP award for nine times in a row now. In a professional capacity, he is the CEO of A2Z Knowledge Visuals Pvt Ltd, a digital group that represents premium web sites and digital publications comprising of Professional web, windows, mobile and cloud developers, technical managers, and architects.

Get in touch with him on Twitter @suprotimagarwal, LinkedIn or befriend him on Facebook


Callezee said...

sql is database and user friendly one....

server administration said...

Greetings everyone, This webpage is outstanding and so is how the matter was expanded. I like some of the comments as well although I would prefer we all keep it on topic in order add value to the subject.