Jeff Moden

Forum Replies Created

Viewing 15 posts - 30,436 through 30,450 (of 59,101 total)

RE: forimg a sql query using split

@ssurekha2000,
I used a different splitter than you did. Please see the following article for a splitter that's a wee bit more efficient than the XML splitter you used (code...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 7, 2012 at 12:52 pm

#1470430
RE: forimg a sql query using split

Dang. Sorry Lutz. My bad. I had opened this thread last night and forgot to "refresh" before posting so I never saw your post until just now.
At...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 7, 2012 at 12:35 pm

#1470421
RE: forimg a sql query using split

ssurekha2000 (4/7/2012)
in my sql table i have a column summary with data as
1-AB-XY
2-OP-AB
1-AB-XY
1-MN-ZZ-AB
1-OP-AB
2-AB-XY
1-MN-ZZ-AB
1-OP-AB
1-MN-ZZ-AB
i need to get the count of individual category with the id
i mean in row...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 7, 2012 at 11:31 am

#1470411
RE: How to identify query causing huge drop in Page Life Expectancy

winston Smith (4/6/2012)
I have a database server that has a page life expectancy drop to almost 0 each morning. intuition is telling me that it is caused by a sproc...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 7, 2012 at 8:18 am

#1470396
RE: How to identify query causing huge drop in Page Life Expectancy

winston Smith (4/6/2012)
Note I cannot use profiler on this server.
Why's that?
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 6, 2012 at 10:03 pm

#1470357
RE: CLR Integration in SQL

Again, apologies for the delay. This is one of the ways you can do it in T-SQL only. The formula isn't quite as pretty as the REGEX example...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 6, 2012 at 7:17 pm

#1470349
RE: Cursor help

capn.hector (4/6/2012)
Jeff Moden (4/6/2012)
capn.hector (4/5/2012)
Jeff Moden (4/5/2012)
Considering that you input data is only a half of what your output data is, your going to have to describe how the data...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 6, 2012 at 5:19 pm

#1470342
RE: Cursor help

capn.hector (4/5/2012)
Jeff Moden (4/5/2012)
Considering that you input data is only a half of what your output data is, your going to have to describe how the data describes "in" and...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 6, 2012 at 4:31 pm

#1470331
RE: query for consecutive alphabets

sharky (4/6/2012)
Hi Jeff,
Thanks for the UPPER fix.
I have created the table using a clustered index with 50 rows
--
SELECT TOP 50 IDENTITY(INT,1,1) AS N
INTO dbo.Tally
FROM Master.dbo.SysColumns
ALTER TABLE dbo.Tally ...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 6, 2012 at 2:17 pm

#1470282
RE: query for consecutive alphabets

capn.hector (4/6/2012)
sharky (4/6/2012)
Hi Jeff,
Thanks for the UPPER fix.
I have created the table using a clustered index with 50 rows
--
SELECT TOP 50 IDENTITY(INT,1,1) AS N
INTO dbo.Tally
FROM Master.dbo.SysColumns
ALTER TABLE dbo.Tally ...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 6, 2012 at 2:08 pm

#1470277
RE: CLR Integration in SQL

binak_86 (4/5/2012)
@jeff Moden
How can I do validations of email address through T-SQL?
I'm on my way to work so can't provide much detail just now. I'll do that tonight after...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 6, 2012 at 6:29 am

#1470059
RE: Query Performance - Table Temporary

Charles Hearn (4/5/2012)
Since you have indexes on your temp table, the results from your select need to be sorted according to the index. That sort operation is the "cost...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 5, 2012 at 6:51 pm

#1469934
RE: How reliable execuion plan estimates are!!

S_Kumar_S (4/5/2012)
Hi
I have a proc with 3 sql statements. Executing this proc takes around 5 minutes. The plan shows that one of select statement takes 99% relative to batch. This...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 5, 2012 at 6:48 pm

#1469933
RE: Shredding with XQuery to Parent, Child, Grandchild tables

I guess that I'm still amazed that such a simple structure requires 3 selects to return the hierarchy.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 5, 2012 at 6:28 pm

#1469929
RE: Why so fast .. or is it, why so slow?

A super simple answer as to "why" the index on the deleted table made such a difference is that because a correlated subquery with an equality predicate will be translated...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 5, 2012 at 6:20 pm

#1469928

Viewing 15 posts - 30,436 through 30,450 (of 59,101 total)