Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,186 through 1,200 (of 59,065 total)

Reply To: Removing Weak Security from SQL Server

Eric M Russell wrote:
For example, we actually have Express edition installed at 1,000+ point of sale locations and rely on a 3rd party backup solution just for the encryption.
Now THAT sounds like...
--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)

August 25, 2023 at 5:07 pm

#4271316
Reply To: Space is not getting freed up when deleting data from a log table.

vsamantha35 wrote:
We are trying to delete data from logging table which has grown upto 7 TB. App team now decided to delete the data based on some filters. As they...
--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)

August 25, 2023 at 12:09 am

#4270579
Reply To: BCP with ODBC 18?

What is preventing you from trying it and then reporting back here for all our benefit?
NTS:PPTS
--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)

August 24, 2023 at 11:42 pm

#4270575
Reply To: Is it a good option to store monthly total in database?

As a bit of a sidebar, if you don't want historical data to ever change, partition the tables (file and filegroup) and make the older files "Read Only". It 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)

August 24, 2023 at 11:37 pm

#4270574
Reply To: Use Alpha characters instead of expanding field

below86 wrote:
We did go with a conversion table, this way we could eliminate some bad words or abbreviations. I don't think we had anything that would go out with 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)

August 24, 2023 at 11:20 pm

#4270543
Reply To: SQL code help to get one row for each sequential entry

sql5322 wrote:
Hi,
I am looking for a sql help to generate one row per each sequental door_area, for a given employee, based on the sample data that looks like this:
Current Output:
--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)

August 24, 2023 at 3:14 am

#4269666
Reply To: Is it a good option to store monthly total in database?

Mr. Brian Gale wrote:
Why bother storing something that you can calculate out when you query the data?
To get sheer, blinding, speed. It's the basic method that Pre-Aggregation through Indexed Views work. 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)

August 24, 2023 at 1:01 am

#4269610
Reply To: Space is not getting freed up when deleting data from a log table.

vsamantha35 wrote:
Hi All,
We are trying to delete data from a large 5TB log table. We are able to delete the data but that is not shown up in the free...
--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)

August 24, 2023 at 12:39 am

#4269595
Reply To: How to get max date for each column in SQL Server

Krish319 wrote:
Hi Phil Parkin,
This is working on the sample data I created.
But If I apllied on my original table I am getting below error.
Invalid length parameter passed to 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)

August 23, 2023 at 5:16 pm

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

Brandie Tarvin wrote:
Jeff Moden wrote:
Thom A wrote:
As we're sharing "new job" pains, we're likely going to be are taking responsibility of IT services for our parent company in the month months (years).
Ok......
--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)

August 23, 2023 at 4:47 pm

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

Thom A wrote:
Jeff Moden wrote:
Ok... let's all gather hands in a circle around Thom and repeat the DBA prayer with me...
I'm not sure the strength will help me as it's likely 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)

August 23, 2023 at 3:34 pm

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

Michael L John wrote:
At my new position, DISTINCT is the default for every query. Nobody knows why they do it. There is a fairly large group who is 100% dedicated to creating...
--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)

August 23, 2023 at 3:22 pm

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

Thom A wrote:
As we're sharing "new job" pains, we're likely going to be are taking responsibility of IT services for our parent company in the month months (years).
Ok... let's all...
--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)

August 23, 2023 at 3:11 pm

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

Brandie Tarvin wrote:
jonathan.crawford wrote:
Trying to imagine a scenario where I worked with Jeff Moden and tried to call out his code...
Jeff, Tally tables aren't working and this RBAR thing is RIDICULOUS....
--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)

August 23, 2023 at 3:03 pm

#4269220
Reply To: Use Alpha characters instead of expanding field

Understood. That's why I suggested that your first take on the subject is probably your best take.
To prevent any overlapping of old vs new, leave everything you currently have alone. ...
--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)

August 23, 2023 at 1:45 am

#4268626

Viewing 15 posts - 1,186 through 1,200 (of 59,065 total)