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

SQL SERVER – 2008 – Optimize for Ad hoc Workloads – Advance Performance Optimization

March 21, 2009

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

Best Practices, SQL Scripts, SQL Stored Procedure, SQL System Table

Every batch (T-SQL, SP etc) when ran creates execution plan which is stored in system for re-use. Due to this reason large number of query plans are stored in system. However, there are plenty of plans which are only used once and have never re-used again. One time ran batch…

SQL SERVER – Find All Servers From Local Network – Using sqlcmd – Detect Installed SQL Server on Network

March 18, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts, SQL Utility, sqlcmd

I recently had requirement to create list of all the SQL Server on local network. I remembered that I had written similar script a year ago SQL SERVER – Script to Find SQL Server on Network. When I looked at it, I realize that I had written it for SQL…

SQL SERVER – Practical SQL Server XML: Part One – Query Plan Cache and Cost of Operations in the Cache

March 17, 2009

Pinal Dave

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

Database, SQL Scripts, SQL Utility, SQL XML

I am very fortunate that I have friends like Michael Coles. Michael Coles is SQL Server and XML expert and have written many books on SQL Server as well XML. He has previously written book which I have reviewed on this blog SQLAuthority News – Book Review – Pro T-SQL…

SQL SERVER – UDF – Pad Ride Side of Number with 0 – Fixed Width Number Display

March 16, 2009

Pinal Dave

SQL Tips and Tricks

Best Practices, SQL Function, SQL Scripts, SQL Server, SQL Utility

SQL SERVER – UDF – Pad Ride Side of Number with 0 – Fixed Width Number Display. Let us learn more about this blog.

SQL SERVER – Interesting Observation of ON Clause on LEFT JOIN – How ON Clause affects Resultset in LEFT JOIN

March 15, 2009

Pinal Dave

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

SQL Joins, SQL Scripts

Today I received email from Yoel from Israel. He is one smart man always bringing up interesting questions. Let us see his latest email first. Hi Pinal, I am subscribed to your blog and enjoy reading it. I have a question which has been bothering me for some time now.…

SQL SERVER – Difference Between Union vs. Union All – Optimal Performance Comparison

March 11, 2009

Pinal Dave

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

SQL Scripts

More than a year ago I had written article SQL SERVER – Union vs. Union All – Which is better for performance? I have got many request to update this article. It is not fair to update already written article so I am rewriting it again with additional information. UNION…

SQL SERVER – Pad Ride Side of Number with 0 – Fixed Width Number Display

March 10, 2009

Pinal Dave

SQL Tips and Tricks

Best Practices, SQL Function, SQL Scripts, SQL Server, SQL Utility

Today we will look something which is very quick and but quite frequently useful string operation over numeric datatype. This article is written based on a question asked by one of the users (name not disclosed as per request). Let us see how to show a fixed width number display.