You can use sysprocesses to determine the amount of active connections and then a grouping based on that to get the count data.

However, I'd be very careful with this as...

Nevyn (12/11/2014)

---

Dynamically changing the formatting would be pretty tough as SSIS likes to validate the metadata.

Two easiest methods I can think of on top of my head:

1) Foreach loop that...

I've done the job test, but I'd like to failover to the secondary node and test it out. Unfortunately I can't do that on my box as I have windows...

Grant Fritchey (12/10/2014)

---

Small company or not, I strongly recommend putting process for getting stuff out to production into place and following it religiously. The last thing you want are for...

Thanks. I forgot about the Upgrade Advisor.

Perry Whittle (12/10/2014)

---

JoshDBGuy (12/9/2014)

---

Perry Whittle (12/9/2014)

---

Work from where, where will...

Perry Whittle (12/9/2014)

---

Work from where, where will this be running...

Just so you know, if it's a smaller company with only a few Dev's you will generally see that Dev's have a lot of access as there's no real QA...

I had a longer conversation with our system admin. So he created multiple LUNS for our environments. For the particular SQL Server, it's shared storage from one LUN, meaning it's...

Sorry for the bump guys. Do you happen to know if the script I listed above will work? I want to implement this within the next day or two.

Actual query looks fine. We would need data to determine the reason why it's taking so long. But as Grant said, it's most likely an indexing issue. Another reason could...

Ville-Pekka Vahteala (12/3/2014)

---

JoshDBGuy (12/3/2014)

---

Perry Whittle (12/3/2014)

---

JoshDBGuy (12/1/2014)

---

I have less than 4 cores so my current setting is 0. However, I see some recommendations to set it to "0 to N"....

So it doesn't look like we use RDM. Basically we have storage assigned to a host and then spread out that storage among virtual machines.

Great questions. This is the first time I've worked with a SAN. I will ask the systems admin. Do you happen to know of a good write-up/whitepaper to give me...

Perry Whittle (12/3/2014)

---

JoshDBGuy (12/1/2014)

---

I have less than 4 cores so my current setting is 0. However, I see some recommendations to set it to "0 to N". Will this make...