Just to validate, you do have log backups in place? If you're not backing up the log frequently enough, you may be seeing excessive growth. Make sure you are backing...

The thing to do is to put your database into source control, just like a piece of code. That way you can always track changes. Even if only you use...

Personally, I'd take no advice from anyone online about licensing. Get in touch with your Microsoft rep to do these validations. No one here is responsible if we get it...

If you look at the input buffers you'll see a stored procedure call and something with an object id: Object Id = 1053962831

I'd start there. What does that Object id...

I wouldn't use a linked server within SSIS. It should be able to connect directly to both servers in question. Is that the cause of the problem? Not sure since...

If it's LiteSpeed, you have to use LiteSpeed to restore it. You can use the utility to uncompress it and then restore it.

Also, if it wasn't LiteSpeed, you can try...

By the way, all these examples are for local variables, not parameters. There is a distinct difference. Unless the statement is recompiled, the values within variables will not be "sniffed"...

SQLKnowItAll (4/2/2012)

---

Lynn Pettis (4/2/2012)

---

Grant Fritchey (4/2/2012)

---

Lynn Pettis (4/2/2012)

---

In SQL Server 2008 and...

Lynn Pettis (4/2/2012)

---

In SQL Server 2008 and newer when running Enterprise Edition,...

To check when the last time statistics were updated, use the STATS_DATE function.

The rules for when auto update fires are a bit more complicated. They're listed here.

If you add...

There's no perfect template for how often you should run backups and how often you should test restores. You need to establish a service level agreement with your business about...

By default SQL Server comes with a whole bunch of Policies built in. To try them out, right click on the Policies folder and select Import from the context menu....

Mad-Dog (4/2/2012)

---

Grant Fritchey (4/2/2012)

---

It sounds like you might be dealing with a case of bad parameter sniffing. Instead of freeing the entire proc cache and the buffer cache (which requires...

Microsoft supplies a free tool, the Upgrade Advisor, which will validate that there are no code or structure issues keeping you from upgrading. I'd absolutely run that before starting any...

We can't see your query and we can't see your execution plan. With no knowledge, it's almost impossible to tell you what to do. As Gail said, look for problems...