Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,546 through 4,560 (of 59,087 total)

Reply To: How to calculate Monthly aggregates from daily data

If you look at the previous code, 90% of the answer is in the first CTE. All you have to do to that is add some of the original columns...
--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)

October 2, 2021 at 7:49 pm

#3935909
Reply To: Are the posted questions getting worse?

Paul White wrote:
Jeff, I'm not about points (I give most of mine away) or "3 pointing stripes", whatever that means. Somewhat like yous here, I donate my time to help people...
--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)

October 2, 2021 at 6:44 pm

#3935904
Reply To: View or Stored Procedure?

A possible alternative to all that is maybe it should be in an iTVF (inline Table Valued Function) so that it can be called by multiple procs and still 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)

October 2, 2021 at 6:30 pm

#3935899
Reply To: How to start an Index Review Project

Lou wrote:
Current index inventory
Current index usage
New indexes recommendations
What do you think should I add ?
NOTE: Edited to clarify what can be automated and what requires "human judgement".
And I give up...
--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)

October 2, 2021 at 6:16 pm

#3935897
Reply To: What Do You Want to Know Before Negotiating Salary?

I think that a couple of better questions to ask your self is do you like your current job and are you happy with how much you're making?
I've also seen...
--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)

October 2, 2021 at 5:22 am

#3935771
Reply To: Are the posted questions getting worse?

ZZartin wrote:
I had someone ask me how many a couple was this morning, it was just one of those weird moments where I assumed that was just standard knowledge but...
--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)

October 1, 2021 at 4:36 am

#3935326
Reply To: Implicit conversion from datetime to datetime2

Alessandro Mortola wrote:
I agree with you Jeff and with your "ERROR in ACCURACY" definition 🙂
I have to thank you for the question! It's also ironic that I actually had to do...
--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)

October 1, 2021 at 4:34 am

#3935325
Reply To: Using CONVERT(...)

To Grant's point, we can only guess about such a thing on a totally out-of-context snippet of code.
That, notwithstanding, I have the following comments on this...
First, since (in most cases...
--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)

September 30, 2021 at 5:10 pm

#3935167
Reply To: Adding a PRIMARY KEY CLUSTERED
Ah... two questions also come to mind.
1. How many bytes does the HEAP currently occupy?
2. How big is your TempDB in bytes?
Don't forget my question about SET IDENTITY_INSERT ON 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)
September 30, 2021 at 1:32 pm

#3935052
Reply To: Index design on large and "wide" tables

Grant Fritchey wrote:
Also, plans are not a measure of performance. They're a description of behavior. Be cautious about looking at them as a measurement stick.
+1000000! I will probably not hear more...
--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)

September 30, 2021 at 1:23 pm

#3935047
Reply To: OPENROWSET & BULK INSERT Skip First X Rows, Skip Last Y Rows

You can do something like the following link contains to "pre-process" a file. If you can use xp_CmdShell (it's NOT the security risk most will say it is if 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)

September 30, 2021 at 2:55 am

#3934879
Reply To: Results-To-Text , Programatically

homebrew01 wrote:
That might work if I can figure out how to get line breaks after each row.
CHR(10) should work as the "separator".
https://www.ibm.com/support/producthub/db2/docs/content/SSEPGG_11.5.0/com.ibm.db2.luw.sql.ref.doc/doc/r0000778.html?pos=2
--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)

September 30, 2021 at 1:53 am

#3934860
Reply To: Join together two Dynamic SQL variables

Jeffrey Williams wrote:
You should also not use SELECT to set the variable - use SET instead:
WHY? What do you base that recommendation on?
--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)

September 30, 2021 at 1:46 am

#3934859
Reply To: Need a script that lists all logins for entire server

Whomever is doing the security audit should have one of their own.
Also, please try Google on this question. You'll find lots of scripts.
--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)

September 30, 2021 at 1:14 am

#3934853
Reply To: How migrate on SQL database to AWS

And, before you move to RDS, consider this... IIRC, you won't be able to restore a single database in the future. Instead, you'll need to restore the entire instance. Actually,...
--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)

September 30, 2021 at 12:55 am

#3934850

Viewing 15 posts - 4,546 through 4,560 (of 59,087 total)