Jeff Moden

Forum Replies Created

Viewing 15 posts - 676 through 690 (of 59,081 total)

Reply To: case for 'DBCC TRACEON - Trace Flags'

See the following for the list of supported Trace Flags.
https://learn.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-traceon-trace-flags-transact-sql
1118 (No longer required but I used to have it on server wide. I have the equivalent turned on in 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)

March 22, 2024 at 2:10 am

#4399841
Reply To: unix timestamp to datetime

Why on Earth would you use PoSh to do this? You have the data in a table already.
https://www.sqlservercentral.com/articles/convert-unix-timestamps-to-date-times-in-sql-server-part1

--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 22, 2024 at 1:46 am

#4399838
Reply To: Managed Vs Unmanaged Tables – Data Engineering with Fabric

John Miner wrote:
Hi Jeff,
At the bottom of the article is a zip file link.
I saw that and I kept asking myself where the heck the link was. I have the "nightlight...
--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 21, 2024 at 11:06 pm

#4399778
Reply To: Cranky Curmudgeons

From the article:
Further, because we’re aging, we’re not ready to embrace all the wonderful new technologies that are clearly superior in every possible way.
I know I responded...
--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 21, 2024 at 10:54 pm

#4399772
Reply To: Help with date range subquery

p.s. Read the article at the first link in my signature line below for how to post some readily consumable test data. It'll help you get a coded answer instead...
--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 20, 2024 at 6:51 pm

#4399022
Reply To: Help with date range subquery

ThePhoenix wrote:
No, I won't be limiting the TicketOpenDate for the query. I may add a month filter to limit TicketOpenDate at a later time. The initial query will look at...
--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 20, 2024 at 6:43 pm

#4399021
Reply To: Precuations of reducing the VLFs

vsamantha35 wrote:
Yeah, we do index rebuilds quite often but I am not 100% sure. but definitely that could be one of the reasons.
Jeff, I got your point. Could you please...
--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 20, 2024 at 6:39 pm

#4399018
Reply To: Re-platforming
My two thoughts on things like this continue to be...
1. Change is inevitable. Change for the better is not.
2. If you want to learn something totally new, then try learning...
--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 20, 2024 at 6:16 pm

#4399009
Reply To: Managed Vs Unmanaged Tables – Data Engineering with Fabric

Thanks for the article, John. I'd like to do an experiment with another method. Can you identify the 3rd party link for where to get the source CSVs from, please?

--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 20, 2024 at 6:07 pm

#4399007
Reply To: Pivot 1 row to multiple columns using T SQL

genova11 wrote:
This is how my table looks except I used random numbers for my values. Some of the dx columns have values and some do not. How about actually showing...
--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 19, 2024 at 11:04 pm

#4398477
Reply To: Pivot 1 row to multiple columns using T SQL

Please see the article at the first link on how to provide some readily consumable test data to help you help people help you. It also saves on many questions...
--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 19, 2024 at 10:38 pm

#4398470
Reply To: Precuations of reducing the VLFs

700GB log file for a 5TB database? Have you determined what caused it to grow that large and, if you reduce the size, will it grow to be that large...
--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 19, 2024 at 9:37 pm

#4398435
Reply To: How Important archiving old data

Ditto what Frederico said. You've already identified the problem queries. Check the execution plans for them and fix them.
I'll also say that if you have to remove data from 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 19, 2024 at 8:24 pm

#4398406
Reply To: How can we enhance statistics information collection
Johan Bijnens wrote:
Jeff Moden wrote:
Johan Bijnens wrote:
Currently we are collecting database statistics information using
```
select * FROM sys.dm_db_index_physical_stats( 14, NULL, NULL, NULL, 'SAMPLED')
```
For some larger databases this statement takes more than...
--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 18, 2024 at 5:51 pm

#4397605
Reply To: Query wont use any index - Cannot understand why

p.s. Page compression includes Row compression, which basically turns a lot of "fixed width" datatypes to "variable width" and that can cause HUGE performance and log file problems due 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 18, 2024 at 3:19 pm

#4397557

Viewing 15 posts - 676 through 690 (of 59,081 total)