Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,281 through 8,295 (of 59,102 total)

Reply To: Detai Master l Table

PLEASE don't duplicate posts. All does is split up the answers others make.
Please, no more answers on this thread folks. Instead, post them on the following thread.
https://www.sqlservercentral.com/forums/topic/master-and-detail-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)

December 1, 2019 at 2:52 pm

#3703272
Reply To: Transformed my query into a cursor

samirca007 wrote:
i have an application that creates sql tables that ends pat xxxxx_bulk and i must automated the synchronization process
Synchronization process? Why wouldn't "replication" work for you?
I've also found 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)

December 1, 2019 at 2:48 pm

#3703271
Reply To: Identity column as Primary Key - good or bad?

jcelko212 32090 wrote:
>> IDENTITY() is a piece of automation that solves a set of tricky problems for you. <<
Actually, IDENTITY creates problems rather than solve them. Essentially, you've decided to throw...
--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)

November 30, 2019 at 9:11 pm

#3702251
Reply To: How SQL Server Can Just Go Faster

While I agree that there have been some pretty cool successful attempts at making things "better" which, as you say, means "go faster", in this case, all is not without...
--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)

November 30, 2019 at 8:55 pm

#3702250
Reply To: Last Login Date and Time

sys.dm_exec_sessions has no "history". It only shows "active" sessions.

--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)

November 29, 2019 at 2:17 pm

#3702117
Reply To: Average across non-business days

DesNorton wrote:
Darnit Jeff
Where does you mind go to come up with such perlers?
Dark corner of the room, fetal position in a blanket, suck thumb, twiddle hair, beer popsicle, converse 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)

November 29, 2019 at 2:00 pm

#3702109
Reply To: Average across non-business days

barak wrote:
I will try it next week and see how it goes
Awesome. Thank you and looking forward to feedback. This could easily be turned into a high performance "iSF"...
--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)

November 29, 2019 at 1:51 pm

#3702107
Reply To: Average across non-business days

barak wrote:
jcelko212 32090 wrote:
Please learn the difference between a row and a record. It's very important for RDBMS.
I also wish you would learn to read the posting netiquette for this 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)

November 29, 2019 at 1:35 pm

#3702106
Reply To: Average across non-business days

Ok... here's the code to create and populate the test table. This is what Joe Celko was talking about. Please see the article at the first link in my signature...
--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)

November 29, 2019 at 3:46 am

#3702029
Reply To: Average across non-business days

barak wrote:
Hi all,
I need to calculate average rates across days. I do not have records for all days, but I need to consider the days without the rates as carrying...
--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)

November 29, 2019 at 1:38 am

#3702014
Reply To: Average across non-business days

MVDBA (Mike Vessey) wrote:
you need to use a table of dates (possibly a recursive CTE) and figure out how to put the last working day's value in to the table.
I think 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)

November 29, 2019 at 1:31 am

#3702013
Reply To: SQL Cursor Trouble

citj wrote:
Hello, i have a large set of data and i need to copy the Path ( folder) for every line, for example first path it's for one .mdb, 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)

November 28, 2019 at 10:12 pm

#3702004
Reply To: SQL Cursor Trouble
tripleAxe wrote:
Using LEAD instead of LAG.....
```
WITH FolderCTE AS
(
SELECT
LEAD(id, 1, null) OVER (ORDER BY id) [next_folder]
, id
, folder
FROM #sampledata 
WHERE folder is not null
)
SELECT 
sd.id
   ...
```
--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)
November 28, 2019 at 10:11 pm

#3702003
Reply To: Question about index

This actually sounds like a pretty cool interview question for anyone that claims to have "years of performance tuning expertise" on their resume.
First, I'd have to explain how 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)

November 28, 2019 at 9:49 pm

#3702002
Reply To: Oops, I deleted that data

thisisfutile wrote:
Hoo boy... This has the propensity to rival the robust rhetoric between bombastic blatherskites on bankers rounding or nulls.
Well, you placed this poetic perfection like a placard to polarize...
--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)

November 27, 2019 at 11:10 pm

#3701693

Viewing 15 posts - 8,281 through 8,295 (of 59,102 total)