Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,136 through 9,150 (of 59,091 total)

Reply To: Partition Corruption Impact on whole db

So... enquiring minds want to know... did the link help you or not?
--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 18, 2019 at 4:38 am

#3654623
Reply To: Looking for Step by Step Instructions for SQL Server Loop using Powershell

sunshine-587009 wrote:
Hi! I'm no really sure I am doing this correctly. I am not running anything by database and already have an existing table. The first one attached is what...
--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 18, 2019 at 4:32 am

#3654621
Reply To: Notification of zero records in a table

Budd wrote:
There is a JAVA app that clears and reloads a staging table, but occasionally it fails to reload. So I am trying to figure out a way that will...
--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 18, 2019 at 4:30 am

#3654620
Reply To: Slower is Faster

MVDBA (Mike Vessey) wrote:
while it's slightly off topic, I worked with a team that mixed the V model (kinda like waterfall) and agile.. it had an unfortunate nickname of "vagile"
What did...
--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 18, 2019 at 4:25 am

#3654619
Reply To: How to find a set of sequential values within a list
If you're not using at least SQL Server 2012, the feature/syntax doesn't exist prior to that. You say you're using v17 but what is that for? SSMS? That's not what...
- This reply was modified 7 years, 2 months ago by Jeff Moden.
--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 18, 2019 at 4:15 am

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

dallas13 wrote:
Mya be you have some different collation or timezone setting. Here is what I am getting. 6/14/2019 5:00:00 PM
My recommendation would be to rewrite it so that it does...
--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 4:16 pm

#3654497
Reply To: How Do I resolve SSMS 'is busy" issue
five_ten_fiftyfold wrote:
So I come across this thread nine years and several iterations of SSMS after the event, totally fed up with having to restart SSMS repeatedly, often losing work along...
- This reply was modified 7 years, 2 months ago by Jeff Moden.
--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 2:10 pm

#3654442
Reply To: Watching Out for Deferred Name Resolution

Bryant McClellan wrote:
Perhaps for the same reason jackrabbits run in front of cars?
Heh... and squirrels. 😀
--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 1:37 pm

#3654435
Reply To: Powershell script to get the local adminstrators liston multiple windows servers

To answer the logically next expected question...
https://www.google.com/search?&q=save+powershell+output+to+table+in+sql+server
Of course, I don't have a code example for this because I don't use PowerShell to do such things, especially since the list...
--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 1:12 pm

#3654429
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, 2 months ago by Jeff Moden. Reason: Trying to correct some of the coloring mistakes caused by the forum software
- This reply was modified 7 years, 2 months 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, 2 months 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

Viewing 15 posts - 9,136 through 9,150 (of 59,091 total)