Jeff Moden

Forum Replies Created

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

RE: Name Value Pairs Table Handling

Matt Miller (4) - Tuesday, November 7, 2017 10:51 AM
Have you considered just storing the XML itself (or a standardized version 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 8, 2017 at 6:01 am

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

jcelko212 32090 - Tuesday, November 7, 2017 1:00 PM
Vegeta7 - Tuesday, November 7, 2017 2:34 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:48 pm

#1967079
RE: What are you worth?

norway.martin - Tuesday, November 7, 2017 12:16 PM
Jeff Moden - Tuesday, November 7, 2017 12:12 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 7, 2017 at 12:43 pm

#1967045
RE: What are you worth?

norway.martin - Tuesday, November 7, 2017 11:35 AM
You are aware that it is usually illegal for a company in the US 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 7, 2017 at 12:12 pm

#1967041
RE: SQL versus program

patrickmcginnis59 10839 - Tuesday, November 7, 2017 6:27 AM
Sergiy - Tuesday, November 7, 2017 4:46 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 12:09 pm

#1967040
RE: ApexSQL Monitor

KJKKPSI - Tuesday, November 7, 2017 9:32 AM
Jeff Moden - Tuesday, November 7, 2017 7:46 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 10:03 am

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

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