Can you post table definitions (as create table statements) and some sample data (as insert statements)?

Read this to see the best way to post this. http://www.sqlservercentral.com/articles/Best+Practices/61537/

Try using LEFT OUTER JOIN rather than INNER JOIN. Inner join only return rows where there is a match. Left outer join returns all the rows from the table on...

No. It's someone who answers questions, not asks. (no one here, obviously)

Steve: Apologies in advance if this results...

Florian Reischl (5/21/2009)

---

Gail, generally you are correct. But there is a huge difference between Pieters scalar function and the one you use in your blog. It does not query any...

For some info on scalar functions, including the difficulting in seeing how they perform

http://sqlinthewild.co.za/index.php/2009/04/29/functions-io-statistics-and-the-execution-plan/

Oh yay. 🙁

Another email accusing me of personal attacks and damaging someone's public image by 'misleading' people about his statements.

Sometimes I wonder why I bother.....

Threads can't be deleted.

No replies here please. Direct replies to http://www.sqlservercentral.com/Forums/Topic721366-148-1.aspx

It's the data and log file for TempDB. That's the DB where temp tables and table variables are stored and where SQL stored intermediate results for queries (spools, hashs, etc)

The only way you're going to see the passwords is if you put a network sniffer in place and are using unencrypted communication. SQL will not allow you to see...

Now that's taking white space insensitive just a little too far.

Are you running this on your production server or on a dev server? (hint, you should not ever run index tuning wizard or database tuning adviser on a production system)

Does...

Please post SQL 2000-related questions in the SQL 2000 forums in the future. If you post in the 2005 forums, you're very likely to...

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=454744

Datetime is internally a float and can implicitly convert to and...

SA is sysadmin and has all permissions on the server anyway. There's no need to assign it anything.