Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,216 through 1,230 (of 59,101 total)

Reply To: SQL2022 UPDATED FROM SQL2014 - PARALLELISM ISSUES

autoexcrement wrote:
Off-topic, but awesome to SEE Jeff Moden after all these years! The YT vid was a bit over my head but still fascinating.
I've PM'd you to ask a favor,...
--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 31, 2023 at 9:56 pm

#4277187
Reply To: DBCC Timewarp

Phil Parkin wrote:
Jeff Moden wrote:
Shift all parameters 1.5 bytes to the left and start the run. In 30ms, stop the run and then restart it. Note that you have 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)

August 31, 2023 at 8:46 pm

#4277169
Reply To: DBCC Timewarp

The Dixie Flatline wrote:
DAMMIT!! I make one, ONE, typo on parameter 137 and suddenly I find myself here in the FUTURE!!
Does anyone still follow this thread, and if so, can you...
--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 10:44 pm

#4276219
Reply To: File group size issues

Posting to get Johan's answer to show up. It was the first post on a new page and this forum still has the problem of not showing the first post...
--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 2:59 pm

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

Viewing 15 posts - 1,216 through 1,230 (of 59,101 total)