Paul White (8/15/2013)

---

Jeff Moden (8/15/2013)

---

While I've found some workarounds for it, it seems bloody incredible to me that you cannot rebuild a partitioned index at the partition level in an...

Everything Gail said.

But, if you do have a problem with a plan in cache (again, nothing to do with tempdb), then it is possible to run DBCC FREEPROCCACHE and pass...

Shortest possible answer, do your best.

There is no easy way to deal with people who are unreasonable. But, work your communication skills. Develop a tough skin. Do what you can....

This is a classic, it depends problem. Depending on how you structure the indexes and how your data is being loaded, yes, clustered indexes actually speed up insert operations. But,...

Or, if it's not causing any problems, don't fix it. I wouldn't recommend someone to automatically rebuild 1000+ indexes every week. Instead, I'd probably have a script that only rebuilds...

Nothing really. The secondary will be somewhat slower for I/O. If you have synchronous calls that might cause some problems. Async calls will work the way they're intended. In general,...

One way to do it would be to take advantage of PowerShell remoting. You can pull from a list of databases (or generate them) and then run the commands you...

You'd have to define "what it does" better. I can look at the code and quickly get a sense of how it was written. Are there corellated sub-queries in the...

One of those instances where I wish we could vote on answers. SQL Surfer has nailed it. When you're creating that backup in the GUI, just generate the script.

Yeah, my company is using it for several projects right now. It's working for what we need. If your needs are very traditional, then WASD isn't for you. I do...

jasona.work (8/14/2013)

---

I'd bet your just a big softy in...

Koen Verbeeck (8/14/2013)

---

And this post marks my 10,000th one on SSC! 😎 😎 :w00t: (and some of them were actually useful!)

Now that I'm one of the big boyz and Grant...

Say the people quaking in their boots.

Ha! I hope you can make it to the Summit.

Rearranging partitions is a completely different question than sharing a partitioning function. And yeah, changing the partition will cause all sorts of interesting blocking and locking, but that's to be...

Is the process being blocked by other processes? What is that process waiting on?