Grumpy DBA (4/18/2016)

---

Ed Wagner (4/18/2016)

---

Eirikur Eiriksson (4/18/2016)

---

My twin brother is a meteorologist and he says the same, up to 72 hours is normally fine and then you can start to...

Few quick thoughts, why use temporary tables? At the first glance they only seem to add IO and break up the flow.

The function eufn_e5_eSM_SE_GetCurrentItemLocation is a scalar function, what is...

Phil Parkin (4/18/2016)

---

Eirikur Eiriksson (4/18/2016)

---

Phil Parkin (4/18/2016)

---

Eirikur Eiriksson (4/18/2016)

---

No insight info but have been playing around with 2014 as target server and so far no problem. Note that I've not...

Phil Parkin (4/18/2016)

---

Eirikur Eiriksson (4/18/2016)

---

No insight info but have been playing around with 2014 as target server and so far no problem. Note that I've not used any version specific...

jasona.work (4/18/2016)

---

Couple...

No insight info but have been playing around with 2014 as target server and so far no problem. Note that I've not used any version specific libraries in script components...

shamshad.ali (4/18/2016)

---

Ids could be deleted so they won't match from random generated numbers, I need something like existing Ids only to be shuffled.

Tried following and it only uses the random...

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

---

BWFC (4/15/2016)

---

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

---

Eirikur Eiriksson (4/15/2016)

---

Wouldn't mind...

Brandie Tarvin (4/18/2016)

---

Eirikur Eiriksson (4/15/2016)

---

Brandie Tarvin (4/15/2016)

---

Eirikur Eiriksson (4/15/2016)

---

jeff.mason (4/15/2016)

---

Eirikur Eiriksson (4/15/2016)

---

Further on Luis's good advice, change

USE MyWorkplace;

GO

to

USE master;

GO

otherwise you'll get the error

Msg 3702, Level 16, State 3, Line 6

Cannot...

Quick suggestion, add default values to the new columns

😎

,NEW_COL INT NOT NULL DEFAULT(0)

Quick suggestion

😎

USE Test;

GO

SET NOCOUNT ON;

GO

IF OBJECT_ID(N'dbo.VNEWID') IS NULL

BEGIN

DECLARE @CREATE_VIEW NVARCHAR(MAX) = N'

CREATE VIEW dbo.VNEWID

...

djmenon21 (4/17/2016)

---

Try to write the simplest query that fully answers the question, avoiding unnecessary complexity.

These tables from our data warehouse provide enough information to answer (you may not need all...

jharris215 (4/15/2016)

---

I have trying everything, Perstaging the SQL Network name with the right permissions and I'm still this error Log Name: System

Source: ...

Phil Parkin (4/15/2016)

---

Eirikur Eiriksson (4/15/2016)

---

Phil Parkin (4/15/2016)

---

GilaMonster (4/15/2016)

---

I'm going to have to steal "Don't have...

Sean Lange (4/15/2016)

---

Eirikur Eiriksson (4/15/2016)

---

Ed Wagner (4/15/2016)

---

Greg Edwards-268690 (4/15/2016)

---

Eirikur Eiriksson (4/15/2016)

---

jeff.mason (4/15/2016)

---

Eirikur Eiriksson (4/15/2016)

---

Quick fix...