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?

😎

So to recap, here are 9 different methods for getting the current time, any additions anyone?

😎

SELECT

GETDATE()

,SYSDATETIME()

,SYSDATETIMEOFFSET()

,CURRENT_TIMESTAMP

...

Sean Lange (11/19/2015)

---

Jacob Wilkins (11/19/2015)

---

jasona.work (11/19/2015)

---

Luis Cazares (11/19/2015)

---

jasona.work (11/19/2015)

---

I was going to post this over in Steve's call for Good Basic T-SQL Exercises but decided not to pollute the topic...

Quick suggestion, convert the year to varchar

😎

Coming from a...

Ed Wagner (11/16/2015)

---

GilaMonster (11/16/2015)

---

Brandie Tarvin (11/16/2015)

---

Ed Wagner (11/16/2015)

---

BrainDonor (11/16/2015)

---

djj (11/16/2015)

---

I will be the first to admit I am not the smartest person, but at least I try to ask questions...

djj (11/16/2015)

---

Brandie Tarvin (11/16/2015)

---

Ed Wagner (11/16/2015)

---

BrainDonor (11/16/2015)

---

djj (11/16/2015)

---

I will be the first to admit I am not the smartest person, but at least I try to ask questions by providing...