Viewing 15 posts - 631 through 645 (of 49,571 total)
An index rebuild *is* a physical reordering. It creates a new index and drops the old one.
November 17, 2017 at 1:49 pm
9-year old thread, and master can't be replicated.
Please ask new questions in a new thread.
November 17, 2017 at 9:02 am
November 17, 2017 at 8:51 am
November 17, 2017 at 5:31 am
You can't use in-memory OLTP with tempDB. Not directly.
You can use in-memory tables in place of table variables, but that's considered to be part of the user DBs, not...
November 17, 2017 at 3:04 am
November 17, 2017 at 3:03 am
Indexed view?
Why are you trying to avoid it? If an indexed view is showing up in a plan, the optimiser thinks it's more efficient than going to the...
November 16, 2017 at 12:50 pm
November 16, 2017 at 12:43 pm
November 15, 2017 at 11:52 pm
November 15, 2017 at 2:10 pm
I strongly recommend against setting the min to the max. Something unexpected allocating memory (like a remote connection) and suddenly SQL's memory is in the page file and performance is...
November 15, 2017 at 2:02 pm
VARBINARY(MAX) columns. Doesn't have to be filestream, normal VARBINARY(MAX) columns work OK.
November 15, 2017 at 4:14 am
Can you post an example query that's run for this search?
November 15, 2017 at 1:22 am
Viewing 15 posts - 631 through 645 (of 49,571 total)