Baseball would be better with a true open market: uncapped salaries, no draft, and uncapped ownership. The reason that the Yankees can generate so much money is because...

I like the fact that you can restore a 2008 compressed backup on any edition of SQL Server 2008.

Much nicer than having to install LiteSpeed on a server in order...

Based on my understanding of your requirements:

declare @t table (

RegionName varchar(10) not null primary key clustered,

[Min] int not null,

[Max] int not null,

[NumberToGenerate] int not null

)

insert into @t

select 'Region 1',...

Are you using the same service account on multiple SQL Servers?

That is a bad idea for many reasons, one of which is how hard it is to change on multiple...

Very urgent???

Do you need to build your data warehouse today?

Is the Location id column a string data type, like varchar or nvarchar?

If it is, you will have to cast the column to an integer datatype in the order by....

mike.styers (4/5/2010)

---

Slippery Slope I think.

Once you break out what each IT service costs, all it takes is a member of upper mgmt to say, "Look what were paying for <whatever...

Why there would be a need to explain SQL in layman’s (Lehman’s) terms?

Are the business people looking at stored procedures to try to figure out what they do?

Try moving the tables you are truncating into a new file group

The files in the new file group should be able to shrink fairly rapidly, since they will be empty...

Wildcards only work with the LIKE operator, not >= or <=

Get a bigger, faster server so it can...

It wouldn’t do anything you can’t do already. You can restore a database with a new name, verify it is OK, drop the old database, and then rename the...

The script on the link below will give you what you want.

Find Table Reference Levels

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=72957

I think most problems with database applications are built-in at the design stage.

Once you do a poor job of modeling data, it becomes almost impossible to make a significant change...

If you feel that you really need to shrink the database, the script on the link below should do it. Shrinking the database file will result in index fragmentation,...