Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,536 through 11,550 (of 59,102 total)

RE: Huge number of tables

JackCarrington - Monday, August 13, 2018 6:46 AM
Jeff Moden - Saturday, August 11, 2018 1:13 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)

August 13, 2018 at 3:24 pm

#2001561
RE: The TSB disaster: Where were the grown-ups?

Another proof that if you want it real bad, that's the way you'll get it. 😀
--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)

August 13, 2018 at 8:42 am

#2001490
RE: What does your backup process look like?

To be honest, I wouldn't change from the original backup plan except to do the transaction log backups every half hour. Restoration of a database that only has weekly backups...
--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)

August 13, 2018 at 8:40 am

#2001487
RE: Looking for an idea how to construct this T-SQL Select Statement

drew.allen - Monday, August 13, 2018 8:27 AM
andycadley - Sunday, August 12, 2018 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)

August 13, 2018 at 8:29 am

#2001482
RE: Unwired for Weeks

GeorgeCopeland - Friday, August 10, 2018 1:32 PM
Agile methodology is a gift from god. You are right: if people keep having...
--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)

August 13, 2018 at 6:28 am

#2001452
RE: Are the posted questions getting worse?

Beatrix Kiddo - Monday, August 13, 2018 3:26 AM
Hmm, I would use indices in a financial markets context, but indexes in 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)

August 13, 2018 at 6:19 am

#2001450
RE: Urgent:Transaction Rollback

My very strong recommendation would be to not screw with anything during the rollback. Been there, done dat.
--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)

August 13, 2018 at 6:09 am

#2001448
RE: Copy all objects (tables, views, functions, stored procedures) from one DB to another DB

I'll also add that if you had proper source control running, this would be a cake walk. 😉
--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)

August 13, 2018 at 6:03 am

#2001447
RE: Problem Converting DATE. Trying to Purge Data Oldest than 30 days from Performance Counter Table where date column is char (24)

Jonathan AC Roberts - Sunday, August 12, 2018 2:57 AM
Jeff Moden - Saturday, August 11, 2018 7:37...
--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)

August 12, 2018 at 3:53 pm

#2001415
RE: Converting decimals to HH:MM:SS

andycadley - Sunday, August 12, 2018 3:26 PM
Jeff Moden - Sunday, August 12, 2018 3:20 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)

August 12, 2018 at 3:43 pm

#2001414
RE: DATEADD YYYYMM

Eirikur Eiriksson - Sunday, August 12, 2018 8:55 AM
Jeff Moden - Saturday, August 11, 2018 4:24 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)

August 12, 2018 at 3:36 pm

#2001413
RE: Converting decimals to HH:MM:SS

Eirikur Eiriksson - Sunday, August 12, 2018 12:46 AM
Quick question, as there is no duration data type in SQL Server,...
--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)

August 12, 2018 at 3:20 pm

#2001411
RE: Converting decimals to HH:MM:SS

Eirikur Eiriksson - Sunday, August 12, 2018 9:55 AM
andycadley - Sunday, August 12, 2018 6:06 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)

August 12, 2018 at 3:05 pm

#2001410
RE: Converting decimals to HH:MM:SS

david_h_edmonds - Sunday, August 12, 2018 9:47 AM
All valid points for consideration however in this instance, the LOBS calculates the duration prior...
--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)

August 12, 2018 at 3:02 pm

#2001409
RE: Problem Converting DATE. Trying to Purge Data Oldest than 30 days from Performance Counter Table where date column is char (24)

Jonathan AC Roberts - Saturday, August 11, 2018 5:41 PM
I don't think anyone has noticed/seen my solution above. You just need 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)

August 11, 2018 at 7:37 pm

#2001390

Viewing 15 posts - 11,536 through 11,550 (of 59,102 total)