So now we know that there are performance issues, at least we have a slightly better picture...

KSQLDBA (12/7/2015)

---

I have 2 diffenrent databases accessed by 2 different teams: Web Support Team access DB1 And Customer Services DB2

I want be able to simultaneously update DB2 of any changes...

BrainDonor (12/7/2015)

---

I don't think that your answer is right. I believe that your answer is wrong.

I don't know what the answer is.

Helpful, so very, very helpful.

Tell me I'm wrong...

Jeff, there was something about email changes few weeks back, are you forward in the notifications across domains?

😎

Meatloaf (12/3/2015)

---

Hi,

Is it possible to create an INSERT STATMENT with an EXEC AND additional parameters?

For example, I am trying to do the following:

INSERT INTO #Temp (File_Dir, Files_In_Dir, DepthCnt, FileCnt)

VALUES (@FileDir,...

Announcing the front runner for the Crystal Ball Award nomination 2015

😎

NOTE: Please support your favourite CBA by NOT answering the missing questions:-D

The answer is the same as to...

Brandie Tarvin (11/30/2015)

---

Eirikur Eiriksson (11/27/2015)

---

Brandie Tarvin (11/27/2015)

---

My SO just informed me that he's learned how to write a LEFT INNER JOIN in Oracle.

And now my head is just spinning with...

Alan.B (11/30/2015)

---

Brandie Tarvin (11/30/2015)

---

Luis Cazares (11/30/2015)

---

Brandie Tarvin (11/30/2015)

---

Eirikur Eiriksson (11/27/2015)

---

Brandie Tarvin (11/27/2015)

---

My SO just informed me that he's learned how to write a LEFT INNER JOIN in Oracle.

And now my...

Luis Cazares (11/30/2015)

---

Do you really need the hints? Do you understand the problems of NOLOCK? Why do you need to specify the index? Wouldn't the query processor use it? Why...

Quick suggestion, use MAX and GROUP BY to eliminate the blanks and compress the rows into one row.

😎

USE tempdb;

GO

SET NOCOUNT ON;

;WITH SAMPLE_DATA(ID,COLA,COLB,COLC) AS

(

SELECT * FROM

...

Quick suggestion

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @test-2 TABLE

(

id int,

knt INT,

name VARCHAR(10),

...

Brandie Tarvin (11/27/2015)

---

My SO just informed me that he's learned how to write a LEFT INNER JOIN in Oracle.

And now my head is just spinning with the notion that an...

Phil Parkin (11/26/2015)

---

TomThomson (11/25/2015)

---

Steve Jones - SSC Editor (11/25/2015)

---

Alvin Ramard (11/25/2015)

---

Steve Jones - SSC Editor (11/25/2015)

---

The spam problem is tough. Believe me, no matter what we do, people will find...

rhaberkorn (11/24/2015)

---

I'm trying to return the number of pieces from a table where the piece count can be NULL, 0, or any whole number 1-999.

I need my query results to:

-...