Pinal Dave - SQL Server Performance Tuning Expert

SQLAuthority News – Ahmedabad User Group Meeting January 17 2009

January 16, 2009

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

It is my pleasure to announce that SQL Server User Group Meeting is held on January 17, 2009. This is the first meeting of year 2009 and will be one interesting meeting as we will have back to back three presentation from SQL Experts. The agenda of meeting will be…

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

January 15, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts, SQL String

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…

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