Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,041 through 8,055 (of 59,072 total)

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, 6 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
Reply To: Hadoop for SQL Developers

I'll second Andrew's take on this. Focusing on T-SQL until you've really learned the licks is the right thing to do and it will help you quite a bit when...
--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:08 am

#3710160
Reply To: Reusable Variable

John524 wrote:
Yes sorry.... I have a tendency of assuming folks can read my mind. What I want to do is to get the first 5 letters of the first name...
--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 1:00 am

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

Jonathan AC Roberts wrote:
Thom A wrote:
Although I believe in Christmas spirit, I don't think giving them the answer is really going to help them in the long run. :/
I don't think you can...
--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 12:47 am

#3710156
Reply To: is there any better way to export SQL server data into csv file?

If the ultimate use for the CSV file will be to load into an Excel spreadsheet, you can also make a "Refreshable Spreadsheet" that calls a stored procedure to get...
--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 23, 2019 at 8:23 pm

#3710121

Viewing 15 posts - 8,041 through 8,055 (of 59,072 total)