Mani: Your issues seem to be more political than anything else. If there is a time when you have a drive failure, you'll be thankful for the off-site backups.

With regard...

Ellis is right (of course 😉 ).

SQL will abort a backup if anyone is connected other than the Service. Set your Database Context to Master and try the operation...

Chaotic,

Best practices suggest that at the very least the backups be on their own separate physical device. Partitioning is great, but it's all virtual.

If you lose the disk you...

Depending on the version you are installing (RC versus CTP) there might be conflicts with previous versions of SQL. I had a problem with SQL 2005 files still being on...

Installed SQL 2008 RC0 Enterprise Evaluation Edition on Windows 2008 Standard. Trying to look at a 85 GB Database via Standard Reports.

I ran the "Disk Usage by Table" (right Click...

SQL Server Guru might be right, but then what exactly do you learn?

It appears that the SubCode appears in the same location each time in the Code value. I would think this would be pretty easy to do something like this

SELECT...

We use SQL 2000, 2005, and 2008 (non-production) on VMWARE. As most everyone else has stated, as long as you are smart about the configuration of the guest OS,...

Your USE DATABASE statement has to be it's own line, not inline with the update.

Running the following:

USE DATABASE SELECT * FROM TABLE

Gets me the error:

Msg 156, Level 15, State 1,...

I the application admins take over that responsibility, what the heck do they need DBA's for? :w00t:

We've had similar requests and have asked what it is they are looking for....

SQL Server Express is about as stand alone as you get with MSSQL. That said, you cannot just run the database without the full installation.

I have seen...

I use this cursor. I like it because I can change it for the type of permissions I want to grant based on the type of object

DECLARE @OBJNAME VARCHAR(256);

DECLARE...

I use a utility called Alchemy Eye to watch my Servers. It can send alerts to pagers, e-mails, SMS devices, etc. Of course, I use it for my...

If you are concerned that the bottleneck lies with the Website, you can use a product called HTTPWatch. It will show you what is taking a long time to...

You should not have to qualify the Local Server with the four parts. If you run the query within the Database that the table resides in the most you...