Jeff Moden

Forum Replies Created

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

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
RE: How to store Excel files In SQL Table

fregatepallada - Thursday, December 7, 2017 1:17 AM
Complete LUNACY.
I highly recommend you to read this first https://www.microsoft.com/en-us/research/wp-content/uploads/2006/04/tr-2006-45.pdf
Are you aware of FILESTREAM capabilities...
--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 8:34 am

#1971182
RE: Can Data Save the World?

David.Poole - Thursday, December 7, 2017 12:26 AM
Jeff Moden - Wednesday, December 6, 2017 8: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)

December 7, 2017 at 8:13 am

#1971180
RE: HASHBYTES can help quickly load a Data Warehouse

I'll add that if HASHBYTES is different between any two rows, then the rows are guaranteed to be different but, if they are the same,
there's not necessarily 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 6, 2017 at 8:52 pm

#1971096
RE: Can Data Save the World?

Getting back to the subject at hand... "Can data save the world"? Yes it can. We just need to find people that know how to use the data correctly 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 6, 2017 at 8:30 pm

#1971095
RE: Can Data Save the World?

David.Poole - Wednesday, December 6, 2017 12:18 PM
I think data people get blindsided by cognitive bias and sometimes the cynicism that comes...
--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 6, 2017 at 8:18 pm

#1971094
RE: Bulk insert into table from csv

jaryszek - Wednesday, December 6, 2017 9:32 AM
Hi Guys,
could you please do it step by step as i I did in 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 6, 2017 at 7:59 pm

#1971092

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