Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,321 through 13,335 (of 59,095 total)

RE: How many workers can I use and how many are active?

Lynn Pettis - Tuesday, December 19, 2017 3:19 PM
The other thing, that Jeff hasn't said yet, check the dynamic code that is...
--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 25, 2017 at 2:07 pm

#1973389
RE: Christmas 2017

linda.gock 68050 - Sunday, December 24, 2017 3:16 PM
Jeff Moden - Saturday, December 23, 2017 3:37 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 24, 2017 at 7:37 pm

#1973371
RE: Records in a Table

jagjitsingh - Sunday, December 24, 2017 7:52 AM
Hi
How we can get a list of all tables with No of records 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 24, 2017 at 10:52 am

#1973369
RE: I don’t know how to help with database…

jakecampbell - Sunday, December 24, 2017 5:07 AM
AnneJohannessen - Friday, December 22, 2017 5:18 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 24, 2017 at 10:00 am

#1973367
RE: Table updates on large table with no ID or large gaps between IDs

HappyGeek - Saturday, December 23, 2017 6:27 AM
Would this not benefit from using a tally table? It would save the loops 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 23, 2017 at 3:44 pm

#1973349
RE: Christmas 2017

I could be incorrect but none of the answers are actually correct.
--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 23, 2017 at 3:37 pm

#1973348
RE: Corrupt SQL file how to restore?

This has all the ear-markings of another one of "those" spam posts. Someone who has never posted before and on their first visit or so posts something with a title...
--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 23, 2017 at 3:18 pm

#1973347
RE: t-sql 2012 split function

Jeff Moden - Thursday, December 21, 2017 6:23 PM
wendy elizabeth - Tuesday, December 19, 2017 2:02 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 23, 2017 at 9:12 am

#1973337
RE: OPENROWSET when Excel worksheet name is unknown

Eirikur Eiriksson - Saturday, December 23, 2017 8:35 AM
Jeff, are you working up a huge back-log?
😎
Can we take the Excel thing...
--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 23, 2017 at 9:07 am

#1973336
RE: OPENROWSET when Excel worksheet name is unknown

Hansiehans - Friday, June 27, 2014 1:46 AM
This is the code I used...enjoy 🙂
-- Get table (worksheet) or column (field) listings from...
--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 23, 2017 at 8:29 am

#1973332
RE: To Index a Computed Column...

daniness - Wednesday, December 20, 2017 9:30 AM
Thank you for your feedback, Jeff. That was very helpful and I was finally able...
--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 22, 2017 at 9:56 pm

#1973320
RE: Suggestions on a query plan

Chris Harshman - Friday, December 22, 2017 11:01 AM
ScottPletcher - Thursday, December 21, 2017 3:11 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 22, 2017 at 9:18 pm

#1973319
RE: Suggestions on a query plan

ScottPletcher - Thursday, December 21, 2017 3:11 PM
The key lookups should cost more than the sort for only 7 rows (I know...
--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 22, 2017 at 8:35 pm

#1973317
RE: Suggestions on a query plan

Lynn Pettis - Thursday, December 21, 2017 2:40 PM
Joe Torre - Thursday, December 21, 2017 2: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)

December 22, 2017 at 8:32 pm

#1973316
RE: Trigger Based Change Data capture

I could be wrong (I won't load this code to test it) but this appears to record not only data that has changed, but also records data in all of the other columns...
--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 22, 2017 at 5:42 pm

#1973311

Viewing 15 posts - 13,321 through 13,335 (of 59,095 total)