Uwe Ricken (8/6/2015)

---

The fragmentation of the Indexes (INT or GUID) is nearby...

sqlfriends (8/5/2015)

---

I am pulling User and their groups from AD to a csv file. Then import them into SQL table, but I would like some clean up of the filed...

ilovedata (8/5/2015)

---

DECLARE @IssueData TABLE

(

IssueID INT,

IssueTypeID INT,

Value INT

)

INSERT INTO @IssueData VALUES (1, 1, 20), (1,2,50), (1,3,1), (1,4,2), (2,2, 50), (3,1,20), (3,3,1)

DECLARE @IssueStatus TABLE

(

IssueTypeID INT,

Value INT,

IssueTitle VARCHAR(24)

)

INSERT INTO @IssueStatus VALUES (1, 0,...

SSIS/DTS packages. Including maintenance plans. This is harder to change.

newbieuser (8/5/2015)

---

I tried the below script, it prints all the alter commands. But, when I do execute @sql instead of print, I get the below error..

declare @sql nvarchar(max)

SELECT 'ALTER...

Jack Corbett (8/5/2015)

---

SQLRNNR (8/4/2015)

---

Steve Jones - SSC Editor (8/4/2015)

---

Since we're all piling on the behavior of others, I was wondering.

Is there value in getting the questions/knowledge that people...

A slight twist on Steve's:

declare @var varchar(8000)

set @var='Name1~50~20~50@Name2~25.5~50~63@Name3~30~80~43@Name4~60~80~23'

SELECT ds1.ItemNumber AS RowNumber,

MAX(CASE WHEN ds2.ItemNumber = 1 THEN ds2.Item ELSE NULL...

Use the DelimitedSplit8K function (found on this site, at the "Splitting Delimited Strings" link in my signature) to split this string on the spaces.

Then use this query to get the...

DiabloZA (8/4/2015)

---

Hi Guys,

So Wayne's solution worked perfectly until they changed the requirements a bit, now IN_PUNCH and OUT_PUNCH columns should be blank if there are only ABSNET_HRS in a day,...

I'm...

Luis Cazares (8/4/2015)

---

Lynn Pettis (8/4/2015)

---

SQLRNNR (8/4/2015)

---

Lynn Pettis (8/4/2015)

---

SQLRNNR (8/4/2015)

---

Steve Jones - SSC Editor (8/4/2015)

---

Since we're all piling on the behavior of others, I was wondering.

Is there value in getting the...

Eirikur Eiriksson (8/5/2015)

---

Koen Verbeeck (8/5/2015)

---

I have been nominated again for Author of the Year at MSSQLTips.com. For some reason they already started the voting process, which runs until the end...

Lynn Pettis (8/4/2015)

---

SQLRNNR (8/4/2015)

---

Lynn Pettis (8/4/2015)

---

SQLRNNR (8/4/2015)

---

Steve Jones - SSC Editor (8/4/2015)

---

Since we're all piling on the behavior of others, I was wondering.

Is there value in getting the questions/knowledge that...

dwain.c (8/4/2015)

---

SQLRNNR (8/4/2015)

---

WayneS (8/4/2015)

---

Sean Lange (8/4/2015)

---

yb751 (8/4/2015)

---

Raise your hands if you like Entity Framework...then I'll know who to shoot!

Sorry just needed two seconds to vent. :crazy:

I'm sure like anything else...

I know some very highly regarded people that advocate keeping all backups (full, diff, tlog) for at least a month. This will give you the most flexibility and multiple restore...