Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,471 through 4,485 (of 59,087 total)

Reply To: How to get YYYYMMDDHHMMSS

You can cut out one of the REPLACEs. Look at format # 112.
--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)

October 21, 2021 at 9:31 pm

#3943019
Reply To: Delete Extended Events file

That's exactly the conclusion that I came to but had to ask. Thanks, Grant.
As a bit of a sidebar, long live xp_CmdShell! 😀
--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)

October 21, 2021 at 9:17 pm

#3943001
Reply To: Delete Extended Events file

Have any of you ever solved the problem of something in EE being used to easily identify and delete old files by session without having to jump through a flaming...
--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)

October 21, 2021 at 3:02 pm

#3942889
Reply To: Identify what causes tempdb to increase

So, the answer is "No". You don't know how to determine the code that is causing TempDB to grow.
--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)

October 21, 2021 at 1:25 am

#3942665
Reply To: Splitting table into multiple tables

I agree. I hope people don't read that and think it was the partitioning that did it though. It was the better index that did it. I also state 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)

October 19, 2021 at 8:25 pm

#3942139
Reply To: Splitting table into multiple tables

SQLAddict01 wrote:
We use enterprise edition.
Yes I think partitioning would be helpful for stats to run fast, but I did not see any performance improvements in the queries.
Normally, partitioning will actually...
--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)

October 19, 2021 at 3:54 am

#3941824
Reply To: Splitting table into multiple tables

homebrew01 wrote:
SQLAddict01 wrote:
Performance issues with maintenance tasks like update stats takes forever
This is SQL 2014, so we can have only 1 index on the table..
I tried implementing partitionning in dev,...
--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)

October 19, 2021 at 3:47 am

#3941820
Reply To: Barcode Scan Into SQL Server

JP789 wrote:
We have an Access front end with a SQL Server backend. We have inventory that we need to scan and keep track of. Is there a way to scan...
--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)

October 19, 2021 at 3:43 am

#3941819
Reply To: How to remove data and index fragmentation in a table

Getting back to the original post... you do know what sys.dm_db_index_physical_stats() is for, correct?

--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)

October 18, 2021 at 4:34 pm

#3941671
Reply To: How to remove data and index fragmentation in a table

892717952 wrote:
Dear Jeff Moden, thank you for you kind help! what you said is quite right.
if I ran it on the same server, sometimes it works fine, but sometimes not...
--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)

October 18, 2021 at 4:32 pm

#3941670
Reply To: How to remove data and index fragmentation in a table

892717952 wrote:
thank you Jeffrey Williams, the table has clustered index, but when I used "alter table oldtable rebuild" , the table released a lot space, many thanks!
when I did this...
--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)

October 18, 2021 at 3:07 pm

#3941643
Reply To: Tables accessed in a given week in a database?

Thanks for the reply, Stephen. You should keep track of how things go along the way. This migration would make an awesome 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)

October 18, 2021 at 2:19 pm

#3941621
Reply To: Learning Is Challenging, So, Forgive Yourself

Grant Fritchey wrote:
Jeff Moden wrote:
I'm having the same problem time-wise. As the old saying goes, "So say we all". 😀
I also have to admit there's great incentive in learning something new if...
--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)

October 18, 2021 at 2:04 pm

#3941616
Reply To: How to Delete Large Amounts of Data

Jim,
Only you can answer a few questions about your article that have been nagging at me because I'd like to do some extra testing by setting up some test data.
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)

October 17, 2021 at 2:33 am

#3941233
Reply To: The Digital Twin

David.Poole wrote:
I've worked on a big personalisation project that produced a distance score between 250,000 products for 5 million customers. That was 1.25 trillion records generating 37TB of scoring data.
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)

October 17, 2021 at 2:07 am

#3941227

Viewing 15 posts - 4,471 through 4,485 (of 59,087 total)