Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,606 through 7,620 (of 59,091 total)

Reply To: Generate Index only Script for Whole db

Admingod wrote:
Thanks! Would this work for whole db rather than individual table? How about Primary keys and clustered index?
You've got to be really careful about disabling any PK or UNIQUE...
--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 10, 2020 at 12:26 am

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

No... you still have the LSN problem.
--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 10, 2020 at 12:09 am

#3732652
Reply To: SQL patching solution and automation

As a bit of a side bar, I'm always amazed when someone says they have a shedload of servers but no money to actually support them. It just doesn't make...
--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 10, 2020 at 12:07 am

#3732651
Reply To: what type of join is this?

jcelko212 32090 wrote:
>> your examples didn't have a join in - they were single table selects <<
If you've done a good job with your schema, then they will be a lot...
--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 11:25 pm

#3732639
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

Viewing 15 posts - 7,606 through 7,620 (of 59,091 total)