Jeff Moden

Forum Replies Created

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

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
Reply To: How Do You Act When You Need to Learn New Technology?

MVDBA (Mike Vessey) wrote:
I've tried getting service broker, hierarchyid, graph and many other things... nobody wants to step out of their comfort zones.
What did you want folks to use HierarchyID and Graph...
--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 9:25 pm

#3701670
Reply To: How to backup the Xmldata table in sql server 2016

polo.csit wrote:
Database is full recovery model.when copy the table in single table also take time more and copy of the table is INTO statement.
We keep going in circles. I already...
--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 3:32 pm

#3701582
Reply To: SQL Cursor Trouble

To the best of my recollection (yeah, I was working with unit record equipment and computers way back then), the only "NULL" value on punch cards was to simply not...
--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 3:16 pm

#3701575
Reply To: Need to find out what combination of columns makes each record in table unique

It's difficult for me to believe that such a table exists and no one knows anything about it. Find who does and ask 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)

November 27, 2019 at 2:10 pm

#3701541

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