Viewing 15 posts - 3,916 through 3,930 (of 49,571 total)
I don't really understand question 1. But the quote from the book's not entirely correct. If Windows is under memory pressure, first it will tell SQL (and other apps) to...
December 30, 2015 at 2:44 am
muzikfreakster (12/29/2015)
Thanks Gila but you still didn't answer my question 🙂
Um...
GilaMonster (12/29/2015)
Check the Total Server Memory counter in perfmon
Perfmon's easier than a query, but if you insist on a query...
December 30, 2015 at 2:40 am
steven.oates (12/29/2015)
Therefore one of my developers scripted up the change and execuated it (without consulting with me) let in run for 7 hours and it ran out of diskspace.
Can you...
December 30, 2015 at 2:35 am
What, exactly, is the situation and what precisely happened?
You don't add filegroups to tables, tables are stored on filegroups, so the question doesn't make much sense.
December 29, 2015 at 3:06 pm
Please note: 2 year old thread
December 29, 2015 at 2:17 pm
steven.oates (12/29/2015)
How do I get the data from the files back in the table...
You don't. Like any dropped object, restore your last backup as a new database, restore any log...
December 29, 2015 at 2:14 pm
You can sort in tempDB, which removes the need for the sort space in the user database, but you still need space for SQL to put down the new index,...
December 29, 2015 at 10:59 am
Jeff Moden (12/29/2015)
they don't actually know what they're talking about.
Mostly this one, I suspect.
And yes, you can rebuild indexes afterwards. Doing so will usually grow the data file and the...
December 29, 2015 at 10:57 am
For your information, since you found it necessary to PM me to nag me to post further (and without a please, thank you or any courtesies at all), all the...
December 29, 2015 at 10:57 am
Not so much 'normal monitoring', more 'normal maintenance'
December 29, 2015 at 7:30 am
Eirikur Eiriksson (12/29/2015)
December 29, 2015 at 6:58 am
Phil Parkin (12/29/2015)
Grant Fritchey (12/29/2015)
Eirikur Eiriksson (12/29/2015)
December 29, 2015 at 6:30 am
BrainDonor (12/29/2015)
Eirikur Eiriksson (12/29/2015)
December 29, 2015 at 5:52 am
Eirikur Eiriksson (12/29/2015)
December 29, 2015 at 5:51 am
Viewing 15 posts - 3,916 through 3,930 (of 49,571 total)