Perry Whittle (1/11/2009)

---

homebrew01 (1/10/2009)

---

Perry Whittle (1/10/2009)

---

homebrew01 (1/10/2009)

---

Our plan is to take our 2 heaviest hit SQL servers and put them onto their own physical machines running VM. They will have...

It is a good way to find your IO capacity. If you are just starting out, you might use it to play with varying configurations of your SAN and...

SQLBOT (1/11/2009)

---

SA can enable xp_cmdshell, so I don't get your point here.

I like what you're saying and it's worth noting that I think all SA access for vendors should be...

Perry Whittle (1/11/2009)

---

homebrew01 (1/10/2009)

---

Perry Whittle (1/10/2009)

---

homebrew01 (1/10/2009)

---

Our plan is to take our 2 heaviest hit SQL servers and put them onto their own physical machines running VM. They will have...

kiransuram19 (1/9/2009)

---

In the job you mentionted output file as c:\test_outputfile.txt..,and job will run successfully for the first time only ...after that job(2nd attempt) will fail with error.. file already exists...

You can find the path as the errorlog_file:

EXEC dbo.sp_get_sqlagent_properties

you can then change it with:

EXEC msdb.dbo.sp_set_sqlagent_properties @errorlog_file=N'D:\SrvApps\Microsoft SQL Server\MSSQL.5\MSSQL\LOG\SQLAGENT.OUT'

You can also put the select statement in a Transact-SQL job step, and add an output file on the Advanced settings for the step and it will write the data...

Paul_J (1/8/2009)

---

I believe Nullable Types are available from .NET 2.0 onwards. So you can have a Nullable DateTime type like this:

Dim myDate as DateTime?

The "?" at the end makes it...

The weather has been wonderful down here. I think we had a few days where we needed to wear a light jacket last year, but it has been unseasonably...

I've done a number...

John Beggs (1/8/2009)

---

Is it possible that the article you read was referring to Server '08? I have read that there are changes there that have eliminated the need for...

SQLBOT (1/8/2009)

---

I think it depends on your rationale.

Normally I go for a single host\instance for the performance. The reason we use virtualization is for vended applications that require any...

Using this same image and configuration, Buck has discussed this before, that you would be better off going physical for this implementation using 5 instances on the physical server,...

BuckWoody (1/8/2009)

---

Licensing for a VM is the same as a physcial machine. If you have 5 VM's installed, you have to license SQL Server 5 times.

Most often the problems...

BuckWoody (1/8/2009)

---

Something that is important to keep in mind as well is that it is a bit more of a challenge to cluster SQL Server on any Hyper-V, and without...