Viewing 15 posts - 9,496 through 9,510 (of 49,571 total)
Steve Jones - SSC Editor (3/30/2014)
NOTE that DBCC DBREPAIR is not recommended. I would be very careful about using any of these tools.
More drive-by spam. This stuff gets posted on...
March 30, 2014 at 2:22 pm
poratips (3/28/2014)
Only my concern is that it might cause corruption, right?
Shrinking TempDB can, but since that's the opposite of what you need to do (make it bigger, give it more...
March 30, 2014 at 6:55 am
INT has a higher precedence than string, the string will convert to int, so if that is an int column (which we don't know), then the query will be essentially
SELECT...
March 28, 2014 at 3:25 pm
Eirikur Eiriksson (3/28/2014)
SELECT @ProductID= ProductID FROM Product WITH (NOLOCK) WHERE SalesID= '@salesId' and Product = 'Clothes '
Apart from not being SARGable...
All the predicates in that query are SARGable. They're all...
March 28, 2014 at 2:55 pm
Shrinking (making smaller) a full file (too small) is a little counter-productive. It's like reducing the speed you're driving at because it's taking too long to get where you're going.
You...
March 28, 2014 at 2:40 pm
Jack Corbett (3/28/2014)
March 28, 2014 at 2:39 pm
Ed Wagner (3/28/2014)
Grant - You have booth babes??? :w00t:
Grant *is* the booth 'babe' 🙂
March 28, 2014 at 9:16 am
Can you post the table definition and the procedure?
March 28, 2014 at 7:02 am
Ed Wagner (3/28/2014)
WayneS (3/27/2014)
Luis Cazares (3/27/2014)
I'm afraid that this database is full of these pieces of sh code...
March 28, 2014 at 6:58 am
dwain.c (3/28/2014)
Ville-Pekka Vahteala (3/27/2014)
Luis Cazares (3/27/2014)
I'm afraid that this database is full of these pieces of sh code...
March 28, 2014 at 6:52 am
Two things.
They're not hard drive recovery specialists. If you don't have an mdf and an ldf which doesn't attach or a backup which won't restore (a full-sized backup, not the...
March 28, 2014 at 12:28 am
mberran (3/27/2014)
GilaMonster (3/27/2014)
What wait types are you seeing on your data modification queries?What do the disk latency counters look like (physical disk sec/read and physical disk sec/write)?
I requested the information...
March 27, 2014 at 10:59 am
Koen Verbeeck (3/27/2014)
should a table always be clustered instead of a heap?
Yes, in vast majority of cases.
Heap has the forwarded records and the non-deallocation of pages to contend with, scans...
March 27, 2014 at 8:35 am
Viewing 15 posts - 9,496 through 9,510 (of 49,571 total)