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:

-...

+1

😎

Certainly drop the...

Quick solution

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @SAMPLE TABLE (ID CHAR(4),Salary INT,Employee_Tax1 INT,Employee_Tax2 INT,Employer_Tax1 INT,Employer_Tax2 INT);

INSERT INTO @SAMPLE(ID,Salary,Employee_Tax1,Employee_Tax2,Employer_Tax1,Employer_Tax2) VALUES ('A001',1000,120,95,125,105);

SELECT

X.ID

,X.Earn_Ded

,X.Employer_Tax

FROM @SAMPLE S

CROSS APPLY

(

...

Quick solution

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'tempdb..#t') IS NOT NULL DROP TABLE #t;

create table #t

(

id int,

col1 decimal(18,2)

)

go

insert into #t (id,col1)

values...

I guess you are not referring to TT's posts:-D

😎

This whole thing doesn't make sense unless more information is provided, memory configurations and specs are relative to all the work the server has to perform, not exceptions like occasional...

ricardo_chicas (11/20/2015)

---

Yeah, it is just sad that we define a clustered index, therefore ordered, with two variables that are of the same data type withing the scope of the query,...

First thing that comes to mind is parameter sniffing and local variables, suggest you read up on the subject, plenty of good articles around covering this.

😎

No I don't...