I've found the method I use for timing more accurate than the time statistics

😎

distrust

Using my normal test harness, Kristen's DATETIMEFROMPARTS solution is a clear winner, more than twice faster than the next one. Note that the slowest solutions and those generating conversion errors...

Nomvula (9/17/2015)

---

i have the following table I need to select dates grouping them by weeks, my week start is Saturday to Friday

CREATE TABLE weekdays

(

datevalue ...

Inferno

Two quick suggestions

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @SAMPLE_DATA TABLE

(

Store CHAR(1) NOT NULL

,Sales ...

Jeff Moden (9/16/2015)

---

Sean Lange (9/16/2015)

---

Thanks Drew. I don't use...

A more common scenario would be something like this, given the facts that:

a) Inserts and update are relatively inexpensive

b) Data comparison is relatively expensive

c) Good enough algorithms...

jasona.work (9/16/2015)

---

Ed Wagner (9/16/2015)

---

jasona.work (9/16/2015)

---

Hmm...

The server is a *little* bit loud...

Like, sitting on the workbench, basement door closed, can still hear the fans roaring on the main floor loud...

This...

Could be...

Utopia

Sean Lange (9/16/2015)

---

I have a very awful table structure that I have to deal with. This is in an ERP and I can't change the tables...yes I know how completely...

tauseef.jan (9/15/2015)

---

hi,

I have a table in PRODUCTION server with more than a billion records. I am running the below query to check the exact number of records in it.

select count...

Minnu (9/16/2015)

---

Hi Team,

I have a database with Name 'Marketing' and i have created another database 'Marketing1' in same instance.

i want to bring the 'Marketing' database offline and alter 'Marketing1' to...

pietlinden (9/15/2015)

---

Anybody using (and like) PowerView? Are there any good resources on it? I kinda like PowerPivot (just having a hard time getting my head around it)... but PowerView...

Rumble