1) If you know that certain columns will often be used as search criteria (such as an employee ID or sales close date), those would be great candidates to include...

The RAM needed depends on the size of the database and the number of users/transaction load. In my experience, if the size if the "small scale" database is...

Microsoft and Prometric are currently offering a "Second Shot" promotion. If you feel confident on the subject matter you can take the exam, and if you don't pass,...

It's hard to say if the 2012 exams have greater significance in the marketplace now, but in the future they will. Would you want to send out a...

Also, log files are written sequentially and will overwrite themselves only when the portion at the beginning of the file is no longer needed. When you shrink a...

We've had this debate at my workplace. My view is that defrag utilities from Microsoft & others that run from within Windows assume they are viewing physical disks....

One of the things I've learned is that the feeling that we're totally unqaulified for our positions and the people around us are bound to discover this and throw us...

Agreed, both the most and least lucrative weeks of my career was when I was contracting. It's feast or famine.

One of the issues Brent Ozar's sp_Blitz looks for is when the @@SERVERNAME Property does not match the actual server name. This can happen when the server name...

Correct - the people who develop the exams don't talk to the people who write the training guides. Also, the training guides were publshed shortly after the books were...

If what you want to do is simply shrink an oversized log file as much as possible, here's what I do:

1) Run a full databases backup

2) Run a transaction log...

I passed 70-457 a week ago. I have just received the Training Guide for 463 and will be using it to study for Part 2, along with the...

Once you've done a few training kits and actual exams, it is apparent that the people who write the training kits don't talk to the people who write the exam...

This IS the official RTM (Release to Market) Version.

If you want the latest patch level, also go to http://www.microsoft.com/en-us/download/details.aspx?id=30437 and download the appropriate service pack. You...

I'm not sure what the point of this interview question would be, since in the real world if you needed a query that always returned 1 you would use SELECT...