If you are deleting most of the rows and you have enough space, it might be faster to insert the rows you are keeping into a new table, and renaming...

The first thing you should determine is how long each statement is taking.

If it is the second step (INSERT INTO [ESSBASE_TEST_DW].[dbo].[fct_Logs]) that is taking too long to run, there is...

Date Table Function F_TABLE_DATE

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

Function F_TABLE_DATE is a multistatement table-valued function that returns a table containing a variety of attributes of all dates from...

The only feature I have seen in SQL 2008 R2 that really looks worthwhile is Standard Edition backup compression.

Sounds like a bug in RedGate SQL Compare. Contact them and ask them if there is a fix.

If your real issue is backup performance, then the best thing you can do will be to use a third party backup product, like SQL LiteSpeed or Redgate Backup. ...

I used SSIS to implement a real-time currency arbitrage system that drives the vast majority of trades world-wide.

It’s also a great tool for development of industrial process-control systems for oil...

It can be simpler to maintain...

Why is it important to avoid dynamic SQL?

I wash my hands of this thread.

What's a "true DBA"?

There is no reason to think that what you described would happen.

It would allow teams to exist in small market with say 1-2 million people in a metro area because...

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',...