Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,816 through 13,830 (of 59,101 total)

RE: The Importance of Clear Data Displays

chrisn-585491 - Monday, November 6, 2017 6:40 AM
:exclamation:
The blame isn't on the interface, it's on the management.
http://www.navy.mil/submit/display.asp?story_id=103130
...
--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 6, 2017 at 5:31 pm

#1966910
RE: SQL versus program

Matt Miller (4) - Monday, November 6, 2017 3:30 PM
Jeff Moden - Wednesday, November 1, 2017 7:45...
--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 6, 2017 at 5:27 pm

#1966909
RE: Date Ranges - Simple, but seemingly impossible

Vegeta7 - Sunday, November 5, 2017 6:52 PM
... the end result will be to have a discount fact table, where 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)

November 6, 2017 at 5:17 pm

#1966907
RE: import .BCP files into sql server

mail_sady - Monday, November 6, 2017 1:07 AM
Hi Jeff,
Gosh thanks a ton ! I had given up on this. I will try...
--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 6, 2017 at 5:06 pm

#1966906
RE: Delete syntax not working

komal145 - Monday, October 16, 2017 3:39 PM
Lynn Pettis - Monday, October 16, 2017 11:37 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 5, 2017 at 7:29 pm

#1966728
RE: Delete syntax not working

jcelko212 32090 - Friday, November 3, 2017 4:57 PM
You're trying to use a syntax that is proprietary 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)

November 5, 2017 at 7:25 pm

#1966726
RE: CTE - Cursor - Try Catch

drew.allen - Friday, November 3, 2017 1:41 PM
rxm119528 - Friday, November 3, 2017 12:34 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)

November 5, 2017 at 7:08 pm

#1966725
RE: CPU spike when executing a query in SQL

saum70 - Saturday, November 4, 2017 5:00 AM
Hi,
Our production environment recently have been witnessing spike in CPU utilization of more 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)

November 5, 2017 at 7:04 pm

#1966724
RE: Initial size of data file

coolchaitu - Sunday, November 5, 2017 3:51 AM
Thom A - Wednesday, November 1, 2017 10:05 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 5, 2017 at 6:50 pm

#1966722
RE: Core T-SQL

xsevensinzx - Sunday, November 5, 2017 2:00 AM
Jeff Moden - Saturday, November 4, 2017 7: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)

November 5, 2017 at 6:46 pm

#1966721
RE: Are the posted questions getting worse?

Lynn Pettis - Sunday, November 5, 2017 6:00 PM
So, today is not what I expected. My dad's right femur broke causing him...
--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 5, 2017 at 6:26 pm

#1966718
RE: Date Ranges - Simple, but seemingly impossible

Vegeta7 - Sunday, November 5, 2017 8:17 AM
Eirikur Eiriksson - Sunday, November 5, 2017 2:02 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 5, 2017 at 5:52 pm

#1966716
RE: import .BCP files into sql server

Ok... just in case you haven't figured it all out...
1. There is no need for BCP here.
2. There is no need for a BCP format file here.
3. ...
--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 5, 2017 at 5:30 pm

#1966715
RE: import .BCP files into sql server

Ah, my apologies. I lost track of this one.
Did you suss this or do you still need help?
--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 5, 2017 at 3:54 pm

#1966713
RE: Collect data en show it in a graph

You could just setup and Excel spreadsheet to hit a stored proc and do automatic refreshes to update a chart in Excel.
The question is, what kind 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 5, 2017 at 3:27 pm

#1966712

Viewing 15 posts - 13,816 through 13,830 (of 59,101 total)