Short suggestion, CHAR(39)

😎

Sean Lange (2/8/2016)

---

Ack what a rough start to the week. My dog went for "last outs" about midnight last night and found a skunk. This is the second time in...

Wayne does not chicken out, he turkeys out:-D

😎

There is...

Quick suggestion

😎

DECLARE @A TABLE (ID int, StartDate datetime)

DECLARE @b-2 TABLE (ID int, StartDate datetime)

INSERT INTO @b-2

SELECT 1,GETDATE()-5 UNION ALL

SELECT 1,GETDATE()-7 UNION ALL

SELECT 2,GETDATE()-8 ...

WayneS (2/4/2016)

---

Eirikur Eiriksson (2/4/2016)

---

This was Alex demonstrating DLM & CI, did an impressive job, must add that I removed the bad practice comment from the screenshot ( for fun)

I...

You mean...

Steve Jones - SSC Editor (2/4/2016)

---

Grant Fritchey (2/4/2016)

---

Why do you think I'm working on that database?

Ha!

I'm pretty sure that's one of...

Simply because this is not the BlogsDotRedgate_Dev_Steve database which is on the same...

For fun (screenshot from a RedGate presentation)

😎

Sergiy (2/1/2016)

---

Only thing which was there was...

Quick suggestion

😎

SELECT

D.Domain

,D.CaseName

,D.Type

,D.Stream

,SUM(CASE WHEN D.[Status] = 'Passed' ...

Quick suggestion, replace the curlies out of the ID

😎

$InstID = $XML.DocumentElement | Select InstallationID

$InstID = -replace "{", ""

$InstID = -replace "}", ""

+15,000

😎

Jeff Moden (1/29/2016)

---

GilaMonster (1/29/2016)

---

Jeff Moden (1/28/2016)

---

Rich Mechaber (1/5/2016)

---

You've probably got more material than you need by this point. This one's an old article, but I still find it useful...

mpepe 21547 (1/27/2016)

---

I am having a similar issue:

EXEC master..xp_cmdshell

"dir \\fserver1\NextgenRoot\Prod\EMR\Images\ImageSaved\84C06D96-D350-47ED-B26D-BF1A794D93A6.pdf"

Results:

Volume in drive \\fserver1\NextgenRoot is Data

Volume Serial Number is 3CEC-F907

NULL

Directory of \\fserver1\NextgenRoot\Prod\EMR\Images\ImageSaved

NULL

09/28/2014 01:29 PM ...