If you have any more specific questions, let us know

Nice backdoor that is, surprising how many people dont know of it

Imke Cronje (9/9/2009)

---

Hi Guys,

This question is more related to hardware than SQL Server. What would be the advantages of having SQL server on a physical machine as to having it...

Let me know how you get on, as I tried your script and it didnt work for me either

anithagovindarajalu (9/8/2009)

---

Hi,

I need the procedure that calculates the freq_interval in sysschedules.

For Example,

If we select sunday and...

Unless he has moved data between partitions perhaps.

Nice link and article, I can say without a shadow of a doubt that he does none of those things, not because he doesnt have the...

CirquedeSQLeil (9/8/2009)

---

Laptop / Desktop - Yes. Laptop supplied by work is usually always a fight with the employers.

Books - Yes. I buy my own.

Certification - Not since SQL2000....

Michael Valentine Jones (9/8/2009)

---

Sounds like you were interviewed by some HR weenie.

I never let HR get any more involved in the hiring process for DBAs than contacting recruiters and placing...

Elliott W (9/8/2009)

---

As long as you only install the client and development tools (ie: not SQL Server, SSIS, SSRS, SSAS) then you are probably clean. BIDS doesn't require SSIS...

clucasi (9/8/2009)

---

Within my organization a department have a need to create SSIS packages, the problem being, we want them to be able to run the SSIS packages but not have...

clucasi (9/8/2009)

---

Is the version of Visual Studio 2005 that is installed with BIDS have the ability to create web applications, if so is there a way we can limit them...

you dont mention if this is a production server or not. I could be wrong but if you install SSIS service on any machine, you need a license for that...

You could always use the copy_only option, at least you know that it doesnt interfere with your normal backup strategy.

But taking backups of your backup is extreme, unless you do...

used litespeed before, can recommend it. I would make the suggestion that you get it on a trial basis or find out how much compression would be applied to your...