January « 2009 « SQL Server Journey with SQL Authority

Archive for January, 2009

SQLAuthority News – Download Microsoft SQL Server Protocol Documentation

Posted in SQL, SQL Authority, SQL Documentation, SQL Download, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL, Technology on January 17, 2009 | Leave a Comment »

he Microsoft SQL Server protocol documentation provides detailed technical specifications for Microsoft proprietary protocols (including extensions to industry-standard or other published protocols) that are implemented and used in Microsoft SQL Server to interoperate or communicate with Microsoft products. The documentation includes a set of companion overview and reference documents that supplement the technical specifications with [...]

Read Full Post »

SQLAuthority News – Ahmedabad User Group Meeting January 17 2009

Posted in MVP, Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQL User Group, SQLAuthority News, T SQL, Technology on January 16, 2009 | 4 Comments »

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 as following. Query Optimization Part [...]

Read Full Post »

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

Posted in Pinal Dave, Readers Contribution, SQL, SQL Authority, SQL Function, SQL Query, SQL Scripts, SQL Server, SQL String, SQL Tips and Tricks, T SQL, Technology on January 15, 2009 | 14 Comments »

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 very simple logic behind it. [...]

Read Full Post »

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

Posted in Pinal Dave, SQL, SQL Authority, SQL Data Storage, SQL Function, SQL Query, SQL Scripts, SQL Server, SQL Server DBCC, SQL Stored Procedure, SQL Tips and Tricks, SQL Utility, T SQL, Technology on January 14, 2009 | 8 Comments »

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 disk space reserved on database [...]

Read Full Post »

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

Posted in Pinal Dave, SQL, SQL Authority, SQL Index, SQL Query, SQL Scripts, SQL Server, SQL System Table, SQL Tips and Tricks, SQL Utility, T SQL, Technology on January 13, 2009 | 27 Comments »

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 script myself rather than asking [...]

Read Full Post »

« Newer Posts - Older Posts »