Viewing 15 posts - 17,161 through 17,175 (of 49,552 total)
If it is just a single truncate and a single select (neither in a transaction), that shouldn't deadlock. For a deadlock, the SQL deadlock detector needs to be able to...
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
August 15, 2012 at 9:24 am
If you are creating an index on a column that you know is unique, make the index unique. If you're creating an index on a column that's not unique, then...
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
August 15, 2012 at 9:18 am
SQLSACT (8/15/2012)
Would fragmentation affect this process negatively?
If the range scan is large enough and is from disk, yes probably.
If we had a query like this: select Col1 from Indexing2 where...
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
August 15, 2012 at 1:48 am
Yes as I showed in the screenshot in the post right above there's the begin xact and commit xact log records (which would be your two per cycle).
This is what'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
August 15, 2012 at 1:41 am
Homework?
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
August 14, 2012 at 3:23 pm
Ah, didn't notice the initial quote.
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
August 14, 2012 at 9:21 am
I don't see anything wrong there. Is that the entire select? Could you perhaps post the table structure and just one row of data (as an insert) so that I...
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
August 14, 2012 at 9:05 am
That's the output given by traceflag 1204, which is a SQL 2000 and before trace flag. Near-impossible to interpret and missing information.
Please get the deadlock graph from the extended events...
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
August 14, 2012 at 8:55 am
Love the story snippet.
#declare TopicChange
New article over at simple talk - SQL Server howlers. Partitioning, indexing, hints and server settings. https://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/
</shameless plug>
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
August 14, 2012 at 8:52 am
sqlharmony (8/14/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
August 14, 2012 at 8:48 am
The query stats DMV is fine if you just want a rough idea. It only returns data for queries whose plans are still in cache, so any that were never...
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
August 14, 2012 at 8:19 am
DatabasePropertyEx is old, it's SQL 2000 or earlier and in SQL 2000 there was only the suspect state. Recovery_pending was added in SQL 2005. I much prefer using sys.databases for...
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
August 14, 2012 at 7:43 am
Could you elaborate more on the question 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
August 14, 2012 at 6:16 am
It just redirects output from some commands to the client. It's probably a monitoring app that's enabling and disabling it.
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
August 14, 2012 at 6:15 am
tilew-948340 (8/13/2012)
But... when you say "not SIMPLE database restore" you mean "not easy to do" or you reference to the type of DB (simple vs full)?
Not easy to do. Partial...
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
August 14, 2012 at 2:18 am
Viewing 15 posts - 17,161 through 17,175 (of 49,552 total)