Viewing 15 posts - 12,901 through 12,915 (of 49,552 total)
That's not a new limit. SQL 2008 R2 standard edition only supported 64GB of memory.
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
June 4, 2013 at 3:00 pm
Baseline measurements are essential for any form of performance monitoring. If you don't know what normal is, how can you identify abnormal?
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
June 4, 2013 at 12:20 pm
Did you check for blocking? Did you check what wait type the query is getting? Did you check for any messages in the error log?
It probably isn't a stats issue...
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
June 4, 2013 at 10:22 am
It's not about what's a good batch requests/sec. It's about what's a normal batch requests/sec for your server.
If normal for your server at a particular time of day is 1000...
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
June 4, 2013 at 10:18 am
Brandie Tarvin (6/4/2013)
Please 'splain?
It's referring to the number base.
dec 25, 25 in decimal, ie base 10. 2x10+5
oct 31, 31 in octal, ie base 8. 3x8+1
They're the same number. In base...
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
June 4, 2013 at 6:59 am
rodjkidd (6/4/2013)
How do you answer it?
"What would happen to your business if you lost the entire server room right now? Do you want to gamble the business and everyone's job...
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
June 4, 2013 at 5:32 am
btw, if I was asked the meaning of some obscure column in a system table in an interview, my answer would be 'if I need to know that, I'll look...
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
June 4, 2013 at 5:29 am
kapil_kk (6/4/2013)
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
June 4, 2013 at 5:16 am
Ells (6/4/2013)
"SQL Server is not configured to use all of the available system memory. To enable SQL Server to use more memory, set the awe...
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
June 4, 2013 at 5:11 am
m.rajesh.uk (6/4/2013)
Asked in the interview Gail.
Then not enough context to answer. I would have asked the interviewer to clarify his question. They're probably identifiers, but what they're identifying depends on...
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
June 4, 2013 at 5:09 am
HanShi (6/4/2013)
Without a backup you'll need to re-install SQL
Rebuilding the system databases is enough, reinstall would be a waste of time.
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
June 4, 2013 at 2:27 am
In what context? As seen where?
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
June 4, 2013 at 2:10 am
Well, if you don't have backups of the system databases, someone's not doing their job.
If you happen to end up in that situation, then update your resume, rebuild the system...
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
June 4, 2013 at 2:10 am
Ed Wagner (6/3/2013)
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
June 3, 2013 at 8:49 am
hb21l6 (6/3/2013)
I thought AFTER INSERT meant that the code ran after it had been inserted, clearly its not the case 😀
That's exactly what it means. After the insert has run...
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
June 3, 2013 at 8:44 am
Viewing 15 posts - 12,901 through 12,915 (of 49,552 total)