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

SQL SERVER – sqlcmd – Using a Dedicated Administrator Connection to Kill Currently Running Query

January 9, 2009

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

SQL Scripts, SQL Server Security, SQL Utility, sqlcmd

People are judged from their questions and not their answers. I received wonderful question the other day. How sqlcmd can be used along with currently running query script posted on your blog? Please read following two posts before continuing this article as they cover background of this article. SQL SERVER…

SQL SERVER – Interesting Observation – Using sqlcmd From SSMS Query Editor

January 6, 2009

Pinal Dave

SQL Video

SQL Scripts, SQL Server, SQL Utility, sqlcmd

A day before I wrote article SQL SERVER – sqlcmd vs osql – Basic Comparison. Today while I was displaying how sqlcmd can be used instead of osql to one of my companies team leader, I found another neat feature of SSMS Query Editor. sqlcmd can be used from Query Editor but it has to be enabled first.

SQL SERVER – sqlcmd vs osql – Basic Comparison

January 5, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Utility, sqlcmd

Today we will go over very simple but to the point comparison of two SQL Server utilities or SQL Server tools. This comes often to users which one to use sqlcmd or osql, when in need of running SQL Server queries from command prompt. Answer to this is very simple…

SQL SERVER – 2008 – Change Color of Status Bar of SSMS Query Editor

January 4, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices, SQL Server Management Studio, SQL Server Security, SQL Utility

This is one very interesting issue which I have started to follow recently. Just like any other organization my company has many servers. Some are production and some are development. It is very much necessary that query which are written for developer environment does not run for production environment accidentally.…

SQL SERVER – Time Delay While Running T-SQL Query – WAITFOR Introduction

January 3, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices, SQL DateTime, SQL Scripts, SQL Utility

Today we will look at one very small but interesting feature of SQL Server. Please note that this is not much known feature of SQL Server. In SQL Server sometime there are requirement when T-SQL script has to wait for some time before executing next statement. It is quite common…

SQL SERVER – Change Collation of Database Column – T-SQL Script

December 20, 2008

Pinal Dave

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

SQL Collation, SQL Scripts, SQL Server Security, SQL Utility

Just a day before I wrote about SQL SERVER – Find Collation of Database and Table Column Using T-SQL and I have received some good comments and one particular question was about how to change collation of database. It is quite simple do so. Let us see following example. USE…

SQL SERVER – Connect using Enterprise Manager to SQL Server 2005/2008

December 14, 2008

Pinal Dave

SQL Tips and Tricks

SQL Server, SQL Server Management Studio, SQL Utility, SSMS

I received the following email from Mike Bikinis. about enterprise manager. “How can I connect to SQL Server 2005 or SQL Server 2008 using SQL Server 2000’s Enterprise Manager?”