Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,546 through 13,560 (of 59,095 total)

RE: Not Useless Features

gcosler - Friday, December 1, 2017 10:28 AM
I would like to see the Import task accept current Excel spreadsheets (.xlsx) rather than...
--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 2, 2017 at 9:19 am

#1970410
RE: Not Useless Features

The one feature I'd like to see get improved is the thought process (perhaps, a lack of thought) that MS uses behind the identification and development of new features 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 1, 2017 at 8:26 am

#1970292
RE: Avoiding Development Taxes

Eric M Russell - Tuesday, November 21, 2017 7:36 AM
... This is the same reason why I'd say that it's worth...
--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 1, 2017 at 7:53 am

#1970281
RE: Slow query - client or server issue

leehbi - Thursday, November 30, 2017 2:15 AM
Very lucky to be able to adjust the underlying data structure (Data warehouse) - by...
--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 1, 2017 at 7:50 am

#1970277
RE: We Need DevOps for Performance

David.Poole - Friday, December 1, 2017 2:43 AM
Where there is a dev box of course they do but without a means 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)

December 1, 2017 at 7:45 am

#1970270
RE: Query Optimization Advice

daniness - Friday, December 1, 2017 6:14 AM
ScottPletcher - Thursday, November 30, 2017 12:36 PM
--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 1, 2017 at 7:40 am

#1970266
RE: Bulk insert into table from csv

I'll also ask, if it's a "CSV" (the "C" stands for "Comma"), is your delimiter actually 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)

December 1, 2017 at 7:22 am

#1970261
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Ok... now I'm sure. If you run the code to generate the test table as we did above and then run the code below, you'll see what I mean. Details...
--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 1, 2017 at 12:48 am

#1970221
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

david.leyden - Sunday, October 1, 2017 11:16 PM
I've come across this article and a few others that suggest it is a limitation 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)

November 30, 2017 at 11:51 pm

#1970217
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

The other fly in the ointment is that it's also coming up with the wrong sums.
--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)

November 30, 2017 at 10:43 pm

#1970214
RE: Force execution plan in a view

Luis Cazares - Thursday, November 30, 2017 9:32 AM
Sergiy - Thursday, November 30, 2017 2:17 AM
--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)

November 30, 2017 at 8:01 pm

#1970211
RE: What is the best ways of storing unstructured data in sql server 2016, except filestream.

TUellner - Thursday, November 16, 2017 9:14 AM
Jeff Moden - Wednesday, November 15, 2017 9:07 AM
--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)

November 30, 2017 at 7:41 pm

#1970210
RE: We Need DevOps for Performance

David.Poole - Thursday, November 30, 2017 7:56 AM
Jeff Moden - Thursday, November 30, 2017 7:21 AM
--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)

November 30, 2017 at 6:31 pm

#1970207
RE: Add Column to Staging table

Deletes are pretty expensive and they're fully logged even in the SIMPLE recovery model. Why not just use the generated "dupe number" (row number) to process only the 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)

November 30, 2017 at 5:55 pm

#1970205
RE: The Difference Between Rollup and Cube

gfabbri - Thursday, November 30, 2017 12:21 AM
very interesting. The point is the order of fields in the GROUP BY ROLLUP, 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)

November 30, 2017 at 5:41 pm

#1970201

Viewing 15 posts - 13,546 through 13,560 (of 59,095 total)