All Articles - SQL Authority with Pinal Dave

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

January 13, 2009

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…

SQLAuthority News – Humor – Favorite Website – Funny Image

January 12, 2009

Pinal Dave

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

Poll, SQL Humor

I just received this image in email and I found it really funny. I do not know the source of the image or is it photoshopped. Thanks David Marsee for the image and email. If you have something really funny like this, please send them to me. Please do not…

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…

SQLAuthority News – Security White Papers

January 10, 2009

Pinal Dave

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

SQL Download, SQL Server Security, SQL White Papers

Microsoft Dynamics AX 2009 White Paper: Configuring Kerberos Authentication with Role Centers This document describes how to configure Kerberos authentication with Enterprise Portal and Role Centers. Kerberos authentication is required to display reports created using Microsoft SQL Server Reporting Services and Microsoft SQL Server Analysis Services on Role Center pages.…

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…

SQLAuthority News – Author Visit – Mumbai, India – From January 8, 2008 to January 11, 2008

January 8, 2009

Pinal Dave

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

SQLAuthority Author Visit

I will be traveling to Mumbai from From January 8, 2008 to January 11, 2008. If any of readers wants to meet up for cup of coffee in evening leave a comment or send me email and we can arrange something. I will be visiting various places and my access…

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.

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.…