ramana3327 (8/25/2014)

---

Hi,

If we want to move SQL Sever 2008R2 to SQL 2102,

In placemigration (Upgradation) or side by side migration is better? How can we decide which one is better...

From what I understand, this should get you started

😎

USE tempdb;

GO

create table dbo.error_staging

(ld_date INT

,s_code varchar(10)

,error_code varchar(10)

,[mbr_no] varchar(10));

insert into dbo.error_staging

values(20140811, 'S000310D', '200016','A023539B'),(20140812, 'S000430D', '200016','A544348B'),(20140813, 'S001204D', '200016','A240640B'),

(20140815, 'S000365D', '200160','A398944B'),(20140815, 'S000446D', '200160','A395200B'),(20140815,...

You are welcome.

While the splitting part works fine with very short list of elements, you might want to look at DelimitedSplit8K[/url] for better splitting performance when handling...

arooj300 (8/25/2014)

---

Hi Eirikur

Thanks for the reply. I have plenty of space in T drive almost 200 GB. and I have checked with partial and no cache but there is no...

Quick solution, searches sys.parameters for the...

The error is exactly what is says on the tin, the system is out of disk space on the T: drive. To resolve this, either some space has to be...

Here is a quick solution, uses charindex instead of patindex. It does leave some room for improvements though, especially in the search string splitting part.

😎

USE tempdb;

GO

/* The strings to search...

dwain.c (8/25/2014)

---

Eirikur Eiriksson (8/24/2014)

---

dwain.c (8/24/2014)

---

Maybe I'm missing something here but I think there's no reason to construct a delimited list at all.

SELECT a.CVID, a.JobNoticeID, IsMatch=CASE WHEN b.JobNoticeID IS NOT NULL...

I guess the threshold is a configured value...

Out of curiosity, isn't this a slight contradiction on...

Here is a very well performing solution which adds a covering filtered index, simply blazing fast.;-) Even without the index it is still more than three times faster than previous...

dwain.c (8/24/2014)

---

Maybe I'm missing something here but I think there's no reason to construct a delimited list at all.

SELECT a.CVID, a.JobNoticeID, IsMatch=CASE WHEN b.JobNoticeID IS NOT NULL THEN 1 ELSE...

That's an understatement if I ever seen one:-D

😎

TomThomson (8/24/2014)

---

up to there I agree with you 100%

because, and with absolutely no malice in my...

Here is yet another solution, similar to Lutz's apart from the grouping. Tends to be slightly quicker on small sets.

😎

USE tempdb;

GO

create table #test (name nvarchar (10),point_of_time datetime)

insert #test (name,point_of_time)

select 'd','2014-08-19...