Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,731 through 5,745 (of 59,101 total)

Reply To: Counting the number of unique days between ranges of dates
SwePeso wrote:
Assuming "dates" could only be a number between 1 and 31...
```
DECLARE @UnitMembership 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)
February 3, 2021 at 5:44 pm

#3840623
Reply To: Counting the number of unique days between ranges of dates

Gosh... I think I've gone brain dead a bit. I've tried a couple of things and can't just now remember how to do this with either an inline Tally cte...
--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)

February 3, 2021 at 5:18 pm

#3840620
Reply To: Counting the number of unique days between ranges of dates

ScottPletcher wrote:
Jeff Moden wrote:
ScottPletcher wrote:
I would think this would be the most straightforward way, although it may not be the most efficient way. But it might work just fine 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)

February 3, 2021 at 4:10 pm

#3840576
Reply To: Counting the number of unique days between ranges of dates

DesNorton wrote:
This will solve the data as you have provided it.
However, what happens when you have multiple overlapping units?
Man, you were really close and it was starting to 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)

February 3, 2021 at 4:11 am

#3840373
Reply To: Counting the number of unique days between ranges of dates

ScottPletcher wrote:
I would think this would be the most straightforward way, although it may not be the most efficient way. But it might work just fine for you if your...
--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)

February 3, 2021 at 1:03 am

#3840339
Reply To: How to Restore an Agent Job that was Dropped

Good article and thank you for taking the time to write and publish it.
As a bit of a sidebar, though, I just go to "Source Control" and grab a copy...
--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)

February 3, 2021 at 12:50 am

#3840337
Reply To: Artist or Scientist?

As Yogi Berra is quoted as saying, "When you come to a fork in the road, take it". There is absolutely no reason why you can't build "the art" into...
--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)

February 3, 2021 at 12:17 am

#3840330
Reply To: SQL isnt SQL

datascientist7 wrote:
And it's more than data analysts. So this is worthy of a larger discussion of what is and what is not of interest to this group. Let's scope it.
Heh......
--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)

February 2, 2021 at 7:24 pm

#3840242
Reply To: Save results from Stored procedure to a CSV file.

@stevenb,
I like it... a LOT! Nicely done!
--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)

February 2, 2021 at 2:32 am

#3839928
Reply To: SQL isnt SQL

Heh... you need better DBAs. To be honest, though, I feel your pain. The DBAs I've had to work with in the past made sucking sounds in the areas 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)

February 2, 2021 at 1:59 am

#3839921
Reply To: Execute As not reading system view

Correct me if I'm wrong, please... [Paleo-Server\SQLServerZaloha] is the instance name, correct? That's not a login.
If, like most people do, the owner of the databases is the disabled "sa" user,...
--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)

February 1, 2021 at 11:26 pm

#3839878
Reply To: PagedMemorySize of Sql Server

IIRC, PagedMemorySize is how much room there is in the "page file". If you overrun memory, applications will start to swap stuff in and out of the page file as...
--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)

February 1, 2021 at 11:21 pm

#3839877
Reply To: PLE is low most of time!

Glenn Barry has a cool set of diagnostic scripts by SQL Server Edition at the following URL...
https://www.sqlskills.com/blogs/glenn/category/dmv-queries/
Since you posted on a 2017 forum, you should find his 2017 version...
--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)

February 1, 2021 at 11:10 pm

#3839875
Reply To: SQL isnt SQL

SQL does serve the business. Not always so for IT, especially the one's that are saying "NO" to Statisticians and others without providing help. I get they don't want a...
--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)

February 1, 2021 at 10:20 pm

#3839850
Reply To: Bring back in person SQLSaturday where legal

In-person events require a venue, which must be reserved months ahead of time. What is currently "legal" now could be deemed by the local government as "ill-legal" at the drop...
--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)

February 1, 2021 at 7:44 pm

#3839796

Viewing 15 posts - 5,731 through 5,745 (of 59,101 total)