OK, that's weird. It just worked the second time? Huh... I'm stumped. That error is pretty explicit. It's not possible that someone has been mucking with the server?

GilaMonster (11/13/2014)

---

g.britton (11/13/2014)

---

SeanNerd (11/13/2014)

---

My question is about indexing strategy for the following scenario:

I have a table where we cannot use the typical int identity primary key column. The table can...

A little confused by what's going on. Red Gate (good choice) SQL Compare doesn't do backups and restores. It just compares databases to other databases, backups, scripts, source control, and...

Just make sure you carefully document what you're removing and have it stored somewhere that everyone remembers.

Based on the fact that you're seeing performance increase after FREE_PROCCACHE, while it may be other things, it's more than likely first and foremost, bad parameter sniffing. You need to...

Then that's odd. I can't recreate it. Here's what I did. I opened a session and used this code:

CREATE PROCEDURE dbo.TestingColumns

(@SalesOrderID INT)

AS

SELECT soh.SalesOrderID

FROM Sales.SalesOrderHeader AS soh

WHERE soh.SalesOrderID = @SalesOrderID;

Then...

The wide index is less efficient in terms of storage, but in terms of covering, it'll be the same. Either an index has all the columns needed to satisfy a...

I'm honestly not sure. It sounds like something was cached at the client of the other session. Recompiling the procedure from the first session would invalidate the execution plan in...

At the end of the backup process, any transactions that have completed while the backup was running will be brought into the backup. The recovery step of the restore process...

I'd suggest taking a look at the Minion scripts[/url] by the Midnight DBA team. That gives you a lot more control than the maintenance plans.

First, the server has to be part of a failover cluster (the service, not the physical set up). Then you go to Configuration Manager to enable availability groups. This is...

Think of each database as a service. A given service has a contract that says for these inputs, you get these outputs. With that in mind, any given access mechanism...

My query performance tuning book also talks about the dangers of multi-statement table valued user defined functions. The newest one has the most discussion around that.

If you don't have experience in development overall, then I'd suggest following the suggestions in the post above. If you're trying to understand how to run the debugger within T-SQL,...

It depends. One thing that the optimizer takes into account is foreign key constraints. Since you can't have those across databases,...