The rights are those of the job, or agent, running the job. Not the user that runs the job. You can specify a proxy account for SQL Agent, but if...

You can shutdown SQL Server from within SSMS using SHUTDOWN as a T-SQL command. (http://msdn.microsoft.com/en-us/library/ms188767.aspx)

I almost never restart my servers from the command prompt. The GUI works fine, and will...

We hope you get our newsletter, as we run new articles every day, as well as getting them from around the Internet.

For SSIS, you might check out SQLIS.com, though I...

I'm not sure what is being asked.

Do you mean, paulj_p4, that you want a compound key, meaning that companyID becomes part of every primary key, as Barry mentioned? Or do...

You should not need to disable the log backup.

I think for #2, he means a RESTORE command as the query. It's not a query per se, but a batch command.

FAQ is a good idea. I'll start looking at a set of pages for that.

Paul, I'd raise this issue again, and actually I'll make a note of it. They do update things, but it's a big book. I'm not surprised things fall through the...

These have to be coming back as characters. Therefore they'll be ordered as characters.

20:1:1

comes before

20:2:5

No matter what the math, these are ordered by characters. If you have some rules,...

http://www.sqlservercentral.com/blogs/sqlmanofmystery/archive/2009/04/14/ssd-the-game-changer.aspx

http://www.sqlservercentral.com/blogs/sqlmanofmystery/archive/2009/08/02/fusion-io-update.aspx

http://www.dvnation.com/Fusion-IO-IODrive-SSD-Solid-State-Disk-Drive-Review.html

I heard from another MVP that they had a customer which had run them for over 8 months and loved them. No real issues, and tremendous speed improvements. They couldn't...

No, SQL wouldn't create that extra space. either someone added it, or there possibly was data deleted (or indexes) that freed space.

I'm not sure what I'm looking at here. What are the data types? Is the ratio a char field? If so, then it is ordered as characters.

What ordering are you...

I think it's supposed to be SQL Server 10.5, with SQL 10 being SQL Server 2008. It would be an upgrade from SQL 2008, just like Windows 2008 R2 is...

First, autogrow is not how you manage space. It's an emergency measure, and you ought to set it for emergencies. Lots of times there will be a need in an...

Good points, dma. There is a lot of gray in the world.

more RAM?

or maybe some Fusion SSDs for speed?

As far as tools, sorry, not sure what might help you here.