As far as I'm aware, and contrary to what BoL seems to be saying, there's no way, within SQL to get at the decrypted text.

Do a google search for...

Absolutely not. By giving sysadmin, you're giving them rights to do anything on SQL. Drop databases, delete...

The trace wait is from running profiler. Don't run profiler (GUI) on a busy production system. Use the server-side traces instead.

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

No. Truncate doesn't affect the rowmodcnt/colmodcntrs at all.

Logging and stats have nothing to...

Depends how you're reloading. If it's in one operation, unlikely. If you're doing lots of small...

If a row has to be inserted onto a page that's full, SQL splits the page. It allocates a new page, moves half of the rows on the full page...

Is google down?

http://msdn.microsoft.com/en-us/library/ms179316.aspx

http://msdn.microsoft.com/en-us/library/ms187087.aspx

If you don't understand what they're saying, or if you still have questions after reading them, please ask.

Perfect. Thanks.

Can I use that pic in the article I'm busy with (with credit)?

Anyone got SQL 2000? More specifically Query Analyser?

If so, can you please get me a screen shot of the following.

Run the following:

SET STATISTICS PROFILE ON

GO

SELECT * FROM sysobjects

There will be...

Thanks.

Can you (and anyone else interested) PM me an email address I can use? Doc is currently in Word 2007 format

Anyone willing to review a short article? "How to post performance problems"

I should be finished with it tomorrow.

Yes. The compatibility level just affects how T-SQL is parsed and run and...

Check out the PIVOT keyword in Books Online. It should do what you want.

Alvin Ramard (4/18/2009)

---

Also, I've seen a few interviews cut short because the interviewee was not able to discuss items on his resume. Be prepared to discuss every item on...

Lynn Pettis (4/18/2009)

---

I'd love to but he keeps hijacking threads with his "product" and I totally dislike salesmen that think by disparaging the competition their product will look better instead...