Viewing 15 posts - 31 through 45 (of 73 total)
I go even further.
It only gets registered in my team's list if the team is local admin (Windows), sysadmin on SQL and *nobody* else can be sysadmin using Dev tools...
March 8, 2013 at 9:01 am
Brent Ozar's videos/articles are a good start for studying VM suitability and configuration.
We've got dozens of SQL servers on VMs and they are OK (more or less!).
Of course I was...
March 7, 2013 at 4:29 am
Yep, 'test it and see' indeed.
If you have lots of half-empty Char(100) columns, I guess row-compression may speed things up even comparing memory access speeds.
My tests were using an efficient...
March 6, 2013 at 7:37 am
GilaMonster (3/6/2013)
SQLCharger (3/6/2013)
If it is normally in memory anyway, you may decide to leave it uncompressed.Why?
Gail,
My tests have shown a performance degradation when the same queries run on compressed tables...
March 6, 2013 at 7:04 am
Michael Meierruth (3/6/2013)
And what's the point of what you're saying in your binary signature?
A yes/no answer will suffice:-P
March 6, 2013 at 6:54 am
I would consider running sp_updatestats right before index rebuilds or custom stats update jobs.
It is fast, catches bits that rebuilds don't catch and any full-scan stats updates will overwrite the...
March 6, 2013 at 5:39 am
It is also worth understanding how this table is used and if it normally resides in memory or not.
If it is routinely scanned, then you may choose accept lower savings...
March 6, 2013 at 5:27 am
Guys,
Would this also work with Windows hashes as well?
That would be even more scary (if someone manages to get your Windows hash from a server). :unsure:
March 6, 2013 at 1:13 am
Scary and unsettling.
More reason to ensure access to master db is restricted (backups too!)
Long live long passwords:-D
March 4, 2013 at 5:48 am
Interesting to know that all lab exams will now be remotely proctored.
I had an unpleasant experience with Prometric in London early December, losing over 1.5 hours of metered exam time...
February 4, 2013 at 3:48 am
Jeff,
Maybe you're right - purely memorising stuff from prep books can give an artificially-high score that won't translate to hands-on abilities.
At least the Knowledge exam is less prone to such...
February 3, 2013 at 3:22 am
I'd also look into any hard memory limits you could be facing due to running Std edition - both Windows and SQL.
It's possible to max out at 64GB, and I...
December 30, 2012 at 9:34 am
It also depends on the stage of your career.
During the first few years, you may want to be in a 'learning' environment, where the balance is on the side of...
December 17, 2012 at 11:03 am
I would not have an important live server relying on a single FusionIO card.
RAID1 is the safe route for production.
Got several of these cards in various configurations - example 2x640...
December 17, 2012 at 5:22 am
Vedran Kesegic (12/15/2012)
...or they cheated on exams 🙂..
..exactly;-)
If you really did fly past both MCITPs (dev and admin) then you may be ready to give the Knowledge Exam a try.:cool:
December 16, 2012 at 12:54 am
Viewing 15 posts - 31 through 45 (of 73 total)