Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,026 through 20,040 (of 59,072 total)

RE: Query inside an IF statement runs forever

What's the execution plan without the IF statement look like?
--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 29, 2015 at 10:29 pm

#1815996
RE: get numeric values from this string

info 58414 (7/29/2015)
Hi,
why can i get the numeric values from this stiring?
{_cpn}=1743; {_cpnll}=4511
Result: 1743, 4511
Position and len of the value can be diffrent...
Thanks and Regards
Nicole
🙂
Will there only ever be 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)

July 29, 2015 at 10:06 pm

#1815995
RE: Alternate rows

sharonsql2013 (7/29/2015)
Came up with two separate queries one for last week and one for alternate weeks (%2) and did a Union. That helped
None of it will work if you're closer...
--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 29, 2015 at 10:04 pm

#1815994
RE: Is this SQL?

PHYData DBA (7/29/2015)
So this post is more Cathartic than a professional question.
I do want the input of anyone that would like to comment about the content of this post.
This is...
--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 29, 2015 at 9:41 pm

#1815992
RE: Improve running time of custom function

I got off work just about an hour ago (9PM) and I've been looking at this code and I have to admit a bit of confusion. I might just...
--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 29, 2015 at 8:24 pm

#1815989
RE: Improve running time of custom function

johnsql-193053 (7/29/2015)
Jeff Moden (7/29/2015)
Before I make any suggestions, I need to know two things, please.
1. How many rows are in the NetworkItem table?
2. How often does data change...
--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 29, 2015 at 3:30 pm

#1815953
RE: Improve running time of custom function

WayneS (7/29/2015)
One thing that I note here is that you are using a Multi-Statement Table-Valued Functions, and they consist of just inserting data into the (output) table variable to 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 29, 2015 at 12:25 pm

#1815846
RE: Improve running time of custom function

Before I make any suggestions, I need to know two things, please.
1. How many rows are in the NetworkItem table?
2. How often does data change in the NetworkItem...
--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 29, 2015 at 9:08 am

#1815762
RE: Are the posted questions getting worse?

Lynn Pettis (7/28/2015)
Okay, time for a Chicken Dentist 'cause I'm done trying to pull teeth on thread where someone thinks a loop is the only way to accomplish a one...
--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 29, 2015 at 8:00 am

#1815731
RE: Challenge - dynamically load any file

vj.one (7/29/2015)
Hi All,
I have done this before. The concept is simple, Load the flat file in ragged right format into a table with one filed having n/varchar(max).
Once its a table,...
--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 29, 2015 at 7:54 am

#1815724
RE: There Are Always Constraints

Eric M Russell (7/28/2015)
Jeff Moden (7/28/2015)
From the article:
...or spent a bit more money (or time), ...
One of my goals is to stop spending money on "shiny new objects" and "cure-all...
--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 28, 2015 at 3:39 pm

#1815571
RE: Select records start with %

thbaig (7/28/2015)
thank you Eirikur Eiriksson
Now that you know how it can be done, you should take the opportunity lookup "LIKE" in "Books Online" (the help system for SQL Server) 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)

July 28, 2015 at 11:18 am

#1815506
RE: There Are Always Constraints

From the article:
...or spent a bit more money (or time), ...
One of my goals is to stop spending money on "shiny new objects" and "cure-all snake oil products" that provide...
--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 28, 2015 at 11:15 am

#1815504
RE: Re-org option for index where pagelock is disabled

Sagar-636902 (7/28/2015)
I am looking for the better option, what is the best way to maintain the Re-org when allowpagelock=0. we have about several indexes which are less then 4m page...
--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 28, 2015 at 7:55 am

#1815421
RE: Is It Worth Writing Unit Tests?

MVDBA (7/27/2015)
I think what a lot of people have missed here is that sometimes you won't be the only person to touch that code.
you may write exceptional code the first...
--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 27, 2015 at 9:17 am

#1815163

Viewing 15 posts - 20,026 through 20,040 (of 59,072 total)