SQL Archives - Page 414 of 519 - SQL Authority with Pinal Dave

SQL SERVER – My Observation – Effect of Clustered Index over Nonclustered Index

February 21, 2009

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Constraint and Keys, SQL Index, SQL Scripts

Note: This article is re-write of my previous article SQL SERVER – Observation – Effect of Clustered Index over Nonclustered Index. I have received so many request that re-write it as it is little confusing. I am going to re-write this with simpler words. Query optimization is one art which…

SQLAuthority News – Ahmedabad User Group Meeting February 21 2009

February 20, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL User Group, SQLAuthority Author Visit

It is my pleasure to announce that SQL Server User Group Meeting is held on February 21, 2009. This is the second meeting of year 2009 and will be one interesting meeting as we will have back to back two presentation from SQL Experts. The agenda of meeting will be…

SQLAuthority Author Visit – A True Outsourcing Giant and Technology Leader DigiCorp in Ahmedabad India

February 18, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database, DigiCorp, SQLAuthority Author Visit

Last week, I happen to visit one of the tech company in Ahmedabad, India. I visit different IT organization for two purpose – learn more about technology advancement in different organization and help them with any issues if they are facing with Microsoft technology and in particular SQL Server. I…

SQL SERVER – Find Current Location of Data and Log File of All the Database

February 17, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Scripts, SQL Server Security, SQL System Table

As I am doing lots of experiments on my SQL Server test box, I sometime gets too many files in SQL Server data installation folder – the place where I have all the .mdf and .ldf files are stored. I often go to that folder and clean up all unnecessary…

SQL SERVER – Reasons to Backup Master Database – Why Should Master Database Backedup

February 15, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices, SQL Backup and Restore, SQL Data Storage, SQL Server Security, SQL Utility

The most interesting thing about writing blog at SQLAuthority.com is follow up question. Just a day before I wrote article about SQL SERVER – Restore Master Database – An Easy Solution, right following it, I received email from user requesting reason for importance of backing up master database. Master database…

SQL SERVER – Restore Master Database – An Easy Solution

February 14, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Scripts, SQL Server Security, SQL Utility

Today we will go over two step easy method to restore ‘master’ database. It is really unusal to have need of restoring the master database. In very rare situation this need should arises. It is important to have full backup of master database, without full backup file of master database…

SQL SERVER – Simple Example of Reading XML File Using T-SQL

February 13, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL XML

In one of the previous article we have seen how we can create XML file using SELECT statement SQL SERVER – Simple Example of Creating XML File Using T-SQL. Today we will see how we can read the XML file using the SELECT statement. Following is the XML which we…