Recently, I read a question on my friend‘s SQL site regarding the following: sp_depends does not give appropriate results whereas information_schema. routines do give proper answers.
SQL SERVER – Location of Resource Database in SQL Server Editions
While working on a project of database backup and recovery, I found out that my client was not aware of the resource database at all. Location of Resource.
SQLAuthority News – SQL Server 2008 R2 – Release Date in May 2010
Microsoft has announced that SQL Server 2008 R2 will be available by May 2010. Its CTP (Community Technology Preview) version was already available from August 2009. It is still available for download.
SQLAuthority News – Download Sample Database for Microsoft SQL Server
This post is a response to one of the most asked questions where to get Sample Database for SQL Server 2008. The name of the new sample database is AdventureWorks.
SQL SERVER – Execution Plan – Estimated I/O Cost – Estimated CPU Cost – No Unit
During the SQL Server Optimization training, I enjoy teaching the Execution Plan. I am always sure that questions related to the estimated cost will be raised by attendees. Following are some common questions related to costs:
SQL SERVER – Fix: Error: 262 : SHOWPLAN permission denied in database
During one of my recent training class when I asked students to check the execution plan using (can be enabled using CTRL+M), they received error as following.
Msg 262, Level 14, State 4, Line 1
SHOWPLAN permission denied in database ‘AdventureWorks’.
SQL SERVER – Find Location of Data File Using T-SQL
While preparing for the training course of Microsoft SQL Server 2005/2008 Query Optimization and & Performance Tuning, I needed to find out where my database files are stored on my hard drive. It is when following script came in handy to find the location of the data file using T-SQL.