I believe the delay could be because of a number of reasons (I have seen delays due to I/O latch issues, wherein the hard-drive was not able to respond in...

SKYBVI (11/9/2010)

---

@ mutthu

There is no blocking

In morning i stop the job, so whats use of killing spid ?

I run this through a maintenance plan-->

update statistics task--> tables and views--> update(all...

I guess the subtle point is that SQL Server will NOT throw any syntax errors because ultimately what the user is making is a logical error.

It's one of those things...

Great question. Thank-you.

Great question!

The Enable broker and new broker were obvious candidates, but it took some Books On line reading to get to NEW_BROKER.

Got to learn something new on Service Broker today....

Hello!

First of all - EXCELLENT QUESTION!

I got it right, however I followed the following reasoning:

1. As most have highlighted - the Query# 1 is obviously "accurate", but does a table...

Indeed. Thanks for the question.

Word of caution for everyone:

Per the MSDN article referred in the answer (http://msdn.microsoft.com/en-us/library/ms188048.aspx), ANSI_NULLS will always be ON in a future version of SQL Server. If...

Really interesting & much needed point to spend the day thinking & debating upon.

I have heard of the following approaches, but have never implemented them myself (the companies I work...

Not a problem at all. You are most welcome.

Have a wonderful rest-of-the-day ahead!

Little Nick (10/6/2010)

---

Hi,

My current system as follow

1. Windows 2003 Server Enterprise Edition 32 bit

2. SQL Server 2005 Enterprise Edition 32 bit

3. Strengthen by RAID 5

4. SQL Server now hosting 5...

I am assuming that the table name is ImmMailToSend. With this assumption, does the following work for you?

EXEC sp_msforeachdb 'USE ? IF EXISTS (SELECT * FROM sys.tables st WHERE st.name...

Hello!

Thank-you so much for providing this platform. The site is very helpful - I cannot count how much I have learnt from here and the community associated with it.

The community...

Petrushenya Pawel (10/7/2010)

---

Thank you for this article.

One note regarding to the modifications of stored procedures through drop/create technique.

When you behave in such a way you will lose security settings for...

Nakul Vachhrajani (10/6/2010)

---

This is bound to happen.

Per BOL (http://msdn.microsoft.com/en-us/library/ms188351.aspx):

Changing any part of an object name can break scripts and stored procedures. We recommend you do not use...

This is bound to happen.

Per BOL (http://msdn.microsoft.com/en-us/library/ms188351.aspx):

Changing any part of an object name can break scripts and stored procedures. We recommend you do not use this statement...