Viewing 15 posts - 4,696 through 4,710 (of 49,552 total)
Ian_McCann (9/23/2015)
When MyTable was used in the restored database the log_reuse_wait_desc always showed 'Replication' and cdc had to be set up to clear the blockage.
Yup. CDC uses the replication log...
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 23, 2015 at 6:10 am
Word of advice:
CREATE TABLE #temp
( Id int, Name char(30), YesNo bit NOT NULL)
Also you may want to review the first section of this article, before your coding pattern causes...
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 23, 2015 at 5:15 am
Ah!
https://msdn.microsoft.com/en-us/library/ms186858.aspx
<change_data_capture_WITH_option>::=
| KEEP_CDC
https://msdn.microsoft.com/en-us/library/ms178615.aspx
KEEP_CDC
Supported by: RESTORE
KEEP_CDC should be used to prevent change data capture settings from being removed when a database backup or...
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 23, 2015 at 4:47 am
Yup. It's a delete, it has to take exclusive locks and hold them to the end of the transaction.
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 23, 2015 at 4:32 am
The isolation level's irrelevant. Isolation level affects what locks read queries take and how long they're held for. Since the only selects are part of the insert and are from...
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 23, 2015 at 4:26 am
Check that you restored the correct database. If there are multiple backups in that file, your restore statement would have restored the oldest of the backups.
RESTORE HEADERONLY FROM DISK =...
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 23, 2015 at 3:21 am
Connect via the Dedicated Administrative Connection. Connections made to that don't fire login triggers.
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 23, 2015 at 3:04 am
Scan density was removed because it was confusing. Extent fragmentation is only reported for heaps now, for much the same reasons. In the old Show_Contig, there were too many values...
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 23, 2015 at 3:03 am
Known bug.
https://support.microsoft.com/en-us/kb/960770
It's not actual database corruption, the page_verify setting is immaterial. Test the traceflag which the connect item mentions, see if that fixes things.
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 23, 2015 at 2:59 am
If you query the plan cache, what's in there? Lots of single-use ad-hoc queries? Lots of object plans?
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 21, 2015 at 7:04 am
Why are you still using sysprocesses? It's the SQL 2000 function, it doesn't show any newer properties or columns
The head will be the one which is referenced by other sessions...
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 21, 2015 at 6:56 am
Kristen-173977 (9/21/2015)
I had assumed the Heap Rebuild was just going to update all the non-clustered indexes with the revised row-identifier and nothing else.
That would be extremely inefficient, to update every...
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 21, 2015 at 5:36 am
You'll need to create the temp table first, then run
INSERT INTO ...
EXEC <stored proc>
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 21, 2015 at 5:35 am
How do I tell which row goes with which row? Is it always the case that the CPT for src of 'b' will be the CPT for the src of...
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 21, 2015 at 4:44 am
Kristen-173977 (9/21/2015)
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 21, 2015 at 4:43 am
Viewing 15 posts - 4,696 through 4,710 (of 49,552 total)