Jeff Moden

Forum Replies Created

Viewing 15 posts - 706 through 720 (of 59,101 total)

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
Reply To: very slow performance using WHERE on Oracle linked server

Heh... you just had to know there was going to be some spam involved after the 2 new one-off replies that mostly didn't say much. 😀
--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:15 pm

#4397554
Reply To: Strange Deadlock Graph showing multiple DB but isolated

VastSQL wrote:
Hi Experts,
I am observing strange deadlock behaviour where one deadlock graph have 2 isolated databases involved. Can any experts here shed some light on this?
Regards
Synonyms. Views. Joins that use...
--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:08 pm

#4397551
Reply To: How can we enhance statistics information collection
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 23...
--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 2:58 pm

#4397527
Reply To: Protecting Off Hours

Heh... I work with a "Director" that I've worked with for nearly 2 decades. He had a sign on his wall that said...
"Piss Poor Planning on YOUR part DOES constitute...
--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 2:43 pm

#4397522
Reply To: very slow performance using WHERE on Oracle linked server

cphite wrote:
We're not joining to anything local, fortunately. We're literally just dumping the contents of reporting tables on our server to a tables on their server - the only difference...
--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 17, 2024 at 4:38 pm

#4397009
Reply To: Give It Away

Ok... on that note... it's a bit ironic having a RedGate employee talk to us about "Giving it away" when the very forum such an article is on has seriously...
--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 17, 2024 at 3:09 pm

#4396978
Reply To: Database Ownership - Does it Matter ?

Johan Bijnens wrote:
We create a sqluser "NonSA" to serve as dbowner for all user databases (unless other is actually needed - eg during install/upgrade of some software)
Thumbs up on that. 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)

March 17, 2024 at 2:16 pm

#4396956
Reply To: Rebuilding/Reorganizing in a very transactional table

Alejandro Santana wrote:
Thanks for the quick reply Jeff!
Do you use Auto update stats? And for critical tables full scan with norecompute? And update these weekly? Or just full scan all stats...
--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 17, 2024 at 2:14 pm

#4396955
Reply To: Rebuilding/Reorganizing in a very transactional table

I rebuild stats once per week. Because most of the clustered indexes are "ever increasing" in nature, I use the "if it moved, shoot it" approach. I also use full...
--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 17, 2024 at 4:45 am

#4396804
Reply To: Rebuilding/Reorganizing in a very transactional table

Alejandro Santana wrote:
The server has 150GB of RAM And 48 processors, its 2019 Enterprise.
First, that's an insanely expensive server and you good folks have crippled it with 150GB of RAM. 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)

March 17, 2024 at 2:19 am

#4396758

Viewing 15 posts - 706 through 720 (of 59,101 total)