Define 'not working'?

What exactly did you do? What behaviour are you expecting? what are you seeing?

sys.dm_exec_requests join sys.dm_exec_sessions cross apply sys.dm_exec_sql_text.

Do you want your databases to go into the RESTORING state after a backup?

The Database would be...

In other words, this:

When you check the 'backup...

As Grant said

Tune your indexes, tune your queries. Short-lived blocking isn't a problem, long-term blocking is often due to inefficient queries. If you can't tune the queries or doing so doesn't provide...

DECLARE @number AS NUMERIC(4,2) = 2.5;

SELECT @number;

IF (ROUND(@number,0) = @number)

PRINT 'whole number';

ELSE

PRINT 'has fractional component';

Yuk, traceflag 1204. That traceflag doesn't give enough information and makes debugging deadlocks harder than it should be.

Can you turn traceflag 1204 off, turn 1222 on instead and, if the...

To be honest, I think backup devices are a leftover from tape days (as in when backups were done to tape directly). There's little use I see for them with...

Jeff Moden (1/20/2014)

---

On the other hand, I've found that it almost takes the same amount of time to filter out such tables as it is to try to defrag them...

clyde_mcmurdy (1/20/2014)

---

My apologies to the OP for the thread hijack.

Should I start a new one?

"... ProcedureName WITH RECOMPILE means that the procedure's plan is never cached at all"

That's...

You'd need to explain more what you did for me to be able to say what happened there.

exec sp_recompile 'procedure name' removes that plan from cache completely. I have a...

It'll be on whatever filgroup is defined as the default one.

Generally, not possible.

You can query sys.dm_db_index_usage_stats per database and check the dates in there, but that's only since the last time the DB was started (typically last time SQL Server...

No. Not unless I had an exceptionally good reason.