Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,621 through 7,635 (of 59,098 total)

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
Reply To: How big job it is for a DBA to enable a db and/or table to become IN-MEMORY?

This is not a trivial task and great care must be taken in any such consideration because some of it is incredibly difficult to reverse if it just doesn't happen...
--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:37 am

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

Very close to what Michael John posted, the most import tool of them all is... you brain. It totally doesn't matter what tools y0u use, whether or not you succeed...
--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:26 am

#3732081
Reply To: Inserting large data volumes into a table as fast as possible
The following is going to be an major problem for 100 million rows...
```
SET IDENTITY_INSERT new.RLDX_ARCHIVE ON
INSERT INTO new.RLDX_ARCHIVE
```
There's a known issue with SET IDENTITY_INSERT ON... it forces...
--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:09 am

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

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 have psychology...
--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 6, 2020 at 7:54 pm

#3732018

Viewing 15 posts - 7,621 through 7,635 (of 59,098 total)