shaimaa.tarekelshoeiby (8/25/2014)

---

Thank you for the excellent post .

Can you please help me become capable of doing such analysis?

How were you able to make the simplified ERD and come up with...

Raghavendra Mudugal (8/25/2014)

---

I have one SP where...

Thank you for this nice piece C.J.

😎

Quick questions, did you create these...

Jeff Moden (8/24/2014)

---

You're saying that your normal data contains clear-text SSNs? And...

Quick question, how beefy is the index/indexes being rebuilt? Would it be an option to build an identical index with the ONLINE option and then drop the existing one afterwards?

😎

Just a quick thought, could this be a permission issue? Try creating a folder, give the appropriate permissions on...

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