Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,066 through 7,080 (of 59,102 total)

Reply To: Cleanup Sysmail -items from msdb

Awesome. Thanks for the feedback, Bruin.
--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)

May 22, 2020 at 2:07 pm

#3756852
Reply To: Writing Before Reading

Steve Jones - SSC Editor wrote:
Jeff Moden wrote:
+1 Billion to Roger Plowman for his post above. I'll also add that commenting code when you're writing it is pretty simple. The first thing I normally 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)

May 21, 2020 at 4:47 pm

#3756639
Reply To: Writing Before Reading

Tom_Hogan wrote:
Jeff Moden wrote:
...The first thing I normally do is to write the comments of the things I need to get done and why. That also creates a bit of...
--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)

May 21, 2020 at 2:57 pm

#3756601
Reply To: High sensitivity of SQL server 2016 to statistics ?

martinreiser wrote:
Any suggestions ?
I think you missed the suggestion about reverting to the old Cardinality Estimator, which DID fix the same problems we were having when we made the same...
--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)

May 21, 2020 at 2:05 pm

#3756577
Reply To: Import a text file into SQL Server table without BULK insert due to special char

rip wrote:
The text file was UTF-8 and we used CODEPAGE = 65001 and were able to process successfully.
set @Str1 = 'Select * Into ##TempPerson FROM OPENROWSET (BULK '''
set @Str2 =...
--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)

May 21, 2020 at 1:54 pm

#3756572
Reply To: Writing Before Reading

+1 Billion to Roger Plowman for his post above. I'll also add that commenting code when you're writing it is pretty simple. The first thing I normally do is 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)

May 21, 2020 at 1:45 pm

#3756569
Reply To: Result data for date, even when it doesn't exist

jcelko212 32090 wrote:
Play with the idea of having a calendar table and then doing a set-oriented EXCEPT operator to find the missing dates and insert a row with the dummy values...
--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)

May 20, 2020 at 9:09 pm

#3753424
Reply To: Memory Optimized tables for speeding inserts and updates

p.s. Even in SQL Server 2016, there's still a limit of the In Memory stuff of 250GB. In the databases of today, that means you have to be a wee...
--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)

May 20, 2020 at 9:03 pm

#3753418
Reply To: Memory Optimized tables for speeding inserts and updates

I didn't mean that as a slam. It's just not possible to post general guidlines because everyone's stuff is different. I just watched the following YouTube on the subject... 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)

May 20, 2020 at 8:55 pm

#3753417
Reply To: How do we tune a huge DB with ~2TB with huge tables , where do we start ?

Yep... let's go back to square one... if they were to move to Teradata and do the same types of things that they've done with their SQL Server, they'd still...
--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)

May 20, 2020 at 8:47 pm

#3753416
Reply To: Memory Optimized tables for speeding inserts and updates

Sorry... you're not going to like this. My general guideline for things as important as Memory Optimized data is to Google for the documentation and read about it because I...
--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)

May 20, 2020 at 5:36 pm

#3753355
Reply To: How do we tune a huge DB with ~2TB with huge tables , where do we start ?

Great. I wish you well on your endeavor.
As a bit of a sidebar, consider documenting the various things you did and writing an article about it here on SSC even...
--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)

May 20, 2020 at 4:06 pm

#3753308
Reply To: Result data for date, even when it doesn't exist

You're welcome and thank you for the feedback. The question now is... do you know how it works? I ask because you're the one that is going to have 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)

May 20, 2020 at 2:29 pm

#3753262
Reply To: How do we tune a huge DB with ~2TB with huge tables , where do we start ?

Understood. A large part of the problem may actually be the 80% Fill Factor thing you folks have done. It actually takes 25% (not just 20%) more space to store...
--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)

May 20, 2020 at 2:24 pm

#3753260
Reply To: Result data for date, even when it doesn't exist

OK... here we go... code looks almost the same as before but added a couple of tweaks to do it just for the first of the month... I also fix...
--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)

May 20, 2020 at 7:10 am

#3753166

Viewing 15 posts - 7,066 through 7,080 (of 59,102 total)