Viewing 15 posts - 10,141 through 10,155 (of 49,552 total)
Experience >>>>> Certifications
From the MS site on one of the exams for that cert (461)
Who should take this exam?
This exam is intended for SQL Server database administrators, system engineers, and...
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
February 3, 2014 at 12:17 am
https://www.simple-talk.com/sql/performance/sql-server-deadlocks-by-example/
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
February 3, 2014 at 12:14 am
caippers (1/31/2014)
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
January 31, 2014 at 11:26 am
Try rescheduling for a quieter time, check the link I posted about CheckDB's memory grants and check the server in general for resource contention (execution grants)
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
January 31, 2014 at 10:09 am
'indefinitely' how long have you left it? How busy is the server?
Resource Semaphore is a wait for memory grants. (also see this: http://www.sqlskills.com/blogs/jonathan/dbcc-checkdb-execution-memory-grants-not-quite-what-you-expect/)
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
January 31, 2014 at 9:45 am
What should that procedure return? If I pass it current date (2014/01/31), what do you expect to get back?
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
January 31, 2014 at 8:08 am
Please note: 5 year old thread.
It's entirely possible to set the backup jobs up on the mirror as well, just have them check the DB status when they run, if...
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
January 31, 2014 at 7:45 am
Depends on the queries that run against that table. If you have queries that filter on Instance, Site and Office or Instance, Site, Office and PersonType it could impact 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
January 31, 2014 at 7:43 am
BWFC (1/31/2014)
GilaMonster (1/31/2014)
Can't see anything obvious (other than multiple unnecessary DISTINCTs)Is the difference in rowcount consistent?
If you mean 'is the difference in ServiceDays and AverageServiceDays the same every time' then...
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
January 31, 2014 at 4:44 am
Can't see anything obvious (other than multiple unnecessary DISTINCTs)
Is the difference in rowcount consistent?
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
January 31, 2014 at 4:05 am
Could you rather put the code in your post, wrapped in the code tags (see left-hand panel)
Word docs from untrusted sources.... 🙁
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
January 31, 2014 at 3:33 am
Why is the DB in Standby? Why does it need to go back in Standby?
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
January 31, 2014 at 3:02 am
Going to need to see the code. Can you post just the procedure and view initially, might need more later.
I created the view by copying the code from my...
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
January 31, 2014 at 2:29 am
Ryan George (1/31/2014)
So what do you think? We are not here to provide answers for interview questions so you can get a job that you are not qualified for.
Dear Mr....
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
January 31, 2014 at 12:36 am
VoldemarG (1/30/2014)
Sorry I missed the % in LIKEs. Of course I meant wildcards..
In that case option 2 and option 3 are not equivalent and hence cannot be compared for performance.
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
January 31, 2014 at 12:22 am
Viewing 15 posts - 10,141 through 10,155 (of 49,552 total)