February « 2009 « SQL Server Journey with SQL Authority

Archive for February, 2009

SQL SERVER – Enable and Disable Index Non Clustered Indexes Using T-SQL

Posted in Pinal Dave, Readers Contribution, SQL, SQL Authority, SQL Index, SQL Query, SQL Scripts, SQL Server, SQL Stored Procedure, SQL Tips and Tricks, SQL Utility, T SQL, Technology on February 19, 2009 | 11 Comments »

Just a day before I received wonderful T-SQL Script from SQL Server Expert Imran Mohammed. What I am really impressed from this script is additional feature of changing recovery mode when SQL Server is enabling and disabling Index. When index are enabled changing SQL Server Recovery mode to simple makes whole operation faster. This stored [...]

Read Full Post »

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

Posted in Database, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority Author Visit, SQLAuthority News, T SQL, Technology, tagged DigiCorp on February 18, 2009 | 5 Comments »

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 visited DigiCorp Information Systems Pvt. [...]

Read Full Post »

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

Posted in Pinal Dave, SQL, SQL Authority, SQL Backup and Restore, SQL Documentation, SQL Query, SQL Scripts, SQL Security, SQL Server, SQL System Table, SQL Tips and Tricks, T SQL, Technology on February 17, 2009 | 14 Comments »

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 files I have left there [...]

Read Full Post »

SQL SERVER – List All Server Wide Configurations Values

Posted in Pinal Dave, SQL, SQL Authority, SQL Documentation, SQL Query, SQL Scripts, SQL Server, SQL System Table, SQL Tips and Tricks, T SQL, Technology on February 16, 2009 | 8 Comments »

Just a day ago, while working on one of the project, I needed to see what is the two digit year cutoff of my current SQL Server. I did not remember what was the exact syntax to search for the same so I ran following query to list all server wide configurations. While looking at [...]

Read Full Post »

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

Posted in Best Practices, Pinal Dave, SQL, SQL Authority, SQL Backup and Restore, SQL Data Storage, SQL Query, SQL Security, SQL Server, SQL Tips and Tricks, SQL Utility, T SQL, Technology on February 15, 2009 | 2 Comments »

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 contains all the system level [...]

Read Full Post »

« Newer Posts - Older Posts »