SQL Archives - Page 368 of 4 - 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…

SQLAuthority News – Converting a Delimited String of Values into Columns

February 10, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL String, SQL XML

This blog post is about two great bloggers and their excellent series of blog posts. It was quite unusual to see two bloggers posting articles that are supporting each other and constantly improving the articles to the next level. Two blogs which I am going to mention here are as…

SQL SERVER – Brief Note about StreamInsight – What is StreamInsight

February 9, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

DBA, SQL Documentation

StreamInsight is a new event processing platform introduced in upcoming version SQL Server 2008 R2. Similar to other components such as SSIS, SSAS or Service Broker, it also needs to be installed along with the SQL Server. Up to SQL Server 2005, Microsoft’s main focus on SQL Server was to…

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 – SQL Server 2008 R2 Update for Developers Training Kit

February 7, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database, SQL Documentation, SQL Download, SQL Training

Note: Download SQL Server 2008 R2 Update for Developers Training Kit by Microsoft SQL Server 2008 R2 offers an impressive array of capabilities for developers that build upon key innovations introduced in SQL Server 2008. The SQL Server 2008 R2 Update for Developers Training Kit is ideal for developers who…

SQLAuthority News – Presenting Two Sessions at TechED Sri Lanka

February 6, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

MVP, SQLAuthority Author Visit, TechEd

I will be presenting following two sessions at TechEd Sri Lanka this week. I am very excited as this is very first time I will be presenting in TechEd event. I have previously presented many sessions but I have never presented at this premier Microsoft Event. I will be presenting…

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…