Viewing 15 posts - 10,321 through 10,335 (of 49,566 total)
Define 'not working'?
What exactly did you do? What behaviour are you expecting? what are you seeing?
January 21, 2014 at 2:40 am
sys.dm_exec_requests join sys.dm_exec_sessions cross apply sys.dm_exec_sql_text.
January 21, 2014 at 2:25 am
Welsh Corgi (1/21/2014)
So I should turn it off on all backup maintenance plans?
Do you want your databases to go into the RESTORING state after a backup?
The Database would be...
January 21, 2014 at 1:49 am
In other words, this:
GilaMonster (1/19/2014)
Finally a rare reason is someone, after the restore, runs BACKUP LOG ... WITH NORECOVERY, either manually or in a job.
When you check the 'backup...
January 21, 2014 at 1:38 am
As Grant said
Grant Fritchey (1/17/2014)
Any login can have a query that causes blocking.
January 21, 2014 at 1:18 am
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...
January 21, 2014 at 1:05 am
DECLARE @number AS NUMERIC(4,2) = 2.5;
SELECT @number;
IF (ROUND(@number,0) = @number)
PRINT 'whole number';
ELSE
PRINT 'has fractional component';
January 21, 2014 at 12:23 am
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...
January 21, 2014 at 12:13 am
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...
January 21, 2014 at 12:11 am
Jeff Moden (1/20/2014)
January 21, 2014 at 12:05 am
clyde_mcmurdy (1/20/2014)
Should I start a new one?
"... ProcedureName WITH RECOMPILE means that the procedure's plan is never cached at all"
That's...
January 20, 2014 at 2:17 pm
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...
January 20, 2014 at 8:07 am
It'll be on whatever filgroup is defined as the default one.
January 20, 2014 at 7:51 am
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...
January 20, 2014 at 7:37 am
richardmgreen1 (1/20/2014)
In your experience, is it a change you would make?
No. Not unless I had an exceptionally good reason.
January 20, 2014 at 7:21 am
Viewing 15 posts - 10,321 through 10,335 (of 49,566 total)