Grant Fritchey (3/22/2013)

---

Sorry, I can't tell anything from that. You can export an execution plan as a .SQLPLAN file and then load it up to the web site. Then I...

I'll type it out,

First

Select

...

This is a very valuable tip.

Most people do not know this. So spread the tip around.

For Excel...

Lynn Pettis (3/1/2013)

I'll have to disagree with you and side with Jeff. I have learned much from him and scalability and reuse actually come hand in hand. If...

Thanks for the link.

Allthough with the profiler you can get results for individual statements, the profiler does not make...

Jeff Moden (2/26/2013)

---

Just be aware that string conversions of dates will be a bit slower than integer conversions. It'll take a million rows to notice a difference but every...

And another alternative solution, based on 'strings'

declare @Month int = 2, @Year int = 2013

declare @ThisDate datetime = convert(varchar(8),@year*10000+@month*100+01)

select CONVERT(varchar(7),@thisdate,121)+'-01'

select CONVERT(varchar(7),dateadd(mm,1,@thisdate),121)+'-01'

ben brugman

GilaMonster (2/22/2013)

---

ben.brugman (2/22/2013)

---

GilaMonster (2/22/2013)

---

If the PLE is 400, then on average a page is expected to remain in cache for a total of 400 seconds. 400 seconds from the time...

Is that from the moment we measure. Or from the moment...

Sorry but with any...

The average time a page remains in the cache is two...

The E stands for expectancy....

DECLARE @TODAY DATETIME = CONVERT(DATETIME,CONVERT(VARCHAR(10),GETDATE(),126))

SELECT @TODAY

DECLARE @TOMORROW DATETIME = @TODAY+1

--

-- Alternative

-- DECLARE @TOMORROW DATETIME = DATEADD(DD,1,@TODAY)

-- DECLARE @TOMORROW DATETIME = DATEADD(HH,24,@TODAY)

--

SELECT @TOMORROW

SELECT * FROM TheTable WHERE TheDate >= @TODAY AND...

Thanks, and yes this was clear to me from your posts.

Ben

Thanks, most or all other tables have the UNIQUE 'constraint', this table should have the UNIQUE constraint. Thanks...