Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,121 through 9,135 (of 59,067 total)

Reply To: Temporary data and Differential Backup size

Heh... perhaps the next article should be about the delays of ghost row cleanups. 😀
--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)

June 17, 2019 at 12:31 pm

#3654413
Reply To: Watching Out for Deferred Name Resolution

I'll never understand why some people write 100's of lines of code without testing the code before turning it into a stored procedure or whatever and wether or not there...
--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)

June 17, 2019 at 12:14 pm

#3654391
Reply To: Maintenance plan was not deleting the files

I'm going to suggest that you DON'T make such an over-arching delete system. There may be a need for different instances/systems to do the deletes of old backup files 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)

June 17, 2019 at 12:17 am

#3654317
Reply To: Add working days but avoid holidays

p.s. Since the forum software still provides no easy method back to the article being discussed, here's the link to the original script article, if anyone is interested.
https://www.sqlservercentral.com/scripts/add-working-days-but-avoid-holidays-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)

June 17, 2019 at 12:11 am

#3654316
Reply To: 15466 error when executing xp_cmdshell with non sysadmin user
Thought I'd throw my 2 cents in from a presentation I did nearly a decade ago and it still works to allow the secure operation of xp_CmdShell. Here's the full...
- This reply was modified 7 years ago by Jeff Moden. Reason: Trying to correct some of the coloring mistakes caused by the forum software
- This reply was modified 7 years ago by Jeff Moden. Reason: Still trying to the color corrections but have given up if it doesn't work. The code should copy correctly
- This reply was modified 7 years ago by Jeff Moden. Reason: Heh... backslash followed by a single quote seems to escape the single quote. Should be good to go color-wise now
--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)
June 16, 2019 at 11:40 pm

#3654308
Reply To: Calculate last friday date with timestamp ssis

Jeffrey Williams wrote:
It also depends on what the package is doing...and whether or not I have to connect to SQL Server for other configuration values.
That same thought is usually the justification...
--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)

June 16, 2019 at 3:08 pm

#3654256
Reply To: Partition Corruption Impact on whole db

striker-baba wrote:
I would like to know if corruption/unavaialability of one partition would impact whole DB? Will I still be able to access rest of the partitions? Can I take one...
--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)

June 15, 2019 at 12:01 am

#3654029
Reply To: formatting T-SQL

Hmmph... additionally, the "Free" online version is limited to 100 lines of code. The non-free versions aren't expensive but, considering the bug I found above, I wouldn't spend a nickle...
--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)

June 14, 2019 at 11:51 pm

#3654028
Reply To: ISSUES TRYING TO JOIN CTE's

A lot of people make the mistake of thinking that a CTE is rendered as a separate object. Unless there is a "blocking operator" in the CTE, it's treated 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)

June 14, 2019 at 11:48 pm

#3654027
Reply To: LongPrint

Thanks for taking the time, Henrik. A lot of people will continue to be "stuck" in 2008 R2 for one reason or another and so I wanted to know what'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)

June 14, 2019 at 11:34 pm

#3654026
Reply To: If possible need a more elegant solution to a current brute force view

Thanks for taking the time to post back, Randy. Since you're one of the folks that needs to support it, do you know how it works?
--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)

June 14, 2019 at 11:30 pm

#3654023
Reply To: If possible need a more elegant solution to a current brute force view

Sorry... duplicate post removed.
--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)

June 14, 2019 at 11:29 pm

#3654022
Reply To: Calculate last friday date with timestamp ssis

Yowch. Thanks for the info, Phil.
--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)

June 14, 2019 at 11:14 pm

#3654021
Reply To: What causes a query to suddenly start performing poorly

Based on the fact that all execution plans are thrown away during a reboot or restart of the SQL Server Service and you said the server suffered a reboot or...
--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)

June 14, 2019 at 11:10 pm

#3654019
Reply To: Are these good and appropriate data types?

You first need to find out what the code that uses the table looks like. DW tables are NOT usually "proper normalized tables". For example, removing the "month" column or...
--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)

June 14, 2019 at 11:04 pm

#3654017

Viewing 15 posts - 9,121 through 9,135 (of 59,067 total)