Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,341 through 8,355 (of 59,098 total)

Reply To: Turn If statement into Case

I have to ask... what are you pasting the code from?
--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 20, 2019 at 2:50 am

#3699078
Reply To: Running Totals by Date and Account

Jonathan AC Roberts wrote:
Jeff Moden wrote:
I do have a way to avoid that problem that will blow the doors off of most other methods for calculating running totals but it does take 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)

November 20, 2019 at 2:48 am

#3699074
Reply To: Hidden RBAR: Triangular Joins

Cody Konior wrote:
I'm 7 years late but that last bit of sample code is referencing a non-existent field SomeVal instead of RowNum created in the table just prior 🙂
Heh... and I'm...
--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 19, 2019 at 7:45 pm

#3698968
Reply To: Running Totals by Date and Account

pgainer wrote:
Jonathan, Drew and ZZartin,
Wow, that was fast!
Thank you very much. The 2nd method provides me with what I need.
Phil...
Be careful here. It looks to me that the CROSS APPLY...
--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 19, 2019 at 7:31 pm

#3698965
Reply To: I am new to SQL world

Just remember that the YYYY-MM-DD formats aren't actually followed as ISO in SQL Server even though it is a valid ISO format. For example, if you set the language =...
--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 19, 2019 at 7:20 pm

#3698962
Reply To: Replace TABLE with STAGING_TABLE. Approach?

JJR333 wrote:
Thanks Scott. Will look into this.
J.
If you used a synonym instead of a view, it would be even easier because you could read what it was pointing at from...
--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 19, 2019 at 7:17 pm

#3698961
Reply To: Why no posts?

Awesome! I think you're the first person I've talked to that's actually using it for something that I think it's useful for. As soon as you said that you work...
--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 19, 2019 at 7:07 pm

#3698956
Reply To: Maintenance Window for SQL Server Critical Alerts

Heh... I just let the alerts fly... it's a great monthly test/confirmation for the alerts and the jobs that some of them run. The auditors love it because it shows...
--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 19, 2019 at 2:45 pm

#3698838
Reply To: Trigger store procedure with a file in SQL Server

You allow an app to write files to your SQL Server? I don't allow that. It have people write their files to a different box and then give SQL Server...
--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 19, 2019 at 2:39 pm

#3698835
Reply To: Why no posts?

xsevensinzx wrote:
I've been highly inactive for like a year it seems, but here is my input.
I am still 100% invested in Azure Data Warehouse and Azure Data Lake Store 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 19, 2019 at 2:33 pm

#3698833
Reply To: missing storage space

Uh... I just noticed... the first script doesn't even report sizes... so I'm confused as to what you found the problem to actually 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)

November 19, 2019 at 2:26 pm

#3698828
Reply To: missing storage space

Just to confirm... Are you saying that the first script reported 155GB and that was what was incorrect?
--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 19, 2019 at 2:23 pm

#3698826
Reply To: Replace TABLE with STAGING_TABLE. Approach?

So, just to be sure, you're not going to use the code in the "All seems to be working now" post above?
--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 19, 2019 at 2:15 pm

#3698825
Reply To: It Just Works

call.copse wrote:
I've developed SQL backed Access front end databases that work with 40 odd users that have been going for many, many years and perform their function very reliably. It's...
--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 19, 2019 at 1:20 pm

#3698804
Reply To: It Just Works

sean redmond wrote:
For small operations, that is, fewer than 5 people using it concurrently, Access (or FileMaker Pro) is excellent. It's relatively cheap and easy for someone with some experience to...
--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 19, 2019 at 1:13 pm

#3698802

Viewing 15 posts - 8,341 through 8,355 (of 59,098 total)