Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,591 through 7,605 (of 59,072 total)

Reply To: Find Unused Store Porcedures

Sure... just like I said over on SQLTeam.com...
To be honest, there is no completely reliable method to ensure that you don't delete stored procedures that are being used.. Consider the...
--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)

March 9, 2020 at 2:51 pm

#3732506
Reply To: The Panjandrum Conundrum

Considering that it took almost 3 decades for them to get their fingers out of their ears on a true CSV format, I'll say "good luck with that submittal" David.
--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)

March 9, 2020 at 2:47 pm

#3732505
Reply To: The Developer Arguments for Stored Procedures

MVDBA (Mike Vessey) wrote:
wait until you get an application that wants to create sql agent jobs and then delete them after. not a hope in hell stopping that process running as SA
we...
--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)

March 9, 2020 at 2:19 pm

#3732501
Reply To: can I kill a spid executing a delete or update or insert statement

892717952 wrote:
Dear Jeff,
Thank you for kind help!
I quite agree with you!
my said procedure, I just want to verify how the transaction(rollback) works on the said scripts, actually, when the 1st...
--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)

March 9, 2020 at 2:10 pm

#3732499
Reply To: Could you list db modeling tools you use on daily basis?

Don't get me wrong. I totally agree with you on big stuff about pencil and paper not being the way to go. My point was meant to be that no...
--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)

March 9, 2020 at 2:04 pm

#3732497
Reply To: Compat Level change and Impact on Query Performance

sqlguy80 wrote:
Thank you for the response, but need explanation for this problem / solution.
CPU looked ok on the VM ( ~ 30% ) . but view was opening ok till...
--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)

March 8, 2020 at 3:53 pm

#3732295
Reply To: Inserting large data volumes into a table as fast as possible

p.s. With regard to the original question of...
I'm doing development on large SCD2 tables (100M+ rows). When I've fixed bugs and it's time to re-run, I need to restore the...
--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)

March 8, 2020 at 3:50 pm

#3732294
Reply To: can I kill a spid executing a delete or update or insert statement

Correct. But, be really careful about killing SPIDs... kill the wrong one and your server server could serve as a boat anchor for hours. You should also plan on finding...
--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)

March 8, 2020 at 2:45 pm

#3732286
Reply To: Every Named Calculation makes error!

I can't help you with your Visual Studio problem because I don't use it. I can tell you, though, that your formula for age in years is incorrect simply because...
--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)

March 7, 2020 at 3:45 pm

#3732171
Reply To: Restoring file group from one database to another

Siten0308 wrote:
... but I am wondering if I can apply the filegroup backup from one database to another, specifically restoring only a particular filegroup of the database...
To the best of...
--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)

March 7, 2020 at 3:15 pm

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

Thanks for the feedback, Greg. I totally agree... this site has been a staple of knowledge for me, as well. I don't believe that I'd have been able 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)

March 7, 2020 at 3:04 pm

#3732168
Reply To: The Developer Arguments for Stored Procedures

I guess my only exception to what Rick stated above is that business logic is frequently better done on the database side of the house. FKs, Defaults, Checks, and 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)

March 7, 2020 at 2:41 pm

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

Greg Edwards-268690 wrote:
Same problem, but someone with a completely different perspective came up with very different solution. Maybe part of it was I was a database guy, and only had 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)

March 7, 2020 at 1:46 pm

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

Michael L John wrote:
Jeff Moden wrote:
Michael L John wrote:
They are not even Excel jockeys. One of them has a LAW degree. she just passed her bar exam and is not going into law. The rest...
--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)

March 7, 2020 at 2:02 am

#3732090
Reply To: Find Unused Store Porcedures

Cache is also temporary... very temporary. Dropping procs based on what is in cache is a sure fire way to need to resurrect your resume and sharpen it up. Seriously......
--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)

March 7, 2020 at 1:53 am

#3732089

Viewing 15 posts - 7,591 through 7,605 (of 59,072 total)