Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,486 through 13,500 (of 59,101 total)

RE: SQL Battleship

below86 - Friday, December 8, 2017 1:31 PM
OMG, the game of my life. The first 6 shots I had I sank 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)

December 8, 2017 at 2:55 pm

#1971435
RE: ORDER By Based on Company then SubCompany

Seems to me that the hierarchy here won't change often. This is a prime candidate for conversion to Nested Sets, which will enable some remarkably efficient queries if the table...
--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 8, 2017 at 2:52 pm

#1971434
RE: A simple example which, after 15 years of relational design work, still breaks my brain - phone numbers

Thom A - Friday, December 8, 2017 3:34 AM
I certainly agree that, if you can, store things such as phone numbers in...
--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 8, 2017 at 8:02 am

#1971375
RE: No of Months between two dates in YYYYMM format

Luis Cazares - Monday, June 15, 2015 1:50 PM
sgmunson (6/15/2015)
sqlinterset (6/15/2015)
I am looking to calculate no of months between two dates which...
--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 8, 2017 at 7:53 am

#1971372
RE: Job getting stuck in UAT but runs fine in Prod

coolchaitu - Friday, December 8, 2017 7:42 AM
Arsh - Friday, December 8, 2017 7: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)

December 8, 2017 at 7:49 am

#1971369
RE: Bulk insert into table from csv

What error are you getting for the one that doesn't work?
--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 8, 2017 at 7:43 am

#1971367
RE: No of Months between two dates in YYYYMM format

robert.steele 53480 - Friday, December 8, 2017 4:11 AM
Jeff Moden - Thursday, December 7, 2017 3:25 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 8, 2017 at 7:40 am

#1971365
RE: A simple example which, after 15 years of relational design work, still breaks my brain - phone numbers

Don Halloran - Tuesday, December 5, 2017 8:15 PM
Jeff Moden - Tuesday, December 5, 2017 8:05 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 7, 2017 at 7:25 pm

#1971300
RE: find out what transaction caused the log file to become full yesterday or day before yesterday

Jeff Moden - Thursday, December 7, 2017 12:49 PM
coolchaitu - Thursday, December 7, 2017 10:32 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)

December 7, 2017 at 4:58 pm

#1971294
RE: No of Months between two dates in YYYYMM format

robert.steele 53480 - Thursday, December 7, 2017 10:09 AM
Jeff Moden - Thursday, July 16, 2015 8:56 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)

December 7, 2017 at 3:25 pm

#1971287
RE: Index question

Lynn Pettis - Thursday, December 7, 2017 12:44 PM
Jeff Moden - Thursday, December 7, 2017 11:58 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)

December 7, 2017 at 3:12 pm

#1971285
RE: find out what transaction caused the log file to become full yesterday or day before yesterday

coolchaitu - Thursday, December 7, 2017 10:32 AM
Jeff Moden - Wednesday, December 6, 2017 5:55 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 7, 2017 at 12:49 pm

#1971266
RE: Insert data in multiple batches for millions of record

s.ravisankar - Thursday, December 7, 2017 4:15 AM
Hi,
I have table x, table y
table x have millions of record, so i want 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 7, 2017 at 12:07 pm

#1971260
RE: Index question

vsamantha35 - Thursday, December 7, 2017 11:00 AM
Why not retain index 2 and drop index1 and index3?
Because Index3 is a UNIQUE index...
--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 7, 2017 at 11:58 am

#1971258
RE: setting expectations on query tuning issues ?

vsamantha35 - Thursday, December 7, 2017 11:24 AM
Hi All,
Its a general query performance expectations setting question for a non-tech or...
--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 7, 2017 at 11:49 am

#1971253

Viewing 15 posts - 13,486 through 13,500 (of 59,101 total)