Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,056 through 20,070 (of 59,098 total)

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
RE: Investigating Slow Restore Process

There are several things that pop into my mind.
1. If the database backup isn't a compressed backup, then you have some serious file size and freespace issues if the...
--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 26, 2015 at 11:28 pm

#1815035
RE: how to create alter for cup ultilization

Actually, it's not something easily done from SQL Server and probably should not be. It should be done from Windows. Here's a link about setting up such alerts...
--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 26, 2015 at 10:51 pm

#1815034
RE: Query for LastYear same Month

yayan.m (7/26/2015)
Please advice.
We're only guessing here because we don't actually have your data. It's time for you to read and heed the article at the first link in my...
--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 26, 2015 at 1:44 pm

#1815017
RE: Help with joining two tables

J Livingston SQL (7/26/2015)
Jeff...as usual you have provided an informative analysis for the OP to consider.
Far more eloquent, patient and concise than my initial reaction and potential post this morning...
--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 26, 2015 at 1:16 pm

#1815016

Viewing 15 posts - 20,056 through 20,070 (of 59,098 total)