Just to suppor what Gail said, I used SSMS for 2008 R2 to manage all my SQL Servers including SQL 2005 instances.

Are the executions plans the same for both users?

Use profiler and compare the connection settings for both users, do they differ in anyway?

It means that all the data was reuested in the query was not contained in the nonclustered index. So it used the clustering key contained in the non-clustered index to...

There's maybe a bit of a trap here - there used to be (and as far I know still is) a bug if you extend by an exact multiple of...

Robert Frasca (1/19/2011)

---

Doing some catching up on past QOD's and I don't understand how the number 16 was arrived at. The question was about creating a new transaction log not...

Perry

Does your tutorial cover setting up the cluster on VMware workstation 6.5? if it does please can I take a peek please.

Thanks

Gethyn

What RAID configuartion are the disks?

Did you get it sorted?

I think it means your SMTP server has refused to accept the message request. Check you have setup database mail and smtp in particular with the correct authentication

Nice question Steve, Its also good to see how much debate this has generated.

Hi Steve,

I wouldn't mind having a go at this one, if nobody else has volunteered.

No problem Paul, BrentO knows his SAN stuff. There is an MCM video(s) on storage SAN Performance etc. Maybe start with the blog series first though.

Raghavender (1/2/2011)

---

Hi All,

We have installed 4 SQL Server instances on a server.

When we checked Processes tab Task Manager I can find 4 sqlsrvr.exe processes, is there any way to find...

Paul

Can I recommend you start by reading Brent Ozar's series on running SQL Server on a SAN and SAN best practices http://www.brentozar.com/sql/sql-server-san-best-practices/

Hope it helps and good luck

lianv 90648 (12/29/2010)

---

Gethyn,

thank you for the feedback. Do you refer to the overburdening of the single Lun or do you refer to possible Bugs in SQL server that could cause...