People hire people. Interviews are where a candidate makes an impression. But when narrowing down who to bring to an interview, or in who a recruiter can help sell to...

That profiler statement shows a creation of a temp table and then an insert of logspace information. Nothing should be happening in the model database. If you set the model...

I agree with Luke. If you start a tran, the optimizer doesn't lock everything referenced.

Begin tran

waitfor('1:00:00')

update sales

set price = price * 1.5

commit tran

The sales table will not be...

Run Profiler, set to filter to the model database and look for activity. Something is occurring in there.

Interesting. I think that the GUI makes it fairly easy for someone to click too quickly, or the wrong place, and make a mistake. I've seen people, myself included, who...

First start basic SQL Server monitoring. The virtual instance is what you should monitor. Here's one ref: http://www.mssqltips.com/tip.asp?tip=1663&home

then I'd read up on clustering to understand how it works. There are...

First, if someone gets administrative permissions on the machine, it doesn't matter what you do. The data will be compromised. Windows authentication is always enabled, so someone will get to...

sorry, haven't done enough production work with 2008. The Truncate_only option isn't in 2008.

As noted here (http://msdn.microsoft.com/en-us/library/ms144262.aspx), when you switch to simple mode, the log is truncated, so I'd follow...

Here's a ref from the SQL team

http://blogs.msdn.com/sql_protocols/archive/2005/10/12/479871.aspx

Need to teach those techs how to run with scripts (DMVs, sys., etc) rather than SSMS!

I heard early on that 50 databases was a limit, but I've not seen anyone running that far. I did see this blog (http://www.naterice.com/articles/70) where they mention a 64 bit...

File copy using VBScript or Powershell to move the files. VBScript with the FileSystemObject is pretty easy to write to move the files, and there should be scripts here on...

I think there is something that reads a header and deletes files, not just based on the extension. I found some issues with this in 2005, and I wouldn't be...

The question to ask yourself is why are you shrinking tempdb? If it grows every day, and you shrink it with a job, you're wasting cycles and disk I/O. Tempdb...

Check the error log in Windows for a reason why the service didn't start.