SQL Archives - Page 369 of 519 - SQL Authority with Pinal Dave

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

February 5, 2010

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…

SQLAuthority News – MVP Open Day South Asia – Jan 20, 2010 – Jan 23, 2010 – Review Part Fun

February 3, 2010

Pinal Dave

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

MVP, SQL User Group, SQLAuthority Author Visit

MVP Open Day South Asia was held in Hyderabad from Jan 20, 2010 to Jan 23, 2010. This event was a fun-filled event as well as an educational one. The event was held at Microsoft IDC at Hyderabad, the largest Microsoft Development location after Redmond. I had great time meeting…

SQL SERVER – Question – How to Convert Hex to Decimal

February 1, 2010

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

In one of the recent projects, I realize the bottleneck of the query was an inline function which was converting Hex to Decimal. I optimized the inline function and reduced the query running time to one-tenth of the original running time. Later, I was eager to find out the script…

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…

SQLAuthority News – Community Tech Days – Jan 30, 2010 – Must Attend

January 28, 2010

Pinal Dave

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

SQL Azure, SQLAuthority Author Visit

Attend deep technology sessions for developers and IT professionals, as some of the best-known names come to your city to share their insights in topics ranging from .Net, Visual studio, Silverlight, to Windows and SQL Server. Build connections with Microsoft experts and community members and gain the inspiration and skills…

SQLAuthority News – Download White Paper – Troubleshooting Performance Problems in SQL Server 2008

January 26, 2010

Pinal Dave

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

SQL Documentation, SQL Download, SQL White Papers

Troubleshooting Performance Problems in SQL Server 2008 SQL Server Technical Article Writers: Sunil Agarwal, Boris Baryshnikov, Keith Elmore, Juergen Thomas, Kun Cheng, Burzin Patel Technical Reviewers: Jerome Halmans, Fabricio Voznika, George Reynya Published: March 2009 It’s not uncommon to experience the occasional slowdown of a database running the Microsoft SQL…