Jeff Moden

Forum Replies Created

Viewing 15 posts - 33,631 through 33,645 (of 59,099 total)

RE: Are the posted questions getting worse?

Roy Ernest (6/16/2011)
Jeff, I am surprised that your session did not make the cut. I was looking forward to meeting you again. Darn.. Dont the MVPs get a special discount...
--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)

June 16, 2011 at 7:25 am

#1339678
RE: Select Tree and Order by from another table

You didn't read the entire post! 😉 I told you how to get that. Just remove the "*," from the 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)

June 16, 2011 at 7:18 am

#1339671
RE: Ussing Substring, Patindex, Charindex to extract data from a string

James Millar-305032 (6/15/2011)
Here is some more info on what I would expect to see in the relevant output data:
I have to extract data into separate fields for the CA1, CA2,...
--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)

June 15, 2011 at 11:40 pm

#1339468
RE: Execution plan generated but query is hung?

Just my 2 cents. I agree with Remi... the recompile will likely keep the hang from happening again.
--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)

June 15, 2011 at 11:31 pm

#1339464
RE: Performance slow down after stored proc called many times in loop

aracy (6/15/2011)
Okay. Thank you everyone for your replies. 🙂
You're right, if it was smooth sailing then I wouldn't be here.
I got it to preform well. My problem...
--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)

June 15, 2011 at 11:29 pm

#1339463
RE: Automation of Creating Trigger on All User Databases

If you just add it to the Model database, it'll be there for every new database you create. Make it a good one, though, because it will also appear...
--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)

June 15, 2011 at 11:19 pm

#1339461
RE: Select Tree and Order by from another table

Here you go... uses your original data and will, of course, handle additions such as subnodes on any other nodes including "B".
WITH
cteGetAllData (ChildID, ParentID, ChildName) AS
(
SELECT IdFolder,IdFolderParent,FolderName
...
--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)

June 15, 2011 at 11:12 pm

#1339459
RE: Select Tree and Order by from another table

nguyennd (6/15/2011)
ah, My customer make sure: no data like this:
A
--A1
----A1.1
--A2
----A2.2
------Item code = 3
------A2.2.1
--------Item code = 1
--A3
B
--Item code = 2
C
Every data input are reasonable.
That data doesn't match the original data you...
--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)

June 15, 2011 at 11:04 pm

#1339455
RE: Select Tree and Order by from another table

On second thought, I'd better ask... is the order of the hierarchy based on the number of subnodes that each level 2 node has under it?
--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)

June 15, 2011 at 10:52 pm

#1339452
RE: Select Tree and Order by from another table

Post the code you've written to do the first export you talked about and we'll show you how to modify it to do what you want.
--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)

June 15, 2011 at 10:29 pm

#1339445
RE: CHARINDEX doesn't find double spaces

Hi Grant,
I know your code is for a one-off test so performance may not matter, but I thought I'd show you a way to get rid of the While loop...
--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)

June 15, 2011 at 10:23 pm

#1339444
RE: Need T-SQL Query to separate words with spaces between them

Rich Yarger (6/15/2011)
So - here is a small sampling for you to see. What would you do?
Heh... hunt the people responsible for this data travesty down and take them out...
--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)

June 15, 2011 at 10:06 pm

#1339442
RE: Phrases that Resonate

Got a phrase that you use to share a difficult concept?
As a matter of fact, I do... [font="Arial Black"]RBAR[/font] 😉
--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)

June 15, 2011 at 10:00 pm

#1339441
RE: Are the posted questions getting worse?

SQLRNNR (6/15/2011)
Jeff Moden (6/15/2011)
The regular and half day session lists for PASS came out today. I didn't make the cut this time. I'll probably have to turn down...
--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)

June 15, 2011 at 9:37 pm

#1339437
RE: SQL Database development Questions

simon.mendoza (6/3/2011)
I know that this topic is now slightly old, but I'd like to warn potential candidates looking at this thread that I set this test, so I know when...
--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)

June 15, 2011 at 9:31 pm

#1339436

Viewing 15 posts - 33,631 through 33,645 (of 59,099 total)