Nice but easy one.

Question is average but conversation about the topic & date format is great. Thanks

UMG Developer (11/5/2010)

---

So, triple the time, and almost 4 times as many logical reads. I guess I won't be using it for this purpose. (Not to mention it is much...

Good question. I learned fn_helpcollations function & its usage.

Nice question. Thanks

Due to Internet we learn lot, share our knowledge, make SSC type of solid group, we can help others in the areas that we know or want to know. But...

WayneS (11/1/2010)

---

Jeff Moden (11/1/2010)

---

ps. (10/29/2010)

---

You have already gone through the places where i would have gone to search for that answer:-P. I would probably do what Kimberly says. like shrinking...

Good Question & Nice Explanation. Thanks 🙂

Thanks for the script.

If you want to disable all the constraints of the database then you can simply use:

EXEC sp_MSforeachtable @command1 = 'alter table ? nocheck constraint all'

Carlo Romagnano (10/29/2010)

---

So it seems that the explanation of the question is wrong, as it states that the pre-increment operator is not used in SQL Server. SQL Server uses however...

Nice question. Thanks

select dateadd(yy, -1, getdate()) -- this is the easiest way to go back 1 year. same way for month: select dateadd(month, -1, getdate())

SanDroid (10/27/2010)

---

Mayank (10/26/2010)

---

Normally to enable the Broker Service, you need to simply use : "ENABLE_BROKER"

But when you restore the back up of database db1 to database db2, and after that...

Really nice article.

We are using XML but we were not facing any issue because we are not passing date type value. Thanks for pointing the issue.

Thanks for sharing the link. nice article for NTEXT vs NVARCHAR(MAX).