SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

SqlServerZest.com - SQL in simple style

Suresh Raavi is a database professional, with a zest for SQL Server specializing in Administration and performance tuning. Presently, he is a Sr. SQL Server DBA at the Microsoft Products and Services IT SQL team, taking part in various challenging projects, focusing mainly on performance tuning, database development, high availability and database design. He is passionate about database technologies and "data" in general. He has earned the MCITP Database Administrator 2008, and holds a Master of Science degree in Engineering. He provides insights from the field on his blog at http://SqlServerZest.com. His hobbies includes Running and Travelling. You can follow him on Twitter @SqlServerZest

Archives: September 2013

SQL Server – How to Add More Than One Column as a Primary Key

Sometimes you might want to add more than one column as primary key. For example, if you have three columns named Last Name, First Name and Address and  there can be duplicate Last Names  or duplicate First Names but can never have duplicates in Last Name, First Name  and Address…

Read more

1 comments, 556 reads

Posted in SqlServerZest.com - SQL in simple style on 17 September 2013

SQL Server – How to Create Registered Servers to Easily Manage and Query Multiple Instances at a Time

Registered servers is a great way to manage, categorize and access the SQL servers through SSMS and also one of the overlooked aspects. Registered servers are handy when you want to have all your servers at one place, sorted and categorized in various ways. With registered servers all your instances…

Read more

1 comments, 453 reads

Posted in SqlServerZest.com - SQL in simple style on 16 September 2013

SQL Server – Find all the LOB Data Type Columns in a Database Using T-SQL Script

Today morning when I was working on a huge database containing lots of LOB data, I was required to know what tables have LOB data, and the list of LOB columns by table name along with the data type. I found that starting SQL Server 2005, we can easily retrieve…

Read more

1 comments, 813 reads

Posted in SqlServerZest.com - SQL in simple style on 12 September 2013

SQL Server – How to Perform Striped Database Backup & Restore Using T-SQL Command

Even though there are more pros than cons, Striping database backups are often overlooked by many DBAs. Based on my observations in our environment, striping can significantly benefit larger database backups (~500+ GB). As shown in the picture below, striping is nothing but splitting one backup file to multiple backup…

Read more

1 comments, 1,546 reads

Posted in SqlServerZest.com - SQL in simple style on 3 September 2013