Why do you think you don't have a clustered index? I would take another look at the table - because your results are telling you that you do in...

The SPN is going to be registered under the account running SQL Server - not the machine. Use the -Q option to query for the SPN record instead of...

The only tools I know of are the standard OS tools (Disk Management) and specific SAN tools (e.g. SnapDrive for Netapp).

Basically, your SAN presents a volume to the OS. ...

What version of SQL Server 2000 are you trying to install?

With a database that is less than 1GB in size, performing differentials every 15 minutes shouldn't take a long time at all. How large these backups are going to...

Database is so big, there are many unused backup tables in database, so I delete them and reduce Database size to easy manage. That's why I want to shrink

As your...

What is the datatype of the TotalTime column? If it is not a numeric datatype - it is not going to sort the way you think it will.

You would...

If you really need a column to show the length, don't store this data and try to keep it updated all the time. Create a computed column or create...

Yes - I think it is possible that is the issue. However, just because one volume is not having an issue does not mean another volume isn't.

You would need...

Two things I can think of:

1) Is the volume this database resides on NTFS - or, something else? What kind of SAN is presenting this storage - check with...

With lock pages in memory, you definitely need to drop the max memory down to no more than 14GB. Leaving the OS only 1GB of memory will not be...

Yes, I was referring to users and applications. If you create a Person table - with a LastName column and declare it as VARCHAR(8000), then you will get a...

Can you run SELECT @@VERSION and find out what version you have?

What version are you running? There was a version released that had this bug - and you are going to need to upgrade to solve the problem.

klini (12/30/2008)

---

Thanks.

I've meticulously tried to get my varchars to match what I expect the data to look like. I'll now just set everything to 8000 and save myself a...