Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,176 through 8,190 (of 59,098 total)

Reply To: SQL Server Name Convention and T-SQL Programming Style

I hate the way this site does NOT handle tables. I have a screen wide enough to display the whole table but it's still formatted super narrow so someone can...
--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 10, 2019 at 10:25 am

#3706404
Reply To: Stored Procedure Documentation

Neil Burton wrote:
Jeff Moden wrote:
jonas.gunnarsson 52434 wrote:
As in most development the code should speak for it self, and you should use:
Source control (containing change documentation)
Formatting tool/formatting rules
Good and describing naming rules
Your procedure should...
--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 10, 2019 at 10:04 am

#3706300
Reply To: sqlcmd - Unable to pass in exact file path as an input variable to :out

Steve,
Will that actually work in a stored procedure? I'm thinking "not" and that it could only work from a "routine" (if you understand the difference) but I could be wrong.
--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 10, 2019 at 9:38 am

#3706288
Reply To: Query tuning help

vsamantha35 wrote:
We are small shop and we don't get to hire any dedicated consultant for performance tuning. Everything has to be done by us!
Thanks everyone. Forgive me if I...
--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 10, 2019 at 9:28 am

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

MVDBA (Mike Vessey) wrote:
one of the things i'm constantly told,... keep it to 2 pages
I was always told to do the same... until they saw the format and the content. Lynn has...
--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 10, 2019 at 12:44 am

#3706162
Reply To: Stored Procedure Documentation
jonas.gunnarsson 52434 wrote:
As in most development the code should speak for it self, and you should use:
- Source control (containing change documentation)
- Formatting tool/formatting rules
--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 9, 2019 at 9:53 pm

#3706121
Reply To: Query runs for days when upgrading to 2017

askcoffman wrote:
Thanks Jeff and John for the help. I ended up rewriting the vw_pos_period_dim as a materialized view. Still not sure why that worked since the view itself performed well,...
--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 7, 2019 at 9:36 pm

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

On the subject of questions getting worse, here's what it has finally come to. Notice in the zip file that there is absolutely everything that one might need to get...
--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 7, 2019 at 9:31 pm

#3705701
Reply To: Find how many week day crossed in a given date

jcelko212 32090 wrote:
In your case, I would use the ISO-8601 week-date format. You can downoad such a calendar from the internet. The format is yyyyW[0-5][0-9]-[1-7] where the week is 01-53, depending...
--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 7, 2019 at 9:08 pm

#3705694
Reply To: Query tuning help

Sam,
Rewriting to use ANSI Joins instead of older Equi-Joins isn't going to fix it nor the apparent total absence of any indexes to support the code. Returning more than 600...
--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 7, 2019 at 7:32 pm

#3705689
Reply To: Creation of CI is taking more time

vsamantha35 wrote:
Hi All,
We are trying to creating a clustered idx on a HEAP. It is almost 45 mins, its still running. Heap is around ~400 GB. Is it expected ?...
--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 7, 2019 at 6:53 pm

#3705687
Reply To: Records will 0 Balance are also shown

Be REALLY careful with the code posted so far (all of it... the original post and all coded answers). It contains a Triangular Join and that's a huge drain 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)

December 7, 2019 at 6:31 pm

#3705686
Reply To: Find how many week day crossed in a given date
Jonathan AC Roberts wrote:
Rock wrote:
Team
I have a scenario in SQL Query. If I Give a day, The output should say which day and how many days crossed in a given month
For Ex
--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 7, 2019 at 3:10 am

#3705614
Reply To: Find how many week day crossed in a given date
schleep wrote:
DECLARE @dDate DATE = '11 Dec 2019'
SELECT DATENAME(DW, @dDate), (DAY(@dDate) / 7) + 1
Try the date of '7 Dec 2019' and see that it comes 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)
December 7, 2019 at 3:04 am

#3705613
Reply To: Find how many week day crossed in a given date
Rock wrote:
Team
I have a scenario in SQL Query. If I Give a day, The output should say which day and how many days crossed in a given month
For Ex
--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 7, 2019 at 2:45 am

#3705612

Viewing 15 posts - 8,176 through 8,190 (of 59,098 total)