Viewing 15 posts - 1 through 15 (of 57 total)
We're starting to use JSON more and more so I can image I want to use code like this in the near future.
July 18, 2011 at 3:20 am
I made a little change to the last script to also include the where clause of a filtered index. I also removed the collate because this didn't work for me.
January 13, 2011 at 3:36 am
The snapshot isolation level didn't work for the foreign key blocking. But we are still going to do some tests with it for the several other blocking situations on which...
October 29, 2010 at 1:30 am
I'm trying to set the snapshot isolation level, but unfortunately this takes some time 🙁
So in the meanwhile I googled it and found that someone else says it won't help:
October 28, 2010 at 8:39 am
Have you tried changing the order of the clustered index. You say you did try this index:
(IntDate ASC, CustomerID ASC, PartitionID ASC) ON[PartitionedTables](PartitionID)
But have you tried putting the PartitionID fist?...
May 4, 2010 at 2:40 am
February 22, 2010 at 4:13 am
Paul White (2/22/2010)
February 22, 2010 at 4:08 am
Sander A. (2/22/2010)
Sander: you said...
February 22, 2010 at 2:20 am
Sander: you said that the slower...
February 22, 2010 at 12:58 am
[quote-0My honest recommendation is that you seek the services of a good consultant at some stage to help you.
There is a big change we will do that in the near...
February 21, 2010 at 5:55 am
Oke, i will post the queries and the statistic output, maybe you can tell me something more about it. As you can see the query cost of the first query...
February 21, 2010 at 4:32 am
A named check doesn't have the same advanteges for the plan-compiler as the NOT NULL has (i believe). I just want the tables to be 100% correct, if i have...
January 27, 2010 at 4:04 am
The ordinal position isn't an issue, those aren't in the right order anyway.
But how can i add a column which is NOT NULL while it is empty. Than it would...
January 27, 2010 at 3:12 am
I would create an index on the column(s) I want to alter if there isn’t already one
There were indexes on them, but i had to drop them before...
January 27, 2010 at 1:10 am
There is 600gb free space for the log to (auto)grow and the recovery mode is already simple. But this still isn't enough.
I'm currently working on a script of creating a...
January 26, 2010 at 11:51 pm