The original version fails because it has to do the DateAdd on impossible numbers before it can compare it to the final date. There's simply no way for it...

Stefan Krzywicki (4/20/2012)

---

GilaMonster (4/19/2012)

---

Personally I'm voting for 'ignore the trolls'

#declare NewTopic;

Who plays MMOs and which ones?

I've just quit the one I played for a few years, they added a...

GilaMonster (4/19/2012)

---

Personally I'm voting for 'ignore the trolls'

#declare NewTopic;

Who plays MMOs and which ones?

I've just quit the one I played for a few years, they added a 'pay to...

Reliability will depend on your iSCSI set-up. It can be very reliable, or it can be a freaking nightmare, all depending on how it's set up and who's in...

mtassin (4/19/2012)

---

GSquared (4/19/2012)

---

Once the data is on the remote servers, I have various T-SQL jobs in SQL Agent that do all the more complex transformations and distribute the data to...

You might be able to put something in a DDL trigger on the Create_Database event. I haven't tried that, but it sounds like it should work.

cfradenburg (4/19/2012)

---

So you would argue that behavior on forums or other social media sites...

Cool. Submit it as an article (check the Write for us link to the left). That'll make it easier to find than a forum post, if someone needs...

I had poor grades in school, at least up to my senior year of high school. Dropped out of college after one abysmal quarter. Does that mean I...

I've run into that same argument from a dev before. He insisted that building a temp table from a filtered primary table, then updating it from the rest of...

Select statements aren't really a good way to test isolation levels. Even in Read Committed, all they take is shared locks, which means two Select statements don't interfere with...

You'll need to get ahold of Microsoft support for that then. If the installation media work on some machines but not on others, there's something wrong with the machines...

aaa-322853 (4/17/2012)

---

Thanks for your replies guys!

This is an outgoing process therefore I need to replace like for like ideally. I did try the casting as decimal route but without knowing...

The services won't list themselves as being dependent. You have to tell them they are. SQL Server assumes that the server hardware will have drives attached by the...

Whoever has the rule about Full backups only, needs to be educated on the point that they either need to modify that policy (and there's no good reason not to),...