Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,056 through 8,070 (of 59,091 total)

Reply To: importing text file, bulk insert to populate table

smattiko83 wrote:
I have to import a text file to build a table and all of the date fields currently are in integer form. It comes in three different ways. 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)

December 26, 2019 at 3:14 pm

#3710543
Reply To: High Page File Usage

Good lord!!! A SQL forum that doesn't allow you to upload .SQL or TXT files! This is just silly.
Here's sp_ShowWorst... I've got to figure out how to do the other...
--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)

December 26, 2019 at 2:45 pm

#3710540
Reply To: High Page File Usage

Brahmanand Shukla wrote:
Max Memory capping is applied on the instance.
Total Available Memory : 32 GB
Max Memory configured : 26 GB
Brahmanand Shukla wrote:
As far as I know, nothing additional running on the instance,...
--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)

December 26, 2019 at 2:43 pm

#3710538
Reply To: What is going on with my rebuilding index job?

Man... I'm sorry. I lost track of this thread and didn't answer your additional questions.
I guess my biggest question would be, did you stop using REORGANIZE or 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)

December 25, 2019 at 8:50 pm

#3710358
Reply To: Why columnstore indexes are not very popular?

I just had a sudden flashback to the two threads on "bankers rounding". 😀 I'll get the popcorn. 😀

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

December 25, 2019 at 6:42 pm

#3710354
Reply To: Merry Christmas 2019

p.s. even that later definition (the one inferred by the supposed correct answer) may be incorrect. We would also need to know if a partridge in a pear tree would...
--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)

December 25, 2019 at 5:25 pm

#3710351
Reply To: Merry Christmas 2019

This is where a good analyst would ask for a more explicit meaning of what constitutes a "gift" or "present" and how they can be taken as some as being...
--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)

December 25, 2019 at 5:14 pm

#3710349
Reply To: Reusable Variable

Merry Christmas to you, as well. I thought I'd be about the only one in the world to be posting today. 😀
Thanks for the feedback on the name-splitter function. 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)

December 25, 2019 at 4:15 pm

#3710346
Reply To: Why columnstore indexes are not very popular?

Grant Fritchey wrote:
saving on space happens only if you have repeating data in the storage.
Which is a violation of normalisation rules.
You've just described the very nature of history/audit tables. They are...
--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)

December 25, 2019 at 3:58 pm

#3710345
Reply To: Why columnstore indexes are not very popular?
Grant Fritchey wrote:
Second, aggregates. Analysis. These are where they shine. If you're not seeing GROUP BY in the queries, I wouldn't suggest using them.
So, not good for general history/audit tables (which...
- This reply was modified 6 years, 8 months ago by Jeff Moden. Reason: Add the edit comment
--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)
December 25, 2019 at 5:42 am

#3710313
Reply To: Reusable Variable

Do you have any names that look like the following and, if so, what do you want to do with them? Eliminate the periods and stop at the first space...
--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)

December 25, 2019 at 5:35 am

#3710312
Reply To: Need Correct Query Code Please? Thx. merry Christmas SQL Kids

CoolKid40 wrote:
Thanks for feedback responses everyone and yes its better to work backwards from answer and possibly explain your code syntax logic. I just learning sql. Did not know what...
--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)

December 25, 2019 at 4:49 am

#3710308
Reply To: how to find duplicate rows, dynamically, with a loop

Jonathan AC Roberts wrote:
Jeff Moden wrote:
Jonathan AC Roberts wrote:
Jeff Moden wrote:
Of course, that recommendation also comes with the warning that if the hashbytes are different, then the rows are guaranteed to be different. However (and 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)

December 25, 2019 at 4:46 am

#3710307
Reply To: Rebuild vs Reorganize

t.ovod-everett wrote:
I beg to differ on the "As compared to the rebuild index operation, reorganize index is less resource-consuming operation" assertion. That is not a clear-cut assertion either way. From...
--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)

December 24, 2019 at 4:51 am

#3710165
Reply To: Querying database schema using graph tables

Hi Mala,
First of all, great article. It can be used both as a great introduction to graph tables and to solve a fairly common problem. Your order of revelation and...
--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)

December 24, 2019 at 3:52 am

#3710161

Viewing 15 posts - 8,056 through 8,070 (of 59,091 total)