Viewing 15 posts - 12,211 through 12,225 (of 49,552 total)
Please run the following and post the full and complete, unedited output.
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
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 2, 2013 at 10:55 am
Brandie Tarvin (8/2/2013)
How many people (besides Jeff and myself) have written SQL Spackle articles?
Not me, my preference is deeper technical articles (when I write at all these days)
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 2, 2013 at 6:35 am
Phil Parkin (8/2/2013)
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 2, 2013 at 6:35 am
kevin_nikolai (8/2/2013)
For SQL Reports stored procedures you most definitely want to use "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED".
Because it's really, really important for all reports to occasionally return inconsistent and...
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 2, 2013 at 3:09 am
Eugene Elutin (8/1/2013)
I guess missing and double counting of rows could be part of "Dirty Read" definition.
No it's not. It's a second effect that Books Online doesn't mention and which...
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 1, 2013 at 12:31 pm
Eugene Elutin (8/1/2013)
3. Dirty read may not read data which was committed long ago...
That's not a dirty read. The definition of dirty read is reading uncommitted data.
That nolock can miss...
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 1, 2013 at 7:50 am
ben.brugman (8/1/2013)
For my understanding:1. Dirty reads is the reading of data which is not (yet) committed.
2. NOLOCK hint reads data which is not committed.
Correct.
Is there example code which does...
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 1, 2013 at 4:24 am
L' Eomot Inversé (7/31/2013)
and about 175 picked the equally non-existent although less implausible sounding DBCC CHECKFILEGROUP;
http://msdn.microsoft.com/en-us/library/ms187332.aspx
DBCC CHECKFILEGROUP (Transact-SQL)
Checks the allocation and structural integrity of all tables and indexed views in...
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
July 31, 2013 at 10:49 am
Jeff Moden (7/30/2013)
GilaMonster (7/30/2013)
There is no requirement that a DB be in single user mode or quiesced to do a shrink file.
That's true but it makes it a heck 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
July 30, 2013 at 4:30 pm
You can't create global variables in SQL Server.
What are you trying to do? Maybe there's an alternative...
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
July 30, 2013 at 11:22 am
Greg A Goss (7/30/2013)
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
July 30, 2013 at 9:39 am
The correct solution here is to run checkDB with repair allow data loss. It won't actually lose any data, it's just that the particular fix requires that option.
It is discussed...
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
July 30, 2013 at 9:20 am
The Lock Pages in memory privilege allows SQL to allocate memory that is not pagable. That memory is allocated with the AWE APIs (no matter if it's 32-bit or 64-bit)
Hence,...
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
July 30, 2013 at 6:56 am
Please run the following and post the full, complete and unedited output.
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
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
July 30, 2013 at 6:51 am
There is no requirement that a DB be in single user mode or quiesced to do a shrink file.
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
July 30, 2013 at 6:49 am
Viewing 15 posts - 12,211 through 12,225 (of 49,552 total)