JohnG69 (12/15/2015)

---

Lynn Pettis,

In our case we can't serialize the code... Initially the code was made to run single threaded and now they have decided to split the processing based on...

JohnG69 (12/15/2015)

---

The only problem with that is that I can have 4 processes doing exactly the same thing for different customers.

The global temp table will be hijacked by another process...

Change from a local temp table to a global temp table. I did that in a sandbox database and it worked, just can't post the code from work.

May cause...

Welsh Corgi (12/14/2015)

---

Lynn Pettis (12/14/2015)

---

Here is how I look at it. If the people who build, create, and maintain the servers (physical or virtual) have decided to install Windows...

Here is how I look at it. If the people who build, create, and maintain the servers (physical or virtual) have decided to install Windows Server Core on the...

fabriziodb (12/11/2015)

---

in a 3 columns table id , date , page i need a query to extract all distinct dates and the id with min page:

in the following example the...

Actually, the TEXT data type is still available in SQL Server 2014. Yes, it has been deprecated since 2005, but until Microsoft removes the TEXT data type from all...

Welsh Corgi (12/9/2015)

---

GilaMonster (6/12/2015)

---

In Server Core installation, no, but since you should never be using SSMS on the server, that's hardly...

Not sure what is causing your problem. I have used SSMS for 2012 for several years and now using SSMS for 2014 without any of the problems you are...

Aditya Daruka (12/3/2015)

---

It may be slower, but still quite an interesting way of playing with t-sql

Everything is not always about speed!

I am happy with tally function, great way to tackle...

SQLRNNR (12/3/2015)

---

no never. Terminators...

SQLRNNR (12/3/2015)

---

no never. Terminators...

SQLRNNR (12/3/2015)

---

no never. Terminators...

Walk away, yes, that individual did start a CTE with a semicolon, just let it go...

Party in the TitD! Let's blow off so steam!!

Jeff Moden (12/3/2015)

---

himanshu.sinha (12/1/2015)

---

Thanks Jeff for the idea of putting the while loop in TRAN , I think I understand the logic behind that . I hope if anyone...