Viewing 15 posts - 31 through 45 (of 2,462 total)
Jeff Moden (11/11/2013)
Have you ever tested that for performance?
I tested it for small strings but not for big ones.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 12, 2013 at 3:30 am
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
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 11, 2013 at 6:00 am
First, See this link http://blogs.technet.com/b/neiljohn/archive/2013/08/31/retiring-the-microsoft-master-certifications-and-training.aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 11, 2013 at 5:58 am
GilaMonster (11/11/2013)
Bhuvnesh (11/11/2013)
Lynn Pettis (11/11/2013)
The cost values you see in the execution plan are basically arbitrary values.Does this the same case with profiler trace stats too?
Profiler trace doesn't show...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 11, 2013 at 4:40 am
Lynn Pettis (11/11/2013)
The cost values you see in the execution plan are basically arbitrary values.
Does this the same case with profiler trace stats too?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 11, 2013 at 4:30 am
create function dbo.SplitString
(
@str nvarchar(max),
@separator char(1)
)
returns table
AS
return (
with tokens(p, a, b) AS (
select
...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 11, 2013 at 1:51 am
I also second "Parameter sniffing " here.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 11, 2013 at 1:19 am
sandyinfowave (11/8/2013)
but overall operation cost increased(because of lookups)...
try to implement covering index on non clustered indexes to remove lookups.
sandyinfowave (11/8/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 11, 2013 at 1:16 am
TheSQLGuru (11/8/2013)
the engine LIES to SSMS when UDFs are in play.
please elaborate. Or ANy article reference.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 8, 2013 at 8:17 pm
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 %'
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 8, 2013 at 7:28 am
Carl B. (11/8/2013)
if we can avoid rebuilding index uselessly on big tables our client will appreciate that.
You have to do that ..sooner or later.. data migration(DML) operation disturbs the...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 8, 2013 at 7:17 am
Maddave (11/8/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 8, 2013 at 7:00 am
ok so based on sample data above which rows should get selected ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 8, 2013 at 5:44 am
So Are you saying that the result should contain (7th, 8th) and (15th, 16th and 17th) rows ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 8, 2013 at 5:00 am
Welcome to SSC.
Read this http://technet.microsoft.com/en-us/library/ms191517(v=sql.105).aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 8, 2013 at 4:49 am
Viewing 15 posts - 31 through 45 (of 2,462 total)