Viewing 15 posts - 3,586 through 3,600 (of 49,571 total)
ramana3327 (2/15/2016)
If you are not using enterprise edition, I think it would be ok with rebuild indexes weekly using maintenance plans
Don't use maintenance plans for index rebuilds, no matter what...
February 16, 2016 at 2:47 am
sh856531 (2/16/2016)
Would SQL Server detect that the user aborted?
No, because it's not the user that's requesting the data, it's the web server. SQL will finish the web server's request. If...
February 16, 2016 at 2:31 am
Hugo Kornelis (2/16/2016)
Oh, I am not laughing. Not at all. I am concerned and bewildered. Mostly concerned.
Likewise. With a side of terrified that one of the buffoons might actually get...
February 16, 2016 at 2:23 am
If you ran this kind of setup, the query in the second window would be blocked forever (or until someone closed the connection for window 1), even though there's nothing...
February 16, 2016 at 2:08 am
Can you post the execution plans please? Pictures of them are pretty useless as all the interesting stuff is in the properties of the operators.
February 16, 2016 at 2:00 am
Stats are created with indexes regardless of whether autocreate stats is on or off. Autocreate determines whether SQL will automatically create 'missing' stats or not.
No, there isn't a DMV. With...
February 16, 2016 at 1:59 am
Create a procedure WITH EXECUTE AS, put the start job in there. User has execute on procedure. Write a small app that just calls the procedure (C#, should be <...
February 15, 2016 at 2:11 pm
Google: Glenn Berry diagnostic scripts
February 15, 2016 at 2:09 pm
2008 R2 to 2014 or 2012 to 2014 doesn't make the slightest difference. You can't RESTORE ... WITH STANDBY, hence the only way to make a restored DB readable is...
February 15, 2016 at 1:48 pm
Not existing in exec_requests is completely understandable. That DMV only shows executing requests. If a session has opened a transaction, run a query and is now in the sleeping state...
February 15, 2016 at 12:04 pm
jasona.work (2/15/2016)
/me looks down, swings foot back and forth
Huh?
My comment wasn't a slight. If someone told me they were testing I'd be surprised because most people don't bother and assume...
February 15, 2016 at 11:43 am
Yes.
You're putting the server into a state where should something consume lots of memory (remote desktop with SSMS, large file copies), you could starve the OS of memory, and...
February 15, 2016 at 11:42 am
Restoring up-version and applying logs requires that the DB be left in the RESTORING state, meaning it can't be accessed at all. As soon as you RESTORE ... WITH RECOVERY,...
February 15, 2016 at 10:17 am
SQL!$@w$0ME (2/15/2016)
MAX and MIN SQL server memory is set to same which is 90GB and it has used all 90 GB allocated.
No, please don't do that. Especially not in combination...
February 15, 2016 at 10:08 am
SQL!$@w$0ME (2/15/2016)
What/why is the extra 31 GB used by SQL?
There's no 'extra' here. If you didn't have Locked Pages enabled, Task Manager would be showing the full 90GB for...
February 15, 2016 at 9:37 am
Viewing 15 posts - 3,586 through 3,600 (of 49,571 total)