Viewing 15 posts - 16,561 through 16,575 (of 49,552 total)
When I initially read your reply, it seemed to say that without implicit transactions or begin tran, there was no transaction, which is of course not true, so just wanted...
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
September 20, 2012 at 1:34 am
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
September 19, 2012 at 3:44 pm
opc.three (9/19/2012)
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
September 19, 2012 at 3:17 pm
sunny.tjk (9/11/2012)
We've a very large table and I'm thinking to partition it.
Why?
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
September 19, 2012 at 3:10 pm
Please note: 4 year old thread. Please don't spam old threads with unrelated sites (that site's Oracle)
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
September 19, 2012 at 10:38 am
bitznbitez (9/19/2012)
Will SQLServer still be able to insert to tables in the filegroup even though G is full by using the space in F ?
Yes. Set the file on G...
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
September 19, 2012 at 10:33 am
Just buy a 3rd party monitoring tool. Redgate's SQLMonitor is web-based.
Otherwise you'll be spending months writing your own.
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
September 19, 2012 at 2:12 am
Report and ask Steve to delete. Or you could just edit and remove whatever you shouldn't have posted.
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
September 19, 2012 at 2:11 am
I like to keep log backups going back 2 full backups at least. That way, if, with the backups you listed, I had to restore to Monday and the sunday...
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
September 18, 2012 at 1:49 pm
Worth noting that optimise for ad-hoc only affects ad-hoc batches, not procedures.
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
September 18, 2012 at 1:46 pm
Query, table definitions, index definitions and execution plan please.
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
September 18, 2012 at 11:33 am
In that case, pack beer. Good European beer, not American beer.
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
September 18, 2012 at 10:08 am
Depends. Are you seeing deadlocks on production that you want to investigate and resolve?
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
September 18, 2012 at 7:38 am
Not following you.
Deadlock detection and resolution is automatic.
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
September 18, 2012 at 6:38 am
You don't need traceflag 1204 if you're using extended events to get the deadlock.
There's probably no object name because it's a temp table and dropped before the deadlock graph was...
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
September 18, 2012 at 6:19 am
Viewing 15 posts - 16,561 through 16,575 (of 49,552 total)