2009 - Page 44 of 828 - 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 – 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.…

SQLAuthority News – Lots of SQL Server News – Tip of the Article

March 14, 2009

Pinal Dave

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

Database, SQL Download

I have been reeving lots of feedback from blog readers and what I have learned that they all wanted me to write about SQL Server Community news at least once a week. I am not sure if I can write every week what are happening in SQL Server world but…

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 – What is Your Favorite Database? – Poll Continuous

March 12, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, Poll

I have published SQL Server Poll about What is Your Favorite Database? to get feedback from readers of this blog about what is their favorite database. I have received so far tremendous response. This poll will continue through out this month and will close on 1st of April. I will…