Hi and welcome to the forum, complements on the fine DDL and sample data!

Not too clear on what you are after but please bear with me as I'm only on...

errolthomasql (8/27/2014)

---

i am not sure how this will show up after changing the file extension. i wasnt able to upload as .csv

also, i am not going to be opening up...

Thanks for the question Shiva!

😎

Quick question, why the non-standard representation of negative numbers? Just open the file in Excel and change the number formatting.

😎

Brings back baaaad memories and resulting nightmares, when marketing, MIS, CRM teams etc. think there is a contained formula for email...

Again, quick question, what version and edition of sql server (select @@version) are you on? You do know that it is kind of offensive not to answer questions when someone...

Gazareth (8/27/2014)

---

No problem, shrinks are fine if you've just deleted/moved a load of data like you have here.

It's a good idea to run an index defrag/rebuild afterwards though.

Don't know how...

Robert Heynen-454800 (8/27/2014)

---

There seems to be an issue in regards to ANSI vs Unicode

When the file is viewed as an ANSI encoded file, both chars show

When the file is viewed...

rocky.paiano (8/27/2014)

---

Hello all

I am performing analysis of linked servers across 2000-2008R2 and need to find/build a list of linked servers that are truly active. For the sake of the...

ryetimothy (8/27/2014)

---

Someone I work with created the wrong ODBC connection and entered data in the wrong database (old copy on an old server that's about to be decommissioned) and I...

jralston88 (8/27/2014)

---

We have a SQL Server 2008 Enterprise cluster two node environment (64 bit). We have a default instance and two named instances on it. With named instances...

2Fire (8/27/2014)

---

We are running SQL2012 with -