And for those interested, you can run an upgrade directly from CTP3.

So you have a WHERE clause against a 30,000 row multi-statement table valued function... To quote a famous man "Well there's your problem.[/url]"

Seriously though, you may have any number...

Thanks.

I had no idea I was doing good work.

Well done.

Exactly.

Daryl AZ (11/18/2011)

---

I understand the value of a clustered index.

I was questioning whether switching from a clustered index on an Identity to a clustered index on non-sequential keys would affect...

I would strongly recommend having a clustered index on the table. It doesn't have to be the primary key, but by and large, in most circumstances, a table with a...

Gianluca Sartori (11/18/2011)

---

Grant Fritchey (11/18/2011)

---

Gianluca Sartori (11/18/2011)

---

Another way could be using a loopback linked server and execute the procedure as a pass-through query: http://spaghettidba.com/2011/11/16/discovering-the-output-of-dbcc-commands/

The technique described there uses DBCC commands,...

Gianluca Sartori (11/18/2011)

---

Another way could be using a loopback linked server and execute the procedure as a pass-through query: http://spaghettidba.com/2011/11/16/discovering-the-output-of-dbcc-commands/

The technique described there uses DBCC commands, but it works with...

That's just so open-ended... How are you at query tuning? Are you an SSIS expert? What about hardware, do much with hardware? Networking? Virtuals? SANs? Performance Monitoring? Operating Systems? The...

You can't alter that out of a table. So, you have to create a second table with the structure you want, copy the data across, drop the original table, rename...

I'm not even going to try to wade through all that.

Here's a question. How many rows are returned by that multi-statement table valued user defined function? I ask because, if...

You can also enable traceflag 1222 which will output deadlock info to the error log in SQL Server whenever a deadlock occurs. This is frequently easier than trying to capture...

You can do network backups. As long as the the SQL Server service account can see the location that you are backing up to, you're golden.

However, be sure of the...

If the internal proc returns a data set... there's not much you can do. What is it that you're trying to do with the procs?