Viewing 15 posts - 2,176 through 2,190 (of 49,552 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 29, 2016 at 11:10 am
MMartin1 (10/28/2016)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 28, 2016 at 9:44 am
Yes.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 26, 2016 at 3:14 pm
Viewing 15 posts - 2,176 through 2,190 (of 49,552 total)