Did you update statistics after you upgraded from 2005 to 2008?

JoshDBGuy (3/26/2014)

---

Here's an example of something I'm trying to deal with. There are two sets of data that are unique. Let's say Table 1 consists of Clients. Let's say table...

sten.f.soerensen (3/25/2014)

---

I have a job sending e-mails automatically, and I want to attach a PDF file to these e-mails. That requires the job to place the file to the file...

sten.f.soerensen (3/25/2014)

---

This is an ongoing thing - a job I need to do quite often.

I actually saw this article and I was quite eager to try it - but it...

You have been around here long enough to know that you need to post ddl and sample in a consumable format. If you have forgotten you can find information about...

The table hints and read uncommitted should go away as Gail suggested.

Your function looks very similar to the DelimitedSplit8K with two MAJOR exceptions. You changed the delimiter to nvarchar(255)...

sten.f.soerensen (3/25/2014)

---

Just to clarify: Is there a way for me to avoid using the front-end (Access) - I would like to be able to run the extract directly from the...

sjerromeharris (3/24/2014)

---

Thanks for your post, and the link to the article.

I've tried your suggestion, but its not making much difference to the results that are being returned. I'm expecting...

And while you are at it you might want to drop those NOLOCK hints. Are you familiar with that hint? Do you realize it is more than some magic go...

It would be something like this.

UPDATE [01 - MemberHomeAssignment]

SET [IBNR SNF Days] =

case when AuthDaysByMonth < TotalDaysFromClaims then 0

else AuthDaysByMonth - TotalDaysFromClaims

end

Your code would be a million times...

You can't have an IF ELSE inside of an update statement. The IF operator is used to control...

sten.f.soerensen (3/20/2014)

---

You are right. I just took the script as it was posted on the internet. I too wondered why it was called Timestamp.

However, I have been looking into FILESTREEM...

ramana3327 (3/18/2014)

---

Hi,

I need some help. I am working in a team project.

We have TFS. I mapped only 2 of those to my local machine. When I try to build...

Steve Jones - SSC Editor (3/18/2014)

---

Sean Lange (3/18/2014)

---

1 hour and 15 minutes until vacation. I am ready!!! We are taking the kids on a surprise trip to Branson for a...

Ed Wagner (3/18/2014)

---

Sean Lange (3/18/2014)

---

1 hour and 15 minutes until vacation. I am ready!!! We are taking the kids on a surprise trip to Branson for a few days. See...