Orlando Colamatteo (2/1/2016)

---

As an aside, it is a best practice in SQL Server for all tables to have a clustered index and a primary key. Any reason why this table...

Well, I can't help you with the SSIS part of it. I was going to say that when you run something against multiple servers at once in SSMS, the...

sqlnewbie17 (2/1/2016)

---

EXEC msdb.dbo.sp_get_sqlagent_properties

How do I retune the servername along with the columns returned by the abover SP

i.e

Result should have select @@servername+ result of EXEC msdb.dbo.sp_get_sqlagent_properties in a single...

You said you weren't sure how the COALESCE function worked. Quite simply, it returns the first non-NULL expression in your list.

For further reading, it's fully covered in Books Online...

Hello and welcome to SSC.

If your intent is to query the first populated column, then you could just use a COALESCE function and skip the CASE. Example:

SELECT COALESCE(IND.TERM_YYYYMMDD, CLM.TERM_YYYYMMDD_02,...

Ray K (2/1/2016)

---

Ed Wagner (2/1/2016)

---

Ray K (2/1/2016)

---

Ed Wagner (2/1/2016)

---

Grumpy DBA (2/1/2016)

---

Ed Wagner (1/29/2016)

---

DonlSimpson (1/29/2016)

---

Stracotto...

Always glad to help.

It looks like you're creating a folder for every row that gets inserted into a table. Presumably, you're going to write some data to each one of these folders...

jasona.work (2/1/2016)

---

Ed Wagner (2/1/2016)

---

jasona.work (2/1/2016)

---

Just read through the topic in question, sounded a bit to me as being more like "Please indicate that this may be OK as I really...

Ray K (2/1/2016)

---

Ed Wagner (2/1/2016)

---

Grumpy DBA (2/1/2016)

---

Ed Wagner (1/29/2016)

---

Ragu Bolognese (Never made...

I have them, but thank you for the offer. I'm tracking the time for each database, but not for each UPDATE STATISTICS statement. I figured that isn't as...

If using SSIS, the only real difference is that you'd be effectively using a BULK INSERT to write the rows to your local table. The reads on the remote...

jasona.work (2/1/2016)

---

Just read through the topic in question, sounded a bit to me as being more like "Please indicate that this may be OK as I really don't want to...

I agree with everyone else. Development and test are development and test. If it feels like production at all, then it's probably production. Monitoring production is production.

Then...

Grumpy DBA (2/1/2016)

---

Ed Wagner (1/29/2016)

---

Ragu Bolognese (Never made Stracotto, but I have...