ricardo_chicas (11/3/2011)

---

Thanks, this is what I get with

select * from sys.dm_os_wait_stats order by 3 desc

Wait type--------------------Waiting task count--Wait time ms-----max wait------signal wait time ms

SOS_SCHEDULER_YIELD-------2580613123-------12811631972-------17322-------12809029011

CXPACKET--------------------955460838---------6623920160-----7045715--------1082202989

BROKER_RECEIVE_WAITFOR------1981445---------3992879800------599993-----------12265241

PAGEIOLATCH_SH--------------72526907---------2632302999-------20873-----------10017518

The result from select * from...

Ok... This "@datasrc=N'\gmnc2-j6ops-a7\autod\Database Imports\Personnel.xlsx'" What is the drive letter? This should be a mounted or local drive.

Thanks,

Jared

Stubby Bunny (11/3/2011)

---

I am trying to add that Excel spreadsheet, I logged on to the sql server and opened SSMS from here with my admin privledges and was able to...

NJ-DBA (11/3/2011)

---

jared-709193 (11/3/2011)

---

Can anyone provide a list of ALL of the domain accounts they would have set up to do a "proper" or "best practices" install of all SQL Server...

Stubby Bunny (11/3/2011)

---

It is saved as an xlsx file. here is what I am doing. i found an artilce on the temp directory issue for adding users for...

What are you trying to add as a linked server?

Jared

Stubby Bunny (11/3/2011)

---

I am trying to create a linked server to my excel spreadsheet but now I am down to a final error after clearing a bunch before.

What have I...

I'm not an expert in this (yet), but have you looked at the recent expensive queries?

Thanks,

Jared

Take a look at this: http://blog.sqlauthority.com/2011/02/01/sql-server-wait-stats-wait-types-wait-queues-day-0-of-28-2/

Thanks,

Jared

http://msdn.microsoft.com/library/ee633752%28SQL.105%29.aspx

Thanks,

Jared

x86 is 32-bit. The 86 comes from the 8086 chip.

http://en.wikipedia.org/wiki/X86

Thanks,

Jared

Well.. That's kind of a loaded question 🙂 How many reports? How...

Ninja's_RGR'us (11/2/2011)

---

I'd...

This article may have something to do with it... http://msdn.microsoft.com/en-us/library/ms187087.aspx i.e. Round-robin can't expand first file so it will not expand second? Just a quick thought...

Jared

Elliott Whitlow (11/2/2011)

---

jared-709193 (11/2/2011)

---

Elliott Whitlow (11/2/2011)

---

I think we may be over-thinking this. Licensing is a function of paperwork. I have 5 SQL 2008 Standard servers and 5 SQL...