When you’re hiring a Windows desktop administrator, here’s the best questions to ask. Includes questions like, “What’s a Windows profile? When would you delete one, and what gets deleted?”
These are also good for environments where the sysadmins have to wear multiple hats, and they also touch servers.
When you’re hiring a Windows desktop administrator, here’s the best questions to ask. Includes questions like, “What’s a Windows profile? When would you delete one, and what gets deleted?”
These are also good for environments where the sysadmins have to wear multiple hats, and they also touch servers.
When my Grandpa Ozar wanted to find out if his 10 megabyte 5.25″ hard drive was responding fast enough to handle his database loads, he monitored the Perfmon counter Physical Disk: Disk Queue Length.
Things have changed since Grandpa’s time, though, and now it’s time to learn a new performance tuning trick – SQL Server waits.
Why do some interviewers insist on asking ridiculously impossible questions when they’re interviewing the most junior candidates? I explain why you should use questions people can actually answer, and quit trying to hit the lotto.
Sometimes less is more – and indexes are definitely one of those times. Learn how to identify overlapping indexes and why they’re so bad for performance, and learn about SQL Server 2005’s new INCLUDE feature.
