Feeds:
Posts
Comments

Archive for May, 2011

SQL SERVER – expressor 3.2 Release Review

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQL Utility, T SQL, Technology on May 11, 2011 | Leave a Comment »

I have been following expressor software for some time now and they have recently released a new version of their expressor Studio desktop ETL application.  I am pleased to find out that the download and installation experience of this application has been greatly simplified.  expressor Studio no longer requires users to install a license key [...]

Read Full Post »

SQL SERVER – Resource Database ID – 32767

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Query, SQL Server, SQL System Table, SQL Tips and Tricks, T SQL, Technology on May 10, 2011 | 8 Comments »

Earlier I blogged about SQL SERVER – What Kind of Lock WITH (NOLOCK) Hint Takes on Object?. After reading the post, I got question by one of the blog reader. “Hi Pinal, I see in your blog post you have Database ID which is 32767. Everytime I want to get the name of the database from [...]

Read Full Post »

SQL SERVER – Common Table Expression (CTE) and Few Observation

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

This blog post is written in response to the T-SQL Tuesday hosted by Bob Pusateri. He has picked very interesting topic which is related to APPLY clause of the T-SQL. When I read the subject, I really liked the subject. This is very new subject and it is quite a interesting choice by Bob. Common [...]

Read Full Post »

SQL SERVER – SQL Server Management Pack Guide for System Center Operations Manager 2007

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on May 9, 2011 | 2 Comments »

The SQL Server Management Pack provides the capabilities for Operations Manager 2007 SP1 and R2 to discover SQL Server 2005, 2008, and 2008 R2. It monitors SQL Server components such as database engine instances, databases, and SQL Server agents. The monitoring provided by this management pack includes performance, availability, and configuration monitoring, performance data collection, [...]

Read Full Post »

SQL SERVER – What Kind of Lock WITH (NOLOCK) Hint Takes on Object?

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on May 8, 2011 | 5 Comments »

Recently I was talking with Vinod Kumar regarding NOLOCK. Suddenly he asked me do I know what kind of lock WITH(NOLOCK) hint takes on object. The immediate response of mine was that NOLOCK does not take any lock. He responded suggesting that I should think more and answer. I realized right after his suggestion to [...]

Read Full Post »

« Newer Posts - Older Posts »

Follow

Get every new post delivered to your Inbox.

Join 15,279 other followers