Viewing 15 posts - 4,516 through 4,530 (of 49,571 total)
xsevensinzx (10/14/2015)
I think the reason why I went that option is because it's my understanding that with large volumes, it pays out in the end to split the indexes.
Maybe, maybe...
October 14, 2015 at 9:19 am
Bill Talada (10/14/2015)
My interpretation is that the graph process is creating a transaction before reporting and rolling back.
If that was the case, then it would be impossible to get a...
October 14, 2015 at 9:09 am
A shutdown doesn't necessarily cleanly shut all DBs down, and a checkpoint doesn't mean no recovery necessary, consider uncommitted transactions whose changes get written to disk as part of the...
October 14, 2015 at 8:44 am
They're not memory resident, however like normal tables and indexes they'll be read into memory to be used, as part of the buffer pool.
October 14, 2015 at 7:43 am
Huh? Don't understand, can you elaborate on your question?
October 14, 2015 at 7:31 am
xsevensinzx (10/13/2015)
RonKyle (10/13/2015)
A downside I've seen is that when I adopted this method I had to stop putting my indexes in a different file group because of the restore issues.
I...
October 14, 2015 at 7:29 am
Bill Talada (10/14/2015)
Your hypothesis is false as the following code will show a trancount=1:
BEGIN TRAN
SELECT @@trancount;
COMMIT;
Yes, that will return @@trancount of 1, but the OP's not talking about what @@trancount...
October 14, 2015 at 7:18 am
Documented? What's that? 🙂
It looks like if there's only auto-commit transactions (every statement starts and commits a transaction) then it's 0, if there's an explicit transaction, then you get a...
October 14, 2015 at 5:47 am
No, you can't have two instances with the same name.
You need to either:
Install a new instance with a different name, move the databases, uninstall the old instance, update...
October 14, 2015 at 3:02 am
don.schaeffer (5/12/2011)
October 13, 2015 at 7:11 am
Is opening a support call with MS an option? If so, I'd recommend that approach.
Also check the IO subsystem for any errors in any drivers, caches, etc. Make sure firmware...
October 13, 2015 at 6:21 am
Thank you (I can see the posts, they're pending approval due to the spam filter)
Can you also please post the actual execution plan, as a .sqlplan file?
October 13, 2015 at 4:29 am
Put the keyboard down, pet the cat. Priorities!
October 13, 2015 at 4:09 am
The inserted and deleted pseudo-tables are only visible in the trigger's scope, not in any child scope (dynamic SQL, functions or procedures)
It looks like you're trying to write a trigger...
October 13, 2015 at 4:06 am
Eirikur Eiriksson (10/13/2015)
Quick question, have you considered turning on compression on those tables and indices, most likely more effective and almost no risk involved.
Seconded. Row compression has very little overhead,...
October 13, 2015 at 3:12 am
Viewing 15 posts - 4,516 through 4,530 (of 49,571 total)