Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – Business Intelligence (BI) Basic Terms Explanation

October 30, 2007

Business Intelligence Business intelligence is a method of storing and presenting key enterprise data so that anyone in your company can quickly and easily ask questions of accurate and timely data. Effective BI allows end users to use data to understand why your business go the particular results that it…

SQL SERVER – Disable All Triggers on a Database – Disable All Triggers on All Servers

October 29, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index, SQL Scripts, SQL Trigger

Just a day ago, I received question in email regarding my article SQL SERVER – 2005 Disable Triggers – Drop Triggers. Question : How to disable all the triggers for database? Additionally, how to disable all the triggers for all servers? Answer: Disable all the triggers for a single database:…

SQL SERVER – 2008 – Server Consolidation WhitePaper Download

October 28, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Download, SQL White Papers

Server Consolidation with SQL Server 2008 Writer: Martin Ellis Reviewer: Prem Mehra,Lindsey Allen, Tiffany Wissner, Sambit Samal Published: March 2009 Microsoft SQL Server 2008 supports multiple options for server consolidation, which provides organizations with the flexibility to choose the consolidation approach that best meets their requirements to centralize data services…

SQL SERVER – 2005 – Get Current User – Get Logged In User

October 27, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts, SQL Server Security, SQL System Table

Interesting enough Jr. DBA asked me how he can get current user for any particular query is ran. He said he wants it for debugging purpose as well for security purpose. I totally understand the need of this request. Knowing the current user can be extremely helpful in terms of…

SQL SERVER – Deterministic Functions and Nondeterministic Functions

October 26, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function

Deterministic functions always returns the same output result all the time it is executed for same input values. i.e. ABS, DATEDIFF, ISNULL etc. Nondeterministic functions may return different results each time they are executed. i.e. NEWID, RAND, @@CPU_BUSY etc. Functions that call extended stored procedures are nondeterministic. User-defined functions that…

SQL SERVER – 2005 – Forced Parameterization and Simple Parameterization – T-SQL and SSMS

October 25, 2007

Pinal Dave

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

SQL Scripts, SQL Server Management Studio

SQL Server compiles query and saves the procedures cache plans in the database. When the same query is called it uses compiled execution plan which improves the performance by saving compilation time. Queries which are parametrized requires less recompilation and dynamically built queries needs compilations and recompilation very frequently. Forced…

SQL SERVER – Simple Example of WHILE Loop With CONTINUE and BREAK Keywords

October 24, 2007

Pinal Dave

SQL Tips and Tricks

SQL Cursor, SQL Function, SQL Scripts, SQL Server

I have tried to explain the usage of simple WHILE loop in the first example. BREAK keywords will exit the stop the while loop and control is moved.