Jeff Moden

Forum Replies Created

Viewing 15 posts - 26,461 through 26,475 (of 59,099 total)

RE: Using a Recursive CTE to Generate a List

smarinova (7/9/2013)
Thank you 🙂 ! I will definitely try FOR XML PATH. I came up with the recursive CTE solution after reading about another application of recursive CTEs, but perhaps...
--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)

July 9, 2013 at 5:22 pm

#1631030
RE: Using a Recursive CTE to Generate a List

izhar-azati (7/9/2013)
Why not to use CLR aggregate function that you can download from:
http://msftengprodsamples.codeplex.com/wikipage?title=SS2008%21String%20Split%20Table-Valued%20Function%20%28TVF%29&referringTitle=Home
Izhar Azati
Mostly because I'm not going to download and install a .msi file from the internet from an...
--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)

July 9, 2013 at 5:15 pm

#1631029
RE: Order of rows in a Table with Identity Column.

dwain.c (7/8/2013)
Excuse me for asking a dumb question here but the OP says the TransactionID is the primary key with presumably a clustered index on it (my assumption).
In that case,...
--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)

July 9, 2013 at 7:44 am

#1630800
RE: Is this syntax guaranteed to continue working?

Adi Cohn-120898 (7/8/2013)
Hi all
Pleas check out the code bellow:
declare @tbl table (i int)
declare @i int
insert into @tbl (i) values (1)
update @tbl
set @i = i, i = 2
select @i as varible,...
--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)

July 8, 2013 at 2:39 pm

#1630589
RE: Are the posted questions getting worse?

L' Eomot Inversé (7/7/2013)
jasona.work (7/5/2013)
Koen Verbeeck (7/5/2013)
jasona.work (7/5/2013)
You *KNOW* it's going to be a slow day when you get in at your normal time, and get front-row parking...
I could've driven...
--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)

July 8, 2013 at 12:37 pm

#1630548
RE: Effect of Clustered Index on Non-Clustered Index

GilaMonster (7/6/2013)
Jeff Moden (7/6/2013)
If there is no unique clustered index, then an 8 byte "uniquefier" is also added to the index.
Not quite
If there's no clustered index, the 8-byte RID...
--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)

July 6, 2013 at 11:12 pm

#1630260
RE: A New Look

I agree with the others... it's way too skinny (about 1/3 the width of any of my screens) and it causes way too much scrolling.
I have to admit that I...
--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)

July 6, 2013 at 11:34 am

#1630235
RE: Can a strawberry query be done better?

GilaMonster (7/6/2013)
Jeff Moden (7/6/2013)
For example, here's a classic case of why many people come to the erroneous conclusion that a recursive CTE that counts is lightning fast compared to many...
--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)

July 6, 2013 at 10:57 am

#1630234
RE: Effect of Clustered Index on Non-Clustered Index

Sean Grebey (7/2/2013)
Sure I understand that indexes are against tables. And I understand the difference between clustered and non-clustered indexes. My question is will non-clustered indexes perform better if there...
--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)

July 6, 2013 at 10:28 am

#1630232
RE: Can a strawberry query be done better?

Banana-823045 (7/6/2013)
Thanks. I had the impression that one should use execution plan to get an idea of how well it'll perform for different applications whereas timing the result would be...
--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)

July 6, 2013 at 9:39 am

#1630230
RE: How to Add a Date randomly

dwain.c (7/6/2013)
Jeff Moden (7/5/2013)
dwain.c (7/4/2013)
What in Buddha's name is a "lac day?"
"lac" is 100,000 in the OP's language.
Oh, I get it! It can be used like a productivity measure:
SLOC/lac-days
😛
--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)

July 6, 2013 at 8:37 am

#1630229
RE: How Stored Procedure determine to return a value?

masoudk1990 (7/5/2013)
Thank you very much.
I changed my Stored Procedure to this:
DECLARE @MyString NVARCHAR(3);
SELECT CASE
WHEN 1 = 1
...
--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)

July 5, 2013 at 5:52 pm

#1630204
RE: Data in date column to decrement with one

asifejaz (7/4/2013)
thanks for your quick response. really appreciate that.
This will solve it but urpose is not achieved. i am using a cursor to fetch records with combination of primary...
--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)

July 5, 2013 at 5:39 pm

#1630203
RE: I want create baseline for sql server

sqldbaonly (7/5/2013)
hi,
Tell different tricks and fusible ways ?
For T-SQL...
Tally Table, Pseudo-Cursors, "Set-based" thinking, SARGable queries, "Divide'n'Conquer" techniques, Windowing Functions, Cascading CTEs and Cross Apply's, deep understanding of B-Tree indexing,...
--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)

July 5, 2013 at 5:35 pm

#1630201
RE: Add Variable to integer

sharonsql2013 (7/5/2013)
Hi
I declared the primary key as identity int.
Now everytime a value(code) is selected from the grid , I want a corresponding character to be concatenated to the primary...
--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)

July 5, 2013 at 4:52 pm

#1630199

Viewing 15 posts - 26,461 through 26,475 (of 59,099 total)