Jeff Moden

Forum Replies Created

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

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
RE: Very slow sp_cursorprepexec

It's not just parameter sniffing to be concerned with. You need to check the datatypes of the parameters in the sp_cursorprepexec with those in the table. For example, if Entity...
--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:13 pm

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

This is nuts and it's all because the wrong data type has been used for the column. Petition management to have it changed to a correct, self-validating temporal datatype 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)

August 11, 2018 at 5:07 pm

#2001383
RE: Adding and removing indexes

To add to what Luis posted, you have to remember that, unless you're in some other Recovery Model other than FULL, index creation is fully logged. If you have 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 11, 2018 at 5:00 pm

#2001382
RE: DATEADD YYYYMM

UGH! This is what happens when people try to be "smart" about how to store dates and times except for maybe in a Calendar table. This problem would be 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 11, 2018 at 4:24 pm

#2001381

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