Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,801 through 13,815 (of 59,095 total)

RE: ApexSQL Monitor

KJKKPSI - Tuesday, November 7, 2017 6:52 AM
The silence is deafening.
I know. The whole internet was down yesterday. 😉
Please try the following...
--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 7, 2017 at 7:46 am

#1966996
RE: Import multiple excel files in one go

Talvin Singh - Tuesday, November 7, 2017 2:53 AM
currently i import within SQL server management studio.
right click the database name > task...
--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 7, 2017 at 7:27 am

#1966991
RE: XML index statistics

Although you can't actually see the XML indexes, you can see what the Primary Index would look like by prepping an XML "Document" and looking at what they call 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)

November 7, 2017 at 7:20 am

#1966989
RE: Core T-SQL

TomThomson - Monday, November 6, 2017 10:41 AM
Eric M Russell - Monday, November 6, 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)

November 7, 2017 at 7:08 am

#1966986
RE: Changing NVARCHAR to VARCHAR...

Arsh - Tuesday, November 7, 2017 3:24 AM
GilaMonster - Friday, November 3, 2017 9:09 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 7, 2017 at 6:20 am

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

Jeff Moden - Monday, November 6, 2017 5:17 PM
Vegeta7 - Sunday, November 5, 2017 6:52 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 6, 2017 at 9:35 pm

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

jcelko212 32090 - Monday, November 6, 2017 4:16 PM
Vegeta7 - Saturday, November 4, 2017 12:30 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 6, 2017 at 7:46 pm

#1966918
RE: Import multiple excel files in one go

There's actually an easy way to read the tab names from a given spreadsheet file but I'd like an answer to my original question below so that I can make...
--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:41 pm

#1966912
RE: The Importance of Clear Data Displays

I guess my next question would be, does anyone actually have pictures of what these displays look like for the given conditions?
--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:38 pm

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

Viewing 15 posts - 13,801 through 13,815 (of 59,095 total)