Quick suggestion, have a look at this article[/url].

😎

yujinagata72 (8/2/2016)

---

Hi,

When I run an SQL query, sometimes I got the error,

and sometimes is okay....

You can use Adam Machanic's sp_WhoIsActive to identify the culprit

😎

Quick example using FOR XML PATH

😎

USE TEEST;

GO

SET NOCOUNT ON;

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

CREATE TABLE [#XMLTable](

[BatchID] [nvarchar](25) NOT NULL,

[Count] [int] NOT NULL,

[Status] [varchar](6) NOT NULL,

[Type] [varchar](10) NOT NULL,

[Code]...

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