Grant Fritchey (2/3/2009)

---

jungnaja (2/3/2009)

---

I read about indexes from many forums and they are so confusing. I hope someone can help me by answering the following questions. I know...

The web page was set at 5 minutes. SQL Server timeout are set to infinity.

the result set returned is less than 200 rows and when an actual execution plan...

Sweet, got both options to work. Now I get the following error messages during the job run. I do have access to all the other servers from SSMS...

Forgive me, but I don't have "Save a copy of...." option from the file menu. I do have a Save As command, but I do not get any options...

RAID 1 as it is for backups.

No idea about the number of spindles and the Network/Harddrive guy is out all week on vacation.

Thanks,

Fraggle

Jeff,

Glad to hear that you are getting some use out of it. It get's used about 30-40 times a day to update work tickets in our system.

Me personally,...

Grant, Gail, and Jack,

Thank you all for the great explanations. It was great to have some type of explanation to give my boss when he asked about it. ...

Thank you both for the reply.

Gail, are there any articles you would recommend on using server side traces?

Grant, you are correct. I did fail to mention it....

Gila,

I would never encrypt everything as that would just be silly unless I worked for the NSA or Area 51 or something. 🙂

I am just trying to...

Both are great idea. I personally like Jack's option right now, but that would be going forward. How would we go about encrypting everything in the database already,...

Mark,

Sorry for the confusion, cause I know you had to be asking yourself, "what is this guy doing running a database if he can't join tables". I actually meant...

Mark,

I realize I am getting picky now, but how would you go about joining a table to this? So instead of return RankTypeID, I would rather return the actual...

Thanks Mark. That did the trick. Thanks for the assist.

Fraggle

Sweet, now if I can just firgure out why I get an error message stating "unable to load package as XML because package does not have a valid XML...

So you are saying I can create 1 job to run at 12am on server 1 that will transfer the data to server 2,3,4.......?

Am I understanding you correctly?

Fraggle