sqlfriends (2/15/2012)

---

SQLKnowItAll (2/15/2012)

---

They are groups. Notice when you look at the icons in SSMS they are not a single person, they are 2. So, a domain account that...

I didn't say that the only alerts you needed are cpu and memory, what I said was that it wil depend on your entire architecture. Hopefully your OPs team is...

The types of performance alerts that you are mentioning are really not necessary until a problem occurs. If you monitor the error log regularly, you can pretty much see...

They are groups. Notice when you look at the icons in SSMS they are not a single person, they are 2. So, a domain account that gets added...

Are you saying that you are running this "report" in SSMS? Or are you exporting to a file from SSRS?

ScottPletcher (2/15/2012)

---

I think the order does matter for the clus index and whether it gets fragmented or not. SQL is coded to recognize sequential inserts and not cause page...

Jeff Moden (2/14/2012)

---

SQLKnowItAll (2/14/2012)

---

I believe that in this case, the clustered index is...

@lutz

Your scenario 1 most certainly requires an unlimited CAL license if you cannot account for all devices. This is one of those "indirect" scenarios that should have a socket...

When talking to Microsoft about this, they said any person or device directly or indirectly touching the SQL Server requires a CAL. For example, if a website touches SQL Server...

Glad to hear you solved the issue, but could you provide us with execution plans from the original statement's insert versus just the select. Its nice that you "maintain"...

In that case, I would reinstall or repair SSIS.

I believe that in this case, the clustered index is on the identity....

Did you try to run the package again? You are not giving me enough details about what you are trying and what is happening. You should not worry about the...

Need more info. Do you reference linked servers?

ScottPletcher (2/14/2012)

---

I take that to mean what it explicitly says -- if you do SELECT ... INTO...