Obviously something that is running requires using a lot of tempdb space, maybe from a large sort, or something. Why would you want to shrink the tempdb back down? If...

It looks to me like they are talking about moving data from a .NET application back into the SQL Server not from one SQL Server to another. For example, you...

The other option would be to upgrade your 2008 server to 2008 R2. Of course that would require a license purchase unless you have SA, as well as testing.

Thanks for the question, I like these easy points!

In your article you say:

Since this article is focusing on practical uses of PatIndex, I will only be checking to see if the string value contains digits only with the...

CELKO (3/31/2011)

---

Cast the segment_id to integer and do the subtraction:

('123', 0.00, 0.10, 90, ('123- 1))

('124', 0.01, 0.11, 92, ('124- 2))

('125', 0.02, 0.12, 95, ('125- 3))

('127', 0.04, 0.14, 95, ('127- 4))

('128',...

Here is an UPDATE version of what Howard provided:

UPDATE Target

SET ChargedYN = 'N'

FROM tmpCustomers AS Target

INNER JOIN rowstoupdate AS Source

ON Target.CustomerNo =...

That link to request the CU looks correct but it looks like Microsoft has pulled the main CU1 update.

The CU2 update is still available here: http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=2072493&kbln=en-us

And CU6 (the latest) is...

My guess is that you are using the SELECT .. INTO method, and that will keep a schema lock on the DB that prevents a lot of things but not...

I agree with Wayne, iTVFs are nice because you can actually SELECT from and JOIN (CROSS APPLY) to them, which you can't do with SPs.

Nicole Garris (3/30/2011)

---

Actually, backing up the .mdf and .ldf files does provide a sufficient backup. The problem is that you have to shut down SQL Server to be able to...

Thanks for the question, it is always good to research and learn something new!

Richard Warr (3/30/2011)

---

I tried running the code and an error message popped up saying

"Your approach to SQL is wrong. BIT flags are things we left behind in assembly language. "...

Essentially what you need is a running total. You can read about that in an article from Jeff Moden here: http://www.sqlservercentral.com/articles/T-SQL/68467/

So something along this should for for you:

--Determine where each...

Thanks for the question, however technically none of the answers are correct, as that view can not be indexed because all the objects aren't referenced by two-part names:

FROM...