+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...

rameelster (11/20/2015)

---

DB server consists of Inter Xeon processor(2 Processors) with 40 cores and a memory size of 64 GB. I have allocated 61 GB for sql server and the rest...

Quick suggestion

😎

USE tempdb;

GO

SET NOCOUNT ON;

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

Create Table #Test

(id int identity,C1 bit , C2 Bit , C3 Bit)

insert into #Test Values (0,0,0)

...

Jeff Moden (11/19/2015)

---

There are many more but, just to wet the appetite for other possibilities...

SELECT {fn NOW()};

SELECT {fn CURRENT_DATE()} + ' ' + {fn CURRENT_TIME()};

EXEC...

Couldn't fit it in the select statement, too many EXEC'y thingies in there, any alternatives?

😎

Alvin Ramard (11/19/2015)

---

Eirikur Eiriksson (11/19/2015)

---

That looks way too close to a union all statement...

That looks way too close to a union all statement for comfort:-P

😎

How come?

😎