Nadrek (8/2/2016)

---

In-place upgrades with no other changes, same hardware,...

My experience so far, 20-30% difference in performance between 2008R2 and 2016 when simply migrating from one to the other.

😎

pcd_au (8/2/2016)

---

Eirikur Eiriksson (8/2/2016)

You will have to understand how the SQL Server works, which workload is expensive and which factors bear more weight than others, data sizes and IO do...

Here is a quick example of using a CTE to avoid an implicit conversion and producing a decent execution plan.

😎

USE TEEST;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.T1') IS NOT NULL DROP TABLE dbo.T1;

CREATE...

You may want to look at these scripts[/url]

😎

The best approach would probably be using a CTE on the lower cardinality table to do the conversion before the join, hence providing the opportunity to the server to utilise...

You are very welcome and thanks for the feedback.

😎

BrainDonor (8/2/2016)

---

Some of us had to convert data from that delightful system, used by some of...

pcd_au (8/2/2016)

---

Eirikur Eiriksson (8/2/2016)

---

pcd_au (8/1/2016)

---

There's a great article here (http://sqlfool.com/content/PerformanceConsiderationsOfDataTypes.pdf) about WHY you should pick the appropriate scale of a datatype, but in this day and age of fast(er) disks,...

pcd_au (8/1/2016)

---

There's a great article here (http://sqlfool.com/content/PerformanceConsiderationsOfDataTypes.pdf) about WHY you should pick the appropriate scale of a datatype, but in this day and age of fast(er) disks, fast(er) cpu's, compression...

astrid 69000 (8/2/2016)

---

Good morning 🙂

I have a table that if you dont add the date, by defult it will add the date.

create table Raw_Data

(

ID int identity primary key

,DateCreated datetime...

This will skew the value if the time zone is not UTC!

😎

VastSQL (8/2/2016)

---

Eirikur Eiriksson (8/2/2016)

---

VastSQL (8/2/2016)

---

Eirikur Eiriksson (8/1/2016)

---

Have a look...

Quick thought, datetime does not have any time zone awareness and only assumes UTC, convert into a time zone aware data type such as datetime2 instead.

😎

SELECT CONVERT(DATETIME2,'2016-08-01T07:04:24+01:00',127)

VastSQL (8/2/2016)

---

Eirikur Eiriksson (8/1/2016)

---

Have a look at Choosing a...