The instructors I believe, but the folks on the DB side I've worked with at MS believe in DBCC CHECKDB on a regular basis (consider that it can be scheduled...

A chat session would be great. I would like that very much.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

They shouldn't be the same.

Each bit should be filled.

Questions 1 & 2 true, Question 3 false:

110 = 6

Questions 1 and 3 true, Question 2 false:

101 = 5

Questions 2 and...

You ran CHECKDB with the REPAIR_ALLOW_DATA_LOSS option and it didn't fix it? You have to specify this option explicitly.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring...

Just a clarification. You need a license per active instance. So if you are running an Active/Passive cluster, you only need one license. If you are running Active/Active, you need...

If you are using Compaq, be aware they have sizers on their ActiveAnswers site to help you. Also, whoever your reseller is should be able to put you in touch...

Do a comparison between the inserted and the original table. Such as:

UPDATE dbo.sampleAuth 

SET rsaPassword = dbo.ud_pwEncrypt(dbo.sampleAuth.rsaPassword,,NULL)

FROM Inserted I, dbo.sampleAuth sAuth

WHERE sAuth.sampleAuthID = I.sampleAuthID

K. Brian Kelley

http://www.truthsolutions.com/

Author:...

It would be interesting to see what Michael comes back with respect to who's building the reports. That will carry a lot of weight with respect to the optimum design....

- 12 bit columns equal 2 bytes of space. SQL Server will allocate a full byte and let you fill it up.

- 12 char(1) columns equals 12 bytes of space....

I agree with Andy on this one. But be aware of stored procedures like sp_helptext as well.

WITH ENCRYPT is a band-aid and besides, it's really annoying if you have to...

The system stored procedure, sp_who2 is undocumented, but you will find some info about it in Inside SQL Server 2000 by Kalen Delaney and also some references in the Microsoft...

For the price, it may be better to stay strictly eBook. Certainly printable for any who want it, but it also allows those who prefer electronic media to keep it...

I agree with you most of the time, Steve! Most of the time when I don't I'm wrong.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL...

There are enough free implementations of various protocols that have been deemed secure. Plus, there's always CryptoAPI. So I agree with Steve to not spend too much. You should be...

Make sure a mail profile is set up for SQL Server Agent. Easiest way to check:

Through EM:

- Expand the Server

- Expand the Management Folder

- Right-click on SQL Server Agent and...