Hmm, I agree with Jeff that SQL 2000 you need a temp table. You can use the ROW_NUMBER() function in SQL 2005 though...

I haven't checked the syntax but the...

Hmmm... I don't really have time to review everything you posted, but it sounds to me like pivot is the wrong way to do it (although I still...

Sorry Jeff, he's not...

update tab1 set tab1.col2=tab2.col2 from tab1 inner join tab2 on tab1.col1 = tab2.col1

can be more clearly written as (why doesn't anyone use the fixed-point font...

It sounds to me like you have a lot more to worry about that the database side of things....

You'll want to write something to

1. Check your POP3 mailbox ...

Good grief! That is a doosie 🙂

Anyhow, I would suggest that you index the columns used in your join conditions and those columns used in your where clause.

If you...

That's an ugly design. Just curious, why would you want that anyway? One table with a suitable index would (in just about all cases) be better, and certainly...

Try this instead... No dynamic SQL needed! You should avoid it like the plague unless it's absolutely necessary. Your use of dynamic SQL introduced the definite possibility...

How big is this database? Could recovery just be taking a while?

Hi,

You need to do some sub-selects as you're still getting 1 row in your result set for each row in your table....

Perhaps you want

Select

left(str_sitename, 3) as SiteName,

year(dat_usageDate) as [year],

...

Understand the applications hitting the servers. What load do they exert? Do they have any timed jobs or other special tasks that need to be performed on a...

Look for the stored procedure "sp_attach_single_file_db" in SQL Server Books Online (the SQL manual - not actually "online" on the net).

Great article. I agree that there will always be idiots in the world that can only help to make me look good 🙂

The query in question in the previous...

That's even better than the one I couldn't find - thanks for the nugget! 🙂

Get rid of the FKs - do your cascaded deletions manually. You could also try to do the deletes in smaller lots using a loop and "set rowcount" -...

You need to use the same airport table three times in a query -> you need table aliases...

Example

select

airRoute.routeID,

airportStart.airportName,

airportStopOver.airportName,

airportDest.airportName

from airRoute

inner...