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?

If you've issued a kill command, you now have to wait for the rollback to complete. That can take as long, and sometimes longer, than the original transaction. So, if...

Usually you'll be looking at one of two scenarios. You're going to be accessing the WASD database from a web page, also residing in Azure. There you don't have to...

Both are "safe" approaches in that a given partition scheme can be applied to different tables. You just create a function (from the Books Online):

CREATE PARTITION FUNCTION myRangePF1 (int)

AS RANGE...

Order of preference:

Tune the query

Adjust the indexing

Materialized view

Staging table

Analysis services

But the order of preference mostly also reflects how often these are used and how well each works (although SSAS works...