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.

No, there's no way to do this. The hack would be to call a script that changed the context and executed something. However it would need to be some sort...

SQL server has nothing to do with this. It will send data to whatever disk or tape system that Windows can see. If Windows supports it, SQL will.

The easiest way I think do to this is use something like SQL Compare (or any compare tool) and have it sync the procs in all databases on a regular...

Also, indexes are on tables, not generic in the database. If I have an index on the CustomerID in the Orders table and an index on the CustomerID in the...

I'd keep things the way they are. Then use VBScript (FileSystemObject) or Powershell to find the latest backup (not hard to do, loop files, find last one) and copy that...

Ethics ought to be a core course for everyone.

It is hard to know what you'd do, but you ought to at least document your case, and not go along.

You can have two fields in a primary key, but not two primary keys, as Elliot mentioned.

It also makes me wonder if you understand what you need. Does every table...