Delete in smaller batches and take log backups every x loops.

Don't even know if this is possible but...

select into + partitioning? Should be under 5 sec.

Delete unsused data.

Otherwise leave it alone.

Shrink is shrink, it's the same process.

It makes sense to shrink after you've archived or dumped a massive % of the data in...

Is the bonus affected only once per employee? Is it on the max # hours for a single...

:w00t: hadn't see that one b4 !

colin.Leversuch-Roberts (5/19/2011)

---

I'd say that most of this is happening in memory which means that the limitations of hardware are the factors here.

Do I think you can get under 5 secs...

Yup, I have the same "delight" here.

Here's a tested version with correct...

Is the hd full?

Sorry, missed that line in the op.

I'm with Grant here... there's no way around writting a query for this. Once that's done you can use it any way you want.

Are you looking at total hours...

Read the whole discussion here

http://social.msdn.microsoft.com/forums/en-US/vsreportcontrols/thread/47f12e8b-83c2-462e-aa26-b36e5620870b/

and here's another great site for reportviewer.

http://www.gotreportviewer.com/

you could do SET @cnt = @cnt + @@rowcount.

Or you could do

SELECT * IDENTITY() from (

select * 1

union all

select * 2

union all

select * 3) dtAll

What do you mean by dynamic rdl? What's the business need behind it?

Install it in master. It will work all the databases by default.

Digs (5/18/2011)

---

Thanks.

Ok I run the back up daily.

With what frequency do I run or should I at all run Integrity check and index optimization.

And what about this code that I...

try it with assigning the result to a variable... there's a implicit cast in there you're not seeing.