SQL Tips and Tricks Archives - Page 426 of 536 - SQL Authority with Pinal Dave

SQL SERVER – Download – Microsoft SQL Server 2008 Management Studio Express

February 22, 2009

Microsoft SQL Server 2008 Management Studio Express is a free, integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server. SQL Server 2008 Management Studio Express combines a broad group of graphical tools with a number of rich script editors to provide access to SQL Server…

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

February 21, 2009

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…

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…

SQL SERVER – Disabling Indexes – Non Clustered Indexes

February 19, 2009

Pinal Dave

SQL Tips and Tricks

SQL Index, SQL Scripts, SQL Server, SQL Stored Procedure, SQL Utility

I came across a fantastic T-SQL script that offers an additional feature for changing the recovery mode while enabling and disabling indexes.

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 – List All Server Wide Configurations Values

February 16, 2009

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.