Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,736 through 12,750 (of 59,102 total)

RE: Where do I get useful datasets?

Rod at work - Tuesday, March 13, 2018 3:54 PM
I remember that Steve Jones posted an article, maybe 2 years ago, in...
--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 13, 2018 at 6:59 pm

#1983073
RE: Combine 2 numeric fields to a DATETIME field

I remember seeing an example by Peter "Peso" Larsson a long time ago, adopted his method, and tweaked it a bit. Here's an iTVF that will do it for 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)

March 13, 2018 at 6:39 pm

#1983071
RE: Migrating only database structure having lakhs of objects

I know it's not helpful but having "lakhs" of database objects usually means that there's a pretty bad database and application design going on even if it's spread across several...
--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 13, 2018 at 6:28 pm

#1983070
RE: Ginormous Production Log File - Help!

Seggerman-675349 - Tuesday, March 13, 2018 1:16 PM
update - my client worked with a DBA (the real deal) at Liquid Web, 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)

March 13, 2018 at 6:24 pm

#1983069
RE: Links in forum posts

Steve Jones - SSC Editor - Tuesday, March 13, 2018 3:26 PM
Ed Wagner - Tuesday, March 13,...
--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 13, 2018 at 4:34 pm

#1983061
RE: Performance increase when qualifying join types

cmartel 20772 - Monday, March 12, 2018 1:05 PM
I have a simple case where I retrieve data using an inline table-valued function,...
--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 13, 2018 at 12:38 pm

#1983040
RE: What is faster? Creating calculated field within table or creating calculated fields within query?

Without doing a deep read on the other responses, if a calculation is deterministic, then adding a PERSISTED computed column on a table will cause the answer to be calculated...
--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 13, 2018 at 12:35 pm

#1983037
RE: Links in forum posts

Steve Jones - SSC Editor - Tuesday, March 13, 2018 8:36 AM
Jeff Moden - Tuesday, March 13,...
--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 13, 2018 at 11:38 am

#1983003
RE: Links in forum posts

Steve Jones - SSC Editor - Tuesday, March 13, 2018 8:12 AM
I've had the issue. If you make the link the last...
--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 13, 2018 at 8:26 am

#1982945
RE: how to take DataBase Backup from remote server to local system

mail4olek - Tuesday, March 13, 2018 7:35 AM
To perform remote backups isn't a reliable backup method...
Not sure what you mean there. While...
--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 13, 2018 at 8:19 am

#1982937
RE: Links in forum posts

Sean Lange - Tuesday, March 13, 2018 7:31 AM
I seem to continuously have major problems when posting a response in the forum...
--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 13, 2018 at 8:12 am

#1982933
RE: Intervals Part 1 - Definitions and Terms

Jeff Moden - Monday, March 12, 2018 8:08 AM
With respect to the "Desired Month" interval in the following diagram (don't confuse with...
--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 12, 2018 at 8:30 pm

#1982849
RE: Please write a query to get my desired output

rbaddamsql - Friday, March 9, 2018 7:48 PM
I have 3 people with 3 items each. I want to select 1item from each...
--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 12, 2018 at 6:18 pm

#1982848
RE: Please write a query to get my desired output

Sounds like an interview question or a school question.
--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 12, 2018 at 4:53 pm

#1982844
RE: Extremely slow SQL server

You've got some pretty nasty problems. First, your transaction log file is 2 and 1/2 times bigger than the data fill. That probably means that the log file isn't 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)

March 12, 2018 at 11:14 am

#1982800

Viewing 15 posts - 12,736 through 12,750 (of 59,102 total)