SQL Scripts Archives - Page 237 of 318 - SQL Authority with Pinal Dave

SQL SERVER – ALTER DATABASE dbname SET SINGLE_USER WITH ROLLBACK IMMEDIATE

February 11, 2010

I have recently been conducting lots of training on SQL Server technology. During these trainings, I quite often create new databases and drop them as well. Many times, I am not able to drop the database as one of my instances might be using the database. As I am working…

SQL SERVER – Find the Size of Database File – Find the Size of Log File

February 8, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Log, SQL Scripts, SQL System Table

I encountered the situation recently where I needed to find the size of the log file. When I tried to find the script by using Search@SQLAuthority.com I was not able to find the script at all. Here is the script, if you remove the WHERE condition you will find the…

SQL SERVER – Stream Aggregate Showplan Operator – Reason of Compute Scalar before Stream Aggregate

February 5, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

I keep a check on the questions received from my readers; when any question crosses my threshold, I surely try to blog about it online. Stream Aggregate is a quite commonly encountered showplan operator. I have often found it in very simple COUNT(*) operation’s execution plan. If you like to…

SQL SERVER – Get the List of Object Dependencies – sp_depends and information_schema.routines

February 4, 2010

Pinal Dave

SQL Tips and Tricks

SQL Dependency, SQL Scripts, SQL Server, SQL Server Security, SQL System Table

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

January 31, 2010

Pinal Dave

SQL

SQL Scripts, SQL Server, SQL System Table

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.

SQL SERVER – Several Readers Questions and Readers Answers

January 30, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

I often get questions on blog and many times I even get answers from readers as well. This article is collection of few of the questions and answers by readers of this blog. Q. How the records of a table can be scripted in INSERT INTO statements? A. In SQL…

SQL SERVER – Find Statistics Update Date – Update Statistics

January 25, 2010

Pinal Dave

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

SQL Index, SQL Scripts, SQL Statistics

Statistics are one of the most important factors of a database as it contains information about how data is distributed in the database objects (tables, indexes etc). It is quite common to listen people talking about not optimal plan and expired statistics. Quite often I have heard the suggestion to…