There can be lots of differences. How much data does the procedure work on in each environment? Are the execution plans the same? If not, why not? Have you looked...

Steve - I would like to write this one up.

Jeff Moden (8/19/2015)

---

There are very few places in SQL Server that have nearly absolute rules but one of them is that you should never store dates or times in any...

JKSQL (8/20/2015)

---

I am in pretty much the same place. I have to verify each version and then if things happen in customer locations I have to get the DB's...

Thank you all for the responses. It does indeed look like a parameter sniffing issue. My question was why did it keep popping up. Basically if the...

Solved it myself. When I looked at 'C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\SQLServer2014\setup.exe' the file size was 0 KB. I renamed that to setup.exe.old, and re-ran the installer from...

Koen Verbeeck (10/17/2014)

---

If you find that any advice given to you was below your standards of quality, the people that gave you the advice will gladly...

Load the new data into a temp table, and then use MERGE.

http://msdn.microsoft.com/en-us/library/bb510625.aspx

I do every day 😀

Beatrix Kiddo (7/10/2014)

---

Hi. In the margin on the left of the screen <--- there is a link called Books, which is a good place to start. Some of them are...

Amen!!

Are those stats updated automatically, or by a maintenance routine? If I read that correctly, the stats are updated AFTER the job starts. What might be happening is...

Maddave (5/22/2014)

---

Hi, I am creating an non clustered index on a table which has over 30 million rows in it as follows:

CREATE NONCLUSTERED INDEX IX_ParentCode

ON [dbo].[Codes] ([ParentCode])

INCLUDE ([Id], [ExternalOrderNumber])

When...

Check Windows and SQL logs.

ps_vbdev (5/6/2014)

---

Im building my first star schema

Order fact table with Product, retailer. date and customer dimensions so that's fine.

im finding it hard getting my mind set out off my...