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.
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?
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...
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...
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...
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...
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...
June 4, 2013 at 5:29 am
kapil_kk (6/4/2013)
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...
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...
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.
June 4, 2013 at 2:27 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...
June 4, 2013 at 2:10 am
Ed Wagner (6/3/2013)
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...
June 3, 2013 at 8:44 am
Viewing 15 posts - 12,901 through 12,915 (of 49,552 total)