I don't see it in BOL, but it should be in Inside SQL Server (Delaney) and show that all fixed length data comes first, then offsets to var columns on...

This has been my experience. Delete the plan, the job goes away. It does in 2008 , SP1, just tried it.

This is huge, and I'd recommend you format it so it can be better read. Put the joins on separate lines, the FROM, the WHERE, etc.

In terms of your execution...

Gethyn is correct. There is advice from various sources, including SQL CAT, that you restore each backup, each day, to a test machine to ensure it will work. I think...

TDE protects from physical access to the files if SQL is down. If you detach/attach files, they are safe.

You can't run TDE on laptops practically. It's in Enterprise Edition only...

As mentioned, it's hard to say. I've had lots of SQL 2000 servers that ran on dedicated machines with 2GB or 4GB of RAM. SQLServerCentral served thousands of clients from...

http://www.sqlservercentral.com/Forums/TopicSubscriptions1.aspx

Click control panel to the upper left, then scroll down to find forum, and topic, subscriptions. There's also a contact us link on the menu to the left.

I like the idea of the cloud, but as a private, secured set of services inside my walls. Deploying to a cloud, without having to worry about a particular server,...

Her is the link for the book from MS that can help: http://blogs.msdn.com/b/microsoft_press/archive/2010/04/14/free-ebook-introducing-microsoft-sql-server-2008-r2.aspx

Please don't upload books from someone else, like MS.

Agree

Agree

Agree

Now if I had someone to make a few changes and test them. This is a relatively low priority item, but I do agree that these are some changes that...

If you just want to get notified if SQL is down, not Windows, Go to the control panel, look for services, look for the SQL Server. Look at the options...

Jeff Moden (6/30/2010)

Actually, it's not. It's only easier to comment out the last line with...

I've typically used a domain account, no rights (except Everyone or what the service specifically needs on the network). I don't think there's a fundamental reason to do this over...

You don't need a dedicated machine, but you need one up and running all the time. SQL is a service, like Exchange. Responds to network requests, sends data back and...

Please do not request, not ask for materials that are under NDA. To study for an exam, use public materials or books, but do not ask someone to get you...