I tested it for small strings but not for big ones.

Basic concept (with default settings)

select null + abc => null

anything added/concatenated to null is null.

and see this too http://technet.microsoft.com/en-us/library/ms176056(v=sql.105).aspx

First, See this link http://blogs.technet.com/b/neiljohn/archive/2013/08/31/retiring-the-microsoft-master-certifications-and-training.aspx

GilaMonster (11/11/2013)

---

Profiler trace doesn't show...

Does this the same case with profiler trace stats too?

create function dbo.SplitString

(

@STR nvarchar(max),

@separator char(1)

)

returns table

AS

return (

with tokens(p, a, b) AS (

select

...

I also second "Parameter sniffing " here.

try to implement covering index on non clustered indexes to remove lookups.

sandyinfowave (11/8/2013)

---

How do we generally determine if a...

please elaborate. Or ANy article reference.

Check whether below query results are part of AD or not

select name from SYS.server_principals where type in ('U', 'G')

and name not like 'NT %'

You have to do that ..sooner or later.. data migration(DML) operation disturbs the...

Maddave (11/8/2013)

---

Some of them have also ventured into using single user mode, but again, they end up locking themselves out of the database and not being able to reconnect to...

ok so based on sample data above which rows should get selected ?

So Are you saying that the result should contain (7th, 8th) and (15th, 16th and 17th) rows ?

Welcome to SSC.

Read this http://technet.microsoft.com/en-us/library/ms191517(v=sql.105).aspx