I don't think your approach is clumsy, in fact if you add a POC (Partition Order Cover) index on the table, this method is very hard to beat!

😎

-- create table

if...

Talib123 (8/27/2014)

---

While running missing index script I came across a few indexes that use XML and Geography data types. Never really used these before and am looking for advice.

XML and...

GilaMonster (8/27/2014)

---

Of course not, you would never:-D

... just trying to show the complexities of doing this kind of search. The 'best' way (IMHO) would be to normalise...

Something like this?

😎

DECLARE @SAMPLE TABLE

(

id_Contract INT NOT NULL

,nm_ContractType VARCHAR(25) NOT NULL

...

Apart from being a futile effort using the nolock hint with update / delete, it is...

Good point, that will ferment into a false positive;-)...

Robert Heynen-454800 (8/27/2014)

---

I am trying to write to a file using .Net. In one column, I am wrapping the output in a unicode char(164)

i.e.

select char(164) + ColumnText + char(164)

The...

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