SQL Utility Archives - Page 18 of 33 - SQL Authority with Pinal Dave

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

March 18, 2009

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 – Profiler – Adding Filters – Observation on CPU Load

March 13, 2009

Pinal Dave

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

SQL Profiler, SQL Utility

Today I am blog about something which I found recently while working with SQL Server Profiler. Profiler can be invoked just typing profiler in command prompt. I am using Windows Vista Ultimate 32 bit (License Version) and SQL Server 2008 Development (License Version). The reason I have put “License Version”…

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.

SQL SERVER – Download – Microsoft SQL Server 2008 Management Studio Express

February 22, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Download, SQL Utility

Microsoft SQL Server 2008 Management Studio Express is a free, integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server. SQL Server 2008 Management Studio Express combines a broad group of graphical tools with a number of rich script editors to provide access to SQL Server…

SQL SERVER – Disabling Indexes – Non Clustered Indexes

February 19, 2009

Pinal Dave

SQL Tips and Tricks

SQL Index, SQL Scripts, SQL Server, SQL Stored Procedure, SQL Utility

I came across a fantastic T-SQL script that offers an additional feature for changing the recovery mode while enabling and disabling indexes.