There's unlikely to be a performance gain from partition whether you put the partitions to one filegroup or to multiple. Partitioning is not a performance feature, it's for data management,...

No, because leading zeros are meaningless on numeric data. If you have something that should have leading zeros, it should be stored as a string, because it's not numeric data.

MOC courses aren't books. They're in-person training courses offered by official trainers, often working for the large training providers.

Considering how much money I've thrown at that...

Any particular reason? Merge is a pain to write, no more efficient than separate statements in most cases, and has been found to have assorted bugs in it over the...

What I'd suggest is, instead of killing sessions, and instead of using the Query Govenor (users aren't going to voluntarily set that, and server-wide means *everything* gets it), is to...

Please note: 6 year old thread

That was true 6 years ago, not now.

If you're going to copy-paste...

Please note: 9 year old thread.

15. Dates and Times. New data types: Date, Time, Date Time Offset.

16. File Stream. New data type VarBinary(Max) FileStream for managing binary data.

17. Table Value...

Scalar UDF vs built-in function on 100 million rows.

Disclaimer, I had to run this on a different machine to the 1 million row test. 1 million was done on a...

Grant Fritchey (9/9/2016)

---

BrainDonor (9/9/2016)

---

I've been following that thread since it started - fascinating. I'll give him full marks for determination ("Tis but a scratch" type of determination), but I'm so...

Call Microsoft Customer Support and open a case. Stack dumps are hard to debug, CSS has tools that we don't. Make sure you're on the latest SP & CU first.

The Dixie Flatline (9/8/2016)

---

If any of you carnivores haven't tried "lacquered" bacon, you're missing a treat!

Edited to add:

You can't divide by zero...

You can't divide by zero...

You can't divide by zero...

You...

A scientific model that I've...

Gregory Hart (9/8/2016)

---

Not all UDF are bad, ... if correctly written, they can be tremendous for establishing and persisting in standards and also in code control when modifications occur to...

Gregory Hart (9/8/2016)

---

Such use of a UDF is ideal, and will respond at least as efficiently as a standard SQL function. Check it out, ... do a query execution plan...