Feeds:
Posts
Comments

Archive for May, 2010

SQLAuthority News – Monthly Roundup of Best SQL Posts

Posted in Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL, Technology on May 31, 2010 | 3 Comments »

After receiving lots of requests from different readers for long time I have decided to write first monthly round up. If all of you like it I will continue writing the same every month. In fact, I really like the idea as I was able to go back and read all of my posts written [...]

Read Full Post »

SQLAuthority News – Guest Post – Performance Counters Gathering using Powershell

Posted in SQL, SQL Add-On, SQL Authority, SQL Performance, SQL Query, SQL Server, SQL Tips and Tricks, SQL Utility, T SQL, Technology, tagged on May 30, 2010 | 1 Comment »

Laerte Junior Laerte Junior has previously helped me personally to resolve the issue with Powershell installation on my computer. He did awesome job to help. He has send this another wonderful article regarding performance counter for readers of this blog. I really liked it and I expect all of you who are Powershell geeks, you [...]

Read Full Post »

SQLAuthority News – Guest Post – FAULT Contract in WCF with Learning Video

Posted in SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL, Technology on May 29, 2010 | 1 Comment »

This is guest post by one of my very good friends and .NET MVP, Dhananjay Kumar. The very first impression one gets when they meet him is his politeness. He is an extremely nice person, but has superlative knowledge in .NET and is truly helpful to all of us. Objective: This article will give a [...]

Read Full Post »

SQL SERVER – Disabled Index and Update Statistics

Posted in Pinal Dave, SQL, SQL Authority, SQL Index, SQL Optimization, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology, tagged on May 28, 2010 | 3 Comments »

When we try to update the statistics, it throws an error as if the clustered index is disabled. Now let us enable the clustered index only and attempt to update the statistics of the table right after that. Have you ever come across the situation where a conversation never gets over and it continues even [...]

Read Full Post »

SQL SERVER – DATE and TIME in SQL Server 2008

Posted in Pinal Dave, SQL, SQL Authority, SQL DateTime, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on May 27, 2010 | 10 Comments »

I was thinking about DATE and TIME datatypes in SQL Server 2008. I earlier wrote about the about best practices of the same. Recently I had written one of the script written for SQL Server 2008 had to run on SQL Server 2005 (don’t ask me why!), I had to convert the DATE and TIME [...]

Read Full Post »

Older Posts »

Follow

Get every new post delivered to your Inbox.

Join 15,279 other followers