Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,906 through 4,920 (of 59,098 total)

Reply To: Import CSV Data Into Existing Tables

VSCurtis wrote:
Hi Guys,
Problem solved. Rather than pull my hair out trying to figure out why MS had to take something so simple and turn it into a complicated Charlie Foxtrot,...
--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 3, 2021 at 1:42 pm

#3916506
Reply To: ColumnStore Index Maintenance routines

doodlingdba wrote:
Hi all
I use the Ola Hallengren Index Optimize script for rowstore index maintenance in my SQL estate. Recently we have been looking into an issue with our data warehouse...
--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 3, 2021 at 12:30 pm

#3916472
Reply To: The Double Table

I don't think including the column name in the PK is a bad idea especially since I do tend to include column names in other indexes. The only reason why...
--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 2, 2021 at 7:39 pm

#3916290
Reply To: The Double Table

BTW... this is also a really good reason to have some naming standards. We follow the standard that PKs will always use the form of PK_tablenamehere.
--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 2, 2021 at 4:36 pm

#3916224
Reply To: The Double Table

When I looked the problem page, no error was included on the page.
--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 2, 2021 at 4:33 pm

#3916222
Reply To: Storage Space of a Column having XML datatype with NULL value

IT researcher wrote:
Does XML datatype with NULL Value in SQL Server 2008 consume any storage space?
As mentioned in https://www.sqlshack.com/optimize-null-values-storage-consumption-using-sql-server-sparse-columns/ If we store a NULL value in a fixed-length column such as...
--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 2, 2021 at 3:49 pm

#3916205
Reply To: How to limit SQL Job Success events

Graham Van der vaart wrote:
Hi Jeff, we require the success to auto clear the failure events. This clear would then auto resolve the help desk auto generated tickets as well as end 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 2, 2021 at 12:24 pm

#3916121
Reply To: EightKB... I'm presenting! Bring your water-cooled helmet! :D

Johan Bijnens wrote:
It was a great session, Jeff Good to hear you again 🙂
Thanks, Johan. It's a shame we couldn't have a couple of beers together afterwards like we did 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 2, 2021 at 11:39 am

#3916108
Reply To: EightKB... I'm presenting! Bring your water-cooled helmet! :D

Tom Uellner wrote:
Jeff,
Thank you for a truly great presentation that shatters a lot of long held beliefs. Certainly one's I've held and I'm sure many others.
-Tom
Thanks Tom. I really appreciate 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 2, 2021 at 11:37 am

#3916106
Reply To: New Index Maintenance Methods Recommended by Microsoft

Toby Harman wrote:
One thing I am disappointed not to be hearing more about is the use of resumable index rebuilds.
I've stopped using reorganize on huge tables where we can't rebuild because...
--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 2, 2021 at 11:27 am

#3916096
Reply To: Slow performance after database shrink
Jonathan AC Roberts wrote:
Jeff Moden wrote:
1. Rebuild your non-unique non-clustered indexes that have NOT been disabled. Rebuild them from smallest to largest.
2. Rebuild your previously disabled non-clustered indexes from smallest to largest.
3. Rebuild...
--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 2, 2021 at 11:17 am

#3916095
Reply To: How to limit SQL Job Success events

My suggestion is to stop monitoring successes. Job history does that well enough.

--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 2, 2021 at 12:11 am

#3915972
Reply To: Slow performance after database shrink

When you do a shrink-file on a data file, pages from the end of the file are moved to unused pages at the beginning of the file. That very effectively...
--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 2, 2021 at 12:06 am

#3915971
Reply To: EightKB... I'm presenting! Bring your water-cooled helmet! :D

David Burrows wrote:
I'd like to add my thanks as well, a great and thoroughly enjoyable presentation (and I actually understood it 🙂 ). Lots of good stuff. Now I just have...
--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 1, 2021 at 7:25 pm

#3915947
Reply To: SELECT records from table 1 that does not exist in table 2 via UNION

So, the next question is, why do they want to know if you know this? Is there a non-obvious performance advantage? I wouldn't believe so but who knows?

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

July 30, 2021 at 6:23 pm

#3915538

Viewing 15 posts - 4,906 through 4,920 (of 59,098 total)