here's a good one:

http://www.itbookworm.com/Videos/SQLUSA/OLAP/SQLUSA.asp

looks like you have a dynamic search condition. you may benefit from reading this:

http://sommarskog.se/dyn-search.html

I don't think this is possible without parsing the function code, which is a significant undertaking.

you could invoke bcp via xp_cmdshell to export results to a file.

I wrote one that works for 11 different DBMS, SQL Server included of course.

see link in my sig for details.

this should give you a hint:

"View or function 'master.sys.dm_exec_sessions' has more column names specified than columns defined. (Microsoft SQL Server, Error: 4502)"

it means the client tool (in this case...

sorry for the confusion - sqlspec does not support documenting FKs between different databases. It doesn't support them because SQL Server itself doesn't support them, which you already know....

if a few msec on a query is important to you, then use ISNULL.

I guess what I am saying is, I never came across a system where the...

Adam says ISNULL is about 10% faster:

http://sqlblog.com/blogs/adam_machanic/archive/2006/07/12/performance-isnull-vs-coalesce.aspx

but 10% of what? The time your query spends evaluating ISNULL or COALESCE will generally be very tiny compared to the time it...

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

perf difference is negligible, not important. pick one you like and use that.

I prefer coalesce as you can pass multiple args, plus it's ANSI. Also it's harder to...

http://r937.com/relational.html

I wrote one called SqlSpec, for details see the link in my sig. Supports 11 different DBMS.

well, I wrote a tool called SqlSpec that will document all your FKs as well as every other thing in your database. there's more detail about it at the...

no, I don't. I've never used remote-key either. I just heard of it somewhere.

sorry it didn't work for you, but perhaps it's for the best, because enforcing RI...