ChrisM@Work (3/23/2016)

---

How many of you contractors have been so taken with a gig that you've signed up as a permie? I just did. I never expected that.

The idea of presenting...

1. Create a new file group

2. Add a file to the...

You can use ALTER DATABASE to add a file, the example below adds a file (64Mb) "MyNewDataFile"...

LerxtDBA (3/22/2016)

---

Originally it was a parameter and it was misbehaving even then.

I didn't think about the dynamic SQL route but that's because I'm mostly opposed to it on principal. ...

Glad you are fine mate, still trying to...

LerxtDBA (3/22/2016)

---

All those are incidental at this point. The "good" plan has a fixed value because it's a production stored proc. The bad plan has those differences because...

That's better, BTW you can use SqlSentry Plan Explorer to anonymize the execution plans.

One more thing, could you post...

Quick suggestion based on the fact that Zero date is Monday 1900-01-01.

😎

SELECT

CONVERT(

...

Please post the actual execution plans, these images of the graphical plan representation are just like...

Luis Cazares (3/21/2016)

---

The major difference from the 2 runs seems to be the physical reads from a table. When it's slow, it's reading 12-13 thousand pages from disk. When it's...

drew.allen (3/21/2016)

---

Eirikur Eiriksson (3/21/2016)

---

kuopaz (3/21/2016)

---

I see, thanks. As it's scanning the tally table row-by-row from start to the predicate value, the order of N may be important in some cases...

scott clemons (3/21/2016)

---

First time posting this type of info. Wasn't sure if I should provide the computer, domain or user specific info, so I replaced with <#####>. Hope...

Here is an alternative[/url]

😎

kuopaz (3/21/2016)

---

I see, thanks. As it's scanning the tally table row-by-row from start to the predicate value, the order of N may be important in some cases (not this example),...

scott clemons (3/20/2016)

---

I have read countless articles on the internet about fixing this error, but nothing works. Sorry, if there is an easy answer, but I can't figure it...