:blink: All those KeyIDs have the same RefIDs...?!

Read the White Paper:

FILESTREAM Storage in SQL Server 2008

Jason called me Paulpatine on a thread earlier, and it made me miss it 🙂

This method could be the highest performing of those submitted so far.

EXCEPT is close, but contains an...

Gavin,

Yes, that's true - if you know your way around a .NET language, which many people do.

I don't think I would necessarily recommend doing it inside SQL Server though (that...

Tell me about it. How can summer be over already? 🙁

Freak storm over here this afternoon - roofs ripped off, trees knocked over etc.

The...

USE tempdb;

-- Will hold a list of empty tables in all user databases

DECLARE @EmptyTables

TABLE (table_name NVARCHAR(MAX));

-- Cursor

DECLARE @Databases CURSOR;

-- Used with the cursor

DECLARE @DBName SYSNAME;

-- Declare the cursor

SET...

You are clearly out of your depth here....

If you mean 'not exists', it can pay to use NOT EXISTS 😉

The LEFT JOIN version is not quite...

BTW, in case it looks like I'm singling out Lynn, I'm not intending to: he just came to mind since, like Jeff, he passed a milestone recently.

I kinda knew how...

Happy I could help!

What's the deal with these points anyway?

Didn't I see Lynn pass 10,000 just the other day, and now he has nearly 12,000?

I cannot believe he has posted 2,000 times in...

I had to guess a bit.

Post full CREATE TABLE statements for the tables you have, plus INSERT statements to add sample data, and show the EXACT output you would like...

CirquedeSQLeil (3/12/2010)

Paul White (3/12/2010)

Jason...CTRL + SHIFT +...

http://connect.microsoft.com/SQLServer/feedback/details/257502/deprecation-of-sysprocesses-dmvs-doesnt-fully-replace-all-columns

I am nevertheless sure I managed to avoid using sys.sysprocesses in the past - perhaps I am misremembering it.

This isn't the method I was trying to think of, but for...