I see function... the rest...

If it's multi-statement table valued functions, it's because they're notorious for bad behavior and poor performance.

Let's also be careful about parallelism. It's a good thing. It's just that some queries are set as parallel that shouldn't be. Adjusting the cost threshold for parallelism up from...

It goes back to what has already been said. Look to query the cache to see which queries in cache are using the most CPU and/or taking the longest. Or,...

GilaMonster (3/11/2014)

---

Koen Verbeeck (3/11/2014)

---

Grant Fritchey (3/11/2014)

---

By the gods, people get hung up on the weirdest darned things. They can focus like a laser on stuff that's just a waste of...

By the gods, people get hung up on the weirdest darned things. They can focus like a laser on stuff that's just a waste of time. It's weird.

Don't worry about that.

Are you storing integer style...

While I'm honestly not crazy about this approach in general, it's not an end of the world scenario and, SEQUENCE can absolutely do what you're asking for. Personally, I'd do...

jaminbw (3/11/2014)

---

Gary Varga (3/10/2014)

---

I find it frustrating that, from the software development side, when attempting to engage the DevOps (under whatever moniker) to find out how the development team can...

Sure. If you're using that you can even have it do the copy across the network for you. Step 3 of the Wizard when you're setting up backups includes "Copy...

While index defrags are quick, easy and make you feel like you're doing something, they're very, very seldom of any real use when it comes to performance unless you're seeing...

Performance improvement over what? If you need to...

Could it be replication? Sure, it could be. But we don't know what's running slow from what you've told us. You need to capture the general wait statistics to understand...

The best approach is to take the backup locally on the server with the SQL Server instance, and then copy that backup across the network. The reason is that network...

sp_updatestats uses the defaults which is for SQL Server to make a calculation for which sample rate to use. If you need to take more direct control, you have to...