Jeff Moden

Forum Replies Created

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

RE: Bulk insert into table from csv

@jaryszek ,
You need to generate and post the full CREATE TABLE statement for your target table for us to help further. ...
--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 4, 2017 at 7:06 am

#1970516
RE: Need vertical table as horizontal table in SQL

aaron.reese - Monday, December 4, 2017 5:24 AM
SQL does not give you tables, it gives you data sets
Not sure I agree with...
--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 4, 2017 at 6:08 am

#1970490
RE: Shrinking Transaction Log Files

Lj Burrows - Monday, December 4, 2017 2:54 AM
I would also want to add that clearing the log is done by backing...
--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 4, 2017 at 5:51 am

#1970486
RE: Using CSS to control formatting in dbmail

aaron.reese - Monday, December 4, 2017 5:29 AM
Kudos for getting it to work but I can't help feeling that you are building...
--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 4, 2017 at 5:43 am

#1970483
RE: Is This Database Being Used?

No matter which method you use to determine if a database is being used, it's not a good idea to immediately kill the database. To Dave's point, I'll typically take a...
--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 4, 2017 at 5:37 am

#1970479
RE: Not Useless Features

Steve Jones - SSC Editor - Friday, December 1, 2017 11:34 AM
MattF - Friday, December 1, 2017...
--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:21 am

#1970411
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

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