July 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

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

Pinal Dave
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…
Read More

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

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…
Read More
All Articles ss2016-config-600x400

SQL SERVER – List All Server Wide Configurations Values

Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Stored Procedure, SQL System Table

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 quickly I found out value of two digit year cutoff on line 19th. A small but very important script to save for getting server information.

Read More

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

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…
Read More