Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,501 through 34,515 (of 59,102 total)

RE: inline table valued function performance problem

Hi Marko,
Yep... I certainly understand and fully agree with the idea of trading in Cursors and While loops for something a lot more effecient. I just didn't understand why...
--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)

March 26, 2011 at 1:29 pm

#1303983
RE: How to summarise, listing on same line

My apologies. I lost track of this thread. I've been pretty busy.
If you could put the CREATE TABLE, data inserts, the code in question, and the expected results...
--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)

March 26, 2011 at 12:08 pm

#1303970
RE: Script to generate only constraints

Understood on the SQL Compare. Not sure I have anything simple to help. I know that generating all the tables en masse produces a script where FK's 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)

March 26, 2011 at 11:39 am

#1303966
RE: Searching Functions, Procedures and Tables

Craig Farrell (3/23/2011)
Jeff Moden (3/22/2011)
FredS-1001785 (3/21/2011)
The original problem I was trying to solve was that I wanted to make sure that I was dropping temporary tables after using them. ...
--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)

March 26, 2011 at 11:33 am

#1303965
RE: Are the posted questions getting worse?

Gianluca Sartori (3/25/2011)
GilaMonster (3/25/2011)
Koen Verbeeck (3/25/2011)
Maybe a blog post that Microsoft has purchased MySQL from Oracle and that it is integrating it with SQLServer.\
I like that....
Edit: The index maintenance suggestion...
--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)

March 26, 2011 at 11:06 am

#1303959
RE: Are the posted questions getting worse?

Koen Verbeeck (3/25/2011)
Maybe an article on why it is not necessary to maintain indexes. Who needs them right?
(but maybe again, someone picks this up not realizing it is a joke)
Oddly...
--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)

March 26, 2011 at 10:58 am

#1303957
RE: Are the posted questions getting worse?

Fal (3/25/2011)
GilaMonster (3/25/2011)
Gianluca Sartori (3/25/2011)
Couldn't resist....
AHHHHHHH!!!!! You beat me of a couple of seconds!!!
That's cause I cheated. Hit quote and post, then went back and added something meaningful. 😀
You know,...
--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)

March 26, 2011 at 10:34 am

#1303956
RE: inline table valued function performance problem

I have to ask, why are you segmenting on a fixed length instead of by the position of the delimiters? What is the purpose?
--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)

March 26, 2011 at 1:04 am

#1303934
RE: Stored Procedure inside a Trigger?

lukus_g (3/24/2011)
Which now works perfectly.
Try inserting more than one row in a single INSERT and see why that might not be true. 😉
--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)

March 25, 2011 at 5:50 pm

#1303909
RE: Capture procedure(s) results in table(s) dynamically

Have you tried INSERT/EXEC?
--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)

March 25, 2011 at 5:23 pm

#1303907
RE: Updating millions of records

SQLRO (3/24/2011)
Hello,
We have data processing team in our organization which needs to work with millions of records everyday. Now the number of records have reached 7.5 million and soon 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)

March 25, 2011 at 5:19 pm

#1303905
RE: Separate db copy for reporting

If you have a SAN, many SANs come with a method to almost instantly duplicate data on a reporting server.
--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)

March 25, 2011 at 5:00 pm

#1303903
RE: parameter for sub total

I thought SSRS had a "running total" function that could be used for such things.
--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)

March 25, 2011 at 4:46 pm

#1303901
RE: Running Total using Quirky Update problem storing previous row values

GSquared (3/25/2011)
Honestly, for sequential code like this and other running totals problems, I avoid the quirky update and use CLR assemblies, or a Static or Fast Forward cursor. Those...
--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)

March 25, 2011 at 1:24 pm

#1303855
RE: Are the posted questions getting worse?

Crap... looks like the thread is going to beat me to the 25,000 number.
--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)

March 24, 2011 at 10:23 pm

#1303348

Viewing 15 posts - 34,501 through 34,515 (of 59,102 total)