Jeff Moden

Forum Replies Created

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

RE: An Introduction to PowerShell for a DBA

Lynn Pettis - Thursday, December 21, 2017 9:37 AM
Sue_H - Thursday, December 21, 2017 9:25 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 26, 2017 at 6:52 am

#1973418
RE: Is the old stuff worth learning?

silvio.schurig - Tuesday, December 26, 2017 5:23 AM
I think old / new is not a major point in whether or not 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 26, 2017 at 6:39 am

#1973417
RE: Is the old stuff worth learning?

David.Poole - Tuesday, December 26, 2017 2:17 AM
Every step taken, whether mistake or true, made me what I am today. The past...
--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 26, 2017 at 6:35 am

#1973416
RE: Database change documentation

DCS_JJW - Monday, March 6, 2017 9:21 AM
I am curious about what kind of database documentation is provided to you the client...
--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 26, 2017 at 6:09 am

#1973409
RE: Database change documentation

Two spam posts reported.
--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 26, 2017 at 6:07 am

#1973407
RE: Tempdb growth

haichells - Monday, December 25, 2017 10:14 PM
Hi,
I have a huge insert/update operation performing in set of tables. The process tooks almost...
--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 26, 2017 at 6:04 am

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

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