Read the following article and consider using the Quirky Update described in it. It also describes different approaches.

http://www.sqlservercentral.com/articles/T-SQL/68467/

Have you read this?

https://support.microsoft.com/en-us/kb/942861

You need to review the processes running that increase the size of TempDB. Probably large loads that need ordering, index rebuilds or bad queries. You could use extended events to...

Would the Import/Export Wizard could help you? It uses SSIS to export the data and you can save the package to edit it or run it anytime.

Ed Wagner (7/22/2015)

---

Brandie Tarvin (7/22/2015)

---

Here's my fun thing for the day:

2 a.m. Email: Disk X on non-prod server test is full

2 a.m. Email: Disk Y on non-prod server qa is...

Brandie Tarvin (7/22/2015)

---

BWFC (7/22/2015)

---

'Why didn't this appear on your report? It's wrong. There's been an incident and you've made us look bad in front of government.' - The...

You're right Jacob. That's what I get for not testing my code. 😀

This might help you. Be sure to test it and understand it. Ask any questions that you might have.

WITH CTE AS(

SELECT *,

...

You can use PIVOT or you can use cross tabs. I personally prefer cross tabs.

To do this correctly, you need to create a row number for each item in the...

Liver

The most important part. Do you understand how it works? Remember that you will need to support this code.

Hi,

As mentioned by Sean, it's better if you provide sample data in a consumable format. This time I did it because I have free time.

The logic wasn't very clear, but...

Lynn Pettis (7/21/2015)

---

Okay, help us help you. Please post the DDL (CREATE TABLE Statement) for the table(s) involved, sample data for the table(s) (INSERT INTO statements), and expected results...

Christopher Kutsch (7/21/2015)

---

This version cannot keep up with XML splitting or CLRs, but won't fail on reserved characters like ampersands. For a tool that is used in ETL and non-OLTP...

Christopher Kutsch (7/21/2015)

---

Just a first crack at it, using a Split String function I have posted on this site as a tool http://www.sqlservercentral.com/scripts/SUBSTRING/124330/:

SELECT partnum

, ...