Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,266 through 5,280 (of 59,072 total)

Reply To: LATCH_EX when creating a clustered index

K. Thanks. One of your answers begs another question. Is that "other" database on the same instance?

--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)

May 12, 2021 at 6:21 pm

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

I normally don't do self-advertisement but I'm giving a presentation tonight at 6PM EDST online on an interesting subject. Here's the link to the Meetup and the abstract is also...
--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)

May 11, 2021 at 7:19 pm

#3882046
Reply To: high CPU

No... at least not yet. Have you done the most needy thing that's usually a problem with 3rd party databases? That "most needy" thing is to update statistics that need...
--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)

May 11, 2021 at 5:55 pm

#3882006
Reply To: LATCH_EX when creating a clustered index
Ummm.... ok... I want to remind you that NOTHING is a panacea! And, with that, I have a couple of questions...
1. What is the source of the data that...
--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)
May 11, 2021 at 5:42 pm

#3882002
Reply To: Non-Stop Learning

eric.kero@orange.fr wrote:
Hi all
In France, we have a statement : « Qui trop embrasse, mal étreint ! »
I don’t know if there’s an equivalent one in english … a clumsy,...
--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)

May 11, 2021 at 4:21 pm

#3881967
Reply To: Minimum permission for user to grant execute on a stored procedure they created

Jeffrey Williams wrote:
@ScottPletcher & @JeffModen:
You both are assuming an environment where there is a dev/test/uat/prod set up. Not saying the OP doesn't have that - but there are environments where...
--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)

May 9, 2021 at 1:08 pm

#3881149
Reply To: SSIS File System Task to move csv Files between folders

TangoVictor wrote:
Jeff Moden wrote:
Why not just use a single DOS "MOVE" command instead of reinventing the wheel?
Jeff where are putting this command? In an Exec Process task or cmd...
--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)

May 7, 2021 at 7:20 pm

#3880668
Reply To: SSIS File System Task to move csv Files between folders

On the subject of compressed file destinations, true dat.
But, so far, everyone appears to be writing C as a replacement for simple CLI commands that already exist... it's kind 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)

May 7, 2021 at 6:14 pm

#3880644
Reply To: Minimum permission for user to grant execute on a stored procedure they created

That's not quite the opposite way for me... I give the Developers SysAdmin privs in the Dev box (and the system login is limited to only Dev Access). Then, I...
--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)

May 7, 2021 at 6:06 pm

#3880643
Reply To: SSIS File System Task to move csv Files between folders

Why not just use a single DOS "MOVE" command instead of reinventing the wheel?
--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)

May 7, 2021 at 3:55 pm

#3880585
Reply To: Minimum permission for user to grant execute on a stored procedure they created

Heh... let's talk maximum permissions for Developers in prod and test environments... NONE! This isn't to deprive Developers of anything cool... it's to protect them from being blamed for every...
--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)

May 7, 2021 at 6:58 am

#3880422
Reply To: data file size difference

atulyan.aries wrote:
when I use sp_helpdb I get file size of 170GB. but when I go to the location where the mdf is placed it shows 160 GB
This might be...
--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)

May 6, 2021 at 6:46 pm

#3880248
Reply To: How to normalize?

This is why I suggested taking a class in database design. 😀
--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)

May 5, 2021 at 10:45 pm

#3879851
Reply To: SQL Server database "fail safe"

That's the term that I've used for this before. I don't know how it works because it's out of my wheelhouse at work but it works.
The good part is, I...
--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)

May 5, 2021 at 8:26 pm

#3879805
Reply To: SQL Server database "fail safe"

I guess I'm not sure exactly how the infrastructure guys are doing it but we have the Windows Cluster and it feeds a secondary offsite server (about 80 miles away)...
--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)

May 5, 2021 at 6:19 pm

#3879756

Viewing 15 posts - 5,266 through 5,280 (of 59,072 total)