Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,201 through 1,215 (of 59,082 total)

Reply To: Rebuild index for system database

The only time you might want to do a rebuild on a system (or any other database) is if you need to recover a lot of disk space. You check...
--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 30, 2023 at 5:23 am

#4275444
Reply To: Non-yielding Scheduler every 30 days

Windows 11 PRO??? You need to have a Windows Server. I'm surprised that your SQL Standard Edition even runs on that desktop edition.
TBH, I'm thinking it might be automatic reboots...
--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 29, 2023 at 3:26 pm

#4274863
Reply To: shrinking a large data file

vsamantha35 wrote:
Does it make any difference with the on-going open transactions to the database? is it better to do during maintenance windows when there are no incoming connections from 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 28, 2023 at 9:05 pm

#4274059
Reply To: shrinking a large data file

A shrink that large will take a long time, especially if there's a fair bit of LOBs in the data. Worse yet, you won't be able to see any progress...
--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 28, 2023 at 4:08 pm

#4273866
Reply To: SQL2022 UPDATED FROM SQL2014 - PARALLELISM ISSUES
Johan Bijnens wrote:
- Have you rebuild all indexes and statistics after migration/upgrade ?
- Did you compare old vs new SQLplans ?
- How many indexes / indexed views are based on 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 28, 2023 at 2:30 pm

#4273781
Reply To: Determine if value occurred within all shifts

jcelko212 32090 wrote:
I think I'll go to the other extreme. I am waiting for eye surgery right now, so there will be a little delay, but I will develop an article...
--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 28, 2023 at 1:21 am

#4273192
Reply To: Odd columns datatype precisions showing in SSMS View...

After more than 2 decades of having CPU's that have some serious math co-processors, you'd think they change the code for the floating point math that occurs in the NUMERIC...
--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:34 pm

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

Viewing 15 posts - 1,201 through 1,215 (of 59,082 total)