Further on Chris's post, can you provide DDL (create table script) and some sample data?

😎

Further on my previous snip, here is a more complete code block with some sample data

😎

USE tempdb;

GO

DECLARE @NUM_SAMPLES INT = 100;

DECLARE @SAMPLE_STR NVARCHAR(MAX) = N'declare @p? varchar(10) set @p?=NULL exec...

Here is an alternative solution using CHARINDEX

😎

Declare @BaseTable table (PKCol int, Column2Search varchar(2000))

Insert into @BaseTable (PKCol, Column2Search)

Select 1001, 'apple,orange,grapefruit'

UNION ALL

Select 1002, 'grapefruit,coconut'

UNION ALL

Select 1003, 'toast'

UNION ALL

Select...

er.mayankshukla (8/26/2014)

---

er.mayankshukla (8/26/2014)Hello Experts,

I have defined a Nvarchar column of 30 bytes

Lets say

create table demo (name nvarchar(30))

But when I see the length of this column by selecting table and pressing...

GilaMonster (8/26/2014)

---

?????

You mean the row header, column and data size entries and offset bytes (which add up to 10 bytes in...

Further on Gail's answer, the sp_help simply queries the sys.all_columns returning the max_length as "Length", no information is given on the overhead bytes used. All columns carry some overhead such...

"Go down to the basement / cellar" was just an attempt to mitigate the risk of you throwing...

simon_s (8/26/2014)

---

Looking at a trace table and trying to remove all the "erroneous" bits in a string e.g the declares etc so I can purely get to proc names.

An...

Quick thought, compare the results of these two queries

😎

;WITH DISTINCT_KIDS3 AS

(

SELECT DISTINCT

load_KIDS3_clients.idClientKey ,

load_KIDS3_clients.firstName ,

load_KIDS3_clients.lastName...

Similar discussion on this thread

😎

arooj300 (8/26/2014)

---

This is not a permission issue. Because from 1 year job is running, and we did not have any problem. But from two days job has started failing because...

Mr.Sahand (8/25/2014)

---

Hi everyone,

I need to run a VBA function in an MS Access database in SSIS.

I put a Execute SQL Task in control flow and link it to the...

Quick thought, is it possible that the initial code was double pasted? Below is what I would guess it should be.

😎

SELECT

tB.ORDER_DATE

,tB.COMMIT_NO

...

tony28 (8/25/2014)

---

Eirikur Eiriksson (8/25/2014)

---

tony28 (8/25/2014)

---

so what do you think, is any soulution than update statistics ? because with these high values I cannot use this procedure, this is very heavy...

tony28 (8/25/2014)

---

so what do you think, is any soulution than update statistics ? because with these high values I cannot use this procedure, this is very heavy for server if...