DBCC SHRINKFILE (2, 10)

Performance : File fragmentation could be one of them, but at 80MB I would not worry about it, could slow down and even kill a big transaction...

You can reduce the log files if you want.

What I did at my current gig is to reduce the log file size to the DB size.  Then after a few...

Wow, awesome thread guys... this should be put in the top X best discussions on this forum... now if only they had that coded!!

Can you post a script to create the tables and some sample data along with the required results.  Maybe there's a better way but I can't sese one at the...

Can you post the actual query?  Maybe we can figure something out with derived table or cte or??

I'd be curious to see a test of this :

1 M rows table :

Select * FROM 1MTbl WHERE SomeCol NOT IN (SELECT 995000 Rows from OtherBigAsstbl)

I'd be curious...

Lol Jeff.  So true for the team part.  I'll let you do the work and I'll make the money.  How's that for teamwork .

BTW...

I can't figure out a straight select way to do this.  The closest I can come with is like you said :

DECLARE @demo TABLE (ID INT NOT NULL IDENTITY(1,1),...

It's not really redundant.  Sql server and ado are 2 different things operating in 2 different environement... and to call a procedure you need to tell the name, the parameters...

Management studio to develop. Maybe the users will need the connectivity tools installed but you'll have to confirm this one.

I think you'll be set by then.

What will you be developping??

I'd like to do this for you but I don't have time... so here's a working sample code from one of my programs :

Private Function exec_GetStartUpForm(ByVal FkADP As Integer,...

You know that results change from PC to PC in that kind of test... and since you already have them printed on your screen, I think it's a farely easy...

You can tell him up front... he's not gonna mind.

JEFF YOU SCREWED UP!

.

Results please?