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

SQL SERVER – Remove Duplicate Entry from Comma Delimited String – UDF

January 15, 2009

I love reader’s contribution this blog as that brings variety in articles. I encourage my readers to provide their contribution and I will publish then with their name. Blog Reader Ashish Jain has posted very simple script which will remove duplicate entry from comma delimited string. User Defined Function has…

SQL SERVER – Find Number of Rows and Disk Space Reserved – Using sp_spaceused Interesting Observation

January 14, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Data Storage, SQL Function, SQL Scripts, SQL Server DBCC, SQL Stored Procedure, SQL Utility

Previously I posted SQL SERVER – Find Row Count in Table – Find Largest Table in Database – T-SQL. Today we will look into the same issue but with some additional interesting detail. We can find the row count using another system SP sp_spaceused. This SP gives additional information regarding…

SQL SERVER – Find Row Count in Table – Find Largest Table in Database – T-SQL

January 13, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index, SQL Scripts, SQL System Table, SQL Utility

I have written following script every time when I am asked by our team leaders or managers that how many rows are there in any particular table or sometime I am even asked which table has highest number of rows. Being Sr. Project Manager, sometime I just write down following…

SQL SERVER – Top Five Articles of Year 2008

January 11, 2009

Pinal Dave

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

Database, SQL Scripts

Year 2008 was great year for me. I got plenty of request from readers asking for Top 10 or Top 5 articles of the year 2008. I am including Top 5 Articles of Year 2008 in two different categories. First is my blog SQLAuthority.com and another one is my home…

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

January 9, 2009

Pinal Dave

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 – Find Currently Running Query – T-SQL

January 7, 2009

Pinal Dave

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

SQL Scripts, SQL Server Security

This is the script which I always had in my archive. Following script find out which are the queries running currently on your server. SELECT sqltext.TEXT, req.session_id, req.status, req.command, req.cpu_time, req.total_elapsed_time FROM sys.dm_exec_requests req CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext While running above query if you find any query which is running for…

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.