Jeff Moden

Forum Replies Created

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

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
RE: Splitting a comma separated string in one field and populate several fields

Eirikur Eiriksson - Wednesday, August 8, 2018 11:36 PM
Since you are posting on the SQL Server 2012 forum, you may want...
--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 6:05 pm

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

david_h_edmonds - Thursday, August 9, 2018 9:01 AM
Luis Cazares - Thursday, August 9, 2018 8:47 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 11, 2018 at 6:00 pm

#2001388
RE: Max Degree of Parallelism

I can't speak for anyone else but I've had great success in setting maxdop so than no one process can use more than 25% of the CPUs available and then,...
--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 5:43 pm

#2001387

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