Viewing 15 posts - 2,176 through 2,190 (of 49,571 total)
Same kind of trick SQL can do with indexed views. With the views it can use the indexed view even if it isn't mentioned in the query, if the query...
November 2, 2016 at 5:41 pm
Gut feel - SQL Injection vulnerability somewhere. It is a concern, because if your site is known (to malicious apps/users) to be vulnerable, they can do more fun things than...
November 2, 2016 at 5:38 pm
Alan.B (11/2/2016)
Does this index get badly fragmented? That's sometimes a reason that the optimizer wont pick it.
The optimiser knows nothing about fragmentation of indexes, the index's layout or position...
November 2, 2016 at 5:35 pm
Grant Fritchey (11/2/2016)
GilaMonster (11/2/2016)
Grant Fritchey (11/2/2016)
Do I need to explain a 5 micro-second difference
No. That's well into the range of measurement inaccuracies. If you could check my blog (which you...
November 2, 2016 at 4:43 pm
Grant Fritchey (11/2/2016)
Hey! I'm qualified doggone it.
OK, I absolutely don't meet the undergraduate degree requirement, but I'm pretty sure I meet all the others.
I've got the degree (as long...
November 2, 2016 at 1:22 pm
Grant Fritchey (11/2/2016)
Do I need to explain a 5 micro-second difference
No. That's well into the range of measurement inaccuracies. If you could check my blog (which you can't at the...
November 2, 2016 at 1:12 pm
Sean Lange (10/31/2016)
What is this ability to delete spam some of you are talking about? I guess I am not part of that club.
Me neither. Wish I could do more...
October 31, 2016 at 1:45 pm
tauseef.jan (10/30/2016)
I am thinking of doing Azure certification, but i am not sure if that is the right career path for a DBA.
Up to you. You can look at the...
October 30, 2016 at 7:12 pm
sqlserverDBA2016 (10/29/2016)
Sorry but there's only one command there : get services sqlWithout any explanation on where or how to run it, is it on cmd or where
The answer you're referring...
October 29, 2016 at 10:11 pm
Lynn Pettis (10/28/2016)
Only other thing I can suggest is to call Microsoft and open a case with them, they may be able to help but not making promises.
Though MS support...
October 29, 2016 at 11:13 am
Then I'm sorry to say it's probably toast and not recoverable. Emergency mode repair's a last resort and has never been guaranteed to work.
Check the MSDB backup tables, maybe you'll...
October 29, 2016 at 11:10 am
MMartin1 (10/28/2016)
October 28, 2016 at 6:52 pm
The pages you restored, which will have been marked 'restoring' by the first restore you did.
Please practice this somewhere other than production if you've never done it before. If you...
October 28, 2016 at 9:48 am
Can you get the DB into Emergency mode at all?
ALTER DATABASE HealthBookDB Set Emergency
GO
If so, can you query any tables while it's in Emergency mode?
October 28, 2016 at 9:44 am
Viewing 15 posts - 2,176 through 2,190 (of 49,571 total)