sam_invincible1 (5/25/2008)

---

i am confused between windows authentication and sql server login , how is windows authentication more secure? what domain name should we give in assigning sql server login account?...

Denby (5/14/2008)

---

i have a situation where i need to provide a backup plan for 64 databases all of which are running in full recovery mode.

My questions is:

1. should i create...

Hi Sharon,

I assume you do not want to code, so here are some tools I have worked with in past:

Here are some tools:

http://www.netlib.com/

http://www.activecrypt.com

Thanks,

Phillp Cox

Hi Sharon,

Encrypting at the data level would be suggested strategy, as encrypting the entire database will be time consuming. Here's is a great article to get you started:

Have you taken the insert query and reviewed execution plan?

Does the indexes get dropped prior to loading?

Thanks,

Phillip Cox

Prasanna Kulkarni (4/2/2008)

---

Hi Phillip

Thanx,

My server can not be the same from where I am running my procedure since it is being run from different location with separate SQL Server login.

What...

Ok.

Do you drop indexes prior to loading? What recovery mode are you using for target database? Have you checked transaction log usage and disk space where log resides?

Thanks,

Phillip...

What is taking 4x longer?...

Any changes to HBA card(s) on server (e.g. driver update)?

What is slow performance based on (e.g. reports taking longer)? How often do you update warehouse?

Thanks,

Phillip

Netic (4/2/2008)

---

Thanks in advance !

We are having a situation (PROBLEM) with our DW - SQL SERVER 2000 SP4 ENT X86, it suddenly slowed a lot.

CPU Usage : 20%

IO : AVR...

Hi,

Any other applications installed on server? This sounds like a possible driver issue.

In addition, you state the D:\ drive is SAN based and contains another paging file. This...

Hi Marios,

It will really depend on "why" the development team want to use the integrated CLR feature of SQL Server 2005 for web service. I am an advocate of...

Hi Prasanna,

Sorry, but you cannot attach file when...

Hi,

Ideally, you should use a monitoring tools such as MOM or ping utility.

Thanks,

Phillip Cox

Prasanna Kulkarni (4/2/2008)

---

Hi,

I have migrated from 2k to 2005 and using the same sql 2k procedure. One of the procedure is using xp_sendmail to send mail with attachment. I have...