Viewing 15 posts - 10,321 through 10,335 (of 49,552 total)
Define 'not working'?
What exactly did you do? What behaviour are you expecting? what are you seeing?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 21, 2014 at 2:40 am
sys.dm_exec_requests join sys.dm_exec_sessions cross apply sys.dm_exec_sql_text.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 21, 2014 at 1:38 am
As Grant said
Grant Fritchey (1/17/2014)
Any login can have a query that causes blocking.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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';
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 21, 2014 at 12:11 am
Jeff Moden (1/20/2014)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 20, 2014 at 8:07 am
It'll be on whatever filgroup is defined as the default one.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 20, 2014 at 7:21 am
Viewing 15 posts - 10,321 through 10,335 (of 49,552 total)