Viewing 15 posts - 12,211 through 12,225 (of 49,558 total)
Please run the following and post the full and complete, unedited output.
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
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)
August 2, 2013 at 6:35 am
Phil Parkin (8/2/2013)
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...
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...
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...
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...
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...
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...
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...
July 30, 2013 at 11:22 am
Greg A Goss (7/30/2013)
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...
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,...
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
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.
July 30, 2013 at 6:49 am
Viewing 15 posts - 12,211 through 12,225 (of 49,558 total)