Viewing 15 posts - 3,331 through 3,345 (of 8,761 total)
August 2, 2016 at 11:45 pm
yujinagata72 (8/2/2016)
When I run an SQL query, sometimes I got the error,
Msg 9420, Level 16, State 1, Line 6
XML parsing: line 2, character 33, illegal xml character
and sometimes is okay....
August 2, 2016 at 10:59 pm
You can use Adam Machanic's sp_WhoIsActive to identify the culprit
😎
August 2, 2016 at 10:55 pm
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]...
August 2, 2016 at 10:47 pm
Nadrek (8/2/2016)
Eirikur Eiriksson (8/2/2016)
My experience so far, 20-30% difference in performance between 2008R2 and 2016 when simply migrating from one to the other.😎
In-place upgrades with no other changes, same hardware,...
August 2, 2016 at 2:21 pm
My experience so far, 20-30% difference in performance between 2008R2 and 2016 when simply migrating from one to the other.
😎
August 2, 2016 at 2:03 pm
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...
August 2, 2016 at 1:17 pm
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...
August 2, 2016 at 1:00 pm
August 2, 2016 at 12:16 pm
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...
August 2, 2016 at 5:50 am
You are very welcome and thanks for the feedback.
😎
August 2, 2016 at 5:35 am
BrainDonor (8/2/2016)
Luis Cazares (8/2/2016)
BrainDonor (8/2/2016)
Anybody remember DataEase? They've 'relaunched' the DOS version:http://www.dataease.com/test_article_view/?ArticleID=00122&field1=00122
Sorry, I wasn't born yet.
Some of us had to convert data from that delightful system, used by some of...
August 2, 2016 at 5:33 am
pcd_au (8/2/2016)
Eirikur Eiriksson (8/2/2016)
pcd_au (8/1/2016)
August 2, 2016 at 5:18 am
pcd_au (8/1/2016)
August 2, 2016 at 1:51 am
astrid 69000 (8/2/2016)
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...
August 2, 2016 at 1:42 am
Viewing 15 posts - 3,331 through 3,345 (of 8,761 total)