Viewing 15 posts - 361 through 375 (of 5,842 total)
I think they are all cumulative.
They are. Cumulative since SQL started (most...
March 6, 2017 at 6:52 am
I figured you had already gotten this one Gail.
sgt500: She is one of the best around at dealing with database corruptions. Pay attention and do as she says...
March 6, 2017 at 6:46 am
I have a requirement where I have to tranform an existing multi-select picklist column.
The source...
March 6, 2017 at 6:42 am
March 5, 2017 at 9:20 am
1) WITH (NOLOCK) allows for dirty reads. So you could have other processes running that are creating conflicts. Concurrency is a tough thing to deal with.
2) I don't...
March 4, 2017 at 10:02 am
Well, if you can have tens of thousands, or perhaps just 1000 or even 100, different ranges to name the CASE construct could become unwieldy and/or result in a long...
March 1, 2017 at 8:16 am
February 28, 2017 at 4:20 pm
Do these wait stats suggest Tempdb pressure? I have...
February 28, 2017 at 4:18 pm
Oh, some more thoughts:
A) What happens if you have NO indexes on those tables? I can't count the number of times I have removed indexes from client temp...
February 28, 2017 at 3:28 pm
February 28, 2017 at 3:21 pm
First quick reply:
why this:IF EXISTS (SELECT 1 FROM #SELECTED_HITS AS H WHERE H.RangeName = 'ANY HIT RANGE')
BEGIN
DELETE S
FROM #SELECTED_HITS...
February 28, 2017 at 3:15 pm
This is regarding Partitioning of a very large table(88 million rows and 25 columns)....
February 28, 2017 at 10:24 am
February 27, 2017 at 6:11 pm
Today we have big problems with Availability Group (AG) synchronization.
Secondary cannot catch up with...
February 27, 2017 at 6:07 pm
Viewing 15 posts - 361 through 375 (of 5,842 total)