Brandie Tarvin (11/4/2015)

---

Bridge Guardian: What is your name?

DJJ: Umm. I don't know?

DJJ: AGGGGHHHHH!

Bridge Guardian: Sigh. Usually they get to the swallow question before they go...

Piling on further, now 23 posts into this thread and yet there are nowhere near enough information to even begin to guess let alone advice on the problem. Few facts...

That's an entirely different...

Quick fix

😎

CREATE TABLE #ActivityComments(Comments NVARCHAR(MAX))

INSERT INTO #ActivityComments VALUES('This is the study code for Field Phase S14-04932-01')

INSERT INTO #ActivityComments VALUES('Phase reporting has the study S15-04931-01 which is obselete')

INSERT INTO #ActivityComments VALUES('Phase...

Quick solution

😎

USE tempdb;

GO

SET NOCOUNT ON;

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

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

CREATE TABLE dbo.customer_payment

(

Customer_Nbr_TxtVARCHAR(255),

Loan_NbrBIGINT,

Trans_Amt decimal(22,2),

Payment_tp VARCHAR(255)

);

INSERT INTO dbo.customer_payment (Customer_Nbr_Txt,Loan_Nbr,Trans_Amt,Payment_tp)

VALUES

('007849', '11613577', '1000','ACH'),

('007849', '11613578', '200',...

Further on Gail's excellent answer, can you post the actual execution plan and preferably the DDL (create scripts) for all tables, functions and indices?

😎

First glance at the code suggests that...

Further on Jacob's excellent suggestion, check for the existence of the pattern before the substring, as you could have false positives when the pattern is not found.

😎

GilaMonster (11/3/2015)

---

No spare time this week, but given the...

Resender (11/3/2015)

---

ChrisM@Work (11/3/2015)

---

Resender (11/3/2015)

---

In the meantime 123883 tables (yes 30 new tables got added) the total recordcount is

89,372,968,620

I wish I knew but I'm...

sraghunandana.6 (11/2/2015)

---

Hi Team,

I have taken a compressed online backup of one database. The database size came from 360GB to 190GB.

Now i want to restore the compressed backup which should replace...

Lynn Pettis (11/2/2015)

---

It was awesome to get to meet some of the denizens of The Thread last week. Too bad Jeff Moden wasn't able to be...

rohan1424 (11/1/2015)

---

Hello .

I have a prod server running SQL 2012 Standard which host our DB which is about 50 GB . We have enabled logshipping on a secondary sever which...

IIRC I did this in the passed with a start-up macro, which fired a code that added the protection when the spreadsheet was opened.

😎

coolchaitu (11/1/2015)

---

Good morning Everyone,

I have 4 instances on a box. How can i find which instance is causing memory pressure? Also, how to find which instance is consuming more memory?...

Brandie Tarvin (10/30/2015)

---

Someone needs to have a talk with that David Burrows guy. He's talking crazy in another thread. Like suggesting I could use SQL Server tables to solve a...