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.

Thanks for the test. I've seen this before and can usually insert a space or two to clean it up.

There's a [ code = "sql ] tag to the left when you post. Use that. (spaces added so you can read this)

Derek Dongray (7/15/2009)

---

It is embedded HTML. If you look at the source of this post (753126) You'll see that what appears as

should actually have the characters < /...

How are you loading the data? Or querying it, which is what I think you mean.

You can compare the default session settings in SSMS as well. Right click server, properties,...