Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,286 through 15,300 (of 59,097 total)

RE: How to join these tables together

jcelko212 32090 - Sunday, April 2, 2017 11:33 AM
Jeff Moden - Thursday, March 30, 2017 8: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)

April 2, 2017 at 5:01 pm

#1936184
RE: How to archive old data from sql database

SQLRNNR - Saturday, April 1, 2017 9:50 PM
Jeff Moden - Saturday, April 1, 2017 9:17 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)

April 2, 2017 at 8:53 am

#1936176
RE: Big Companies are Improving with DevOps

Michael L John - Thursday, March 30, 2017 10:51 AM
Jeff Moden - Thursday, March 30, 2017 8:28...
--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)

April 2, 2017 at 8:46 am

#1936175
RE: tempdb data and log file

Steve Jones - SSC Editor - Sunday, April 2, 2017 3:01 AM
SQLRNNR - Saturday, April 1, 2017...
--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)

April 2, 2017 at 8:08 am

#1936173
RE: tempdb data and log file

SQLRNNR - Saturday, April 1, 2017 8:48 PM
Jeff Moden - Saturday, April 1, 2017 8:41 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)

April 1, 2017 at 9:33 pm

#1936159
RE: How to archive old data from sql database

SQLRNNR - Saturday, April 1, 2017 8:58 PM
I was thinking of the stored procedure route. I really prefer partitioning because it 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)

April 1, 2017 at 9:17 pm

#1936158
RE: Actifio?

SQLRNNR - Saturday, April 1, 2017 8:51 PM
Jeff Moden - Saturday, April 1, 2017 8:38 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)

April 1, 2017 at 9:11 pm

#1936157
RE: How to archive old data from sql database

If you don't want to go the table-partitioning route, then write a proc to move items to accumulator tables on a daily basis and delete them from the mains. Once...
--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)

April 1, 2017 at 8:48 pm

#1936154
RE: tempdb data and log file

sqlguy80 - Saturday, April 1, 2017 1:33 PM
Hi,
We have some reporting queries which use tempdb very heavily and I get alerts 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)

April 1, 2017 at 8:46 pm

#1936152
RE: tempdb data and log file

I guess I'll have to disagree if TempDB is on a SAN. Unless you can guarantee that the MDF and LDF files are guaranteed to be on separate spindles, there's...
--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)

April 1, 2017 at 8:41 pm

#1936149
RE: Actifio?

SQLRNNR - Saturday, April 1, 2017 10:57 AM
Even with this tool, the general recommendation is to perform native backups 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)

April 1, 2017 at 8:38 pm

#1936148
RE: How to join these tables together

jcelko212 32090 - Saturday, April 1, 2017 6:13 PM
Joe Torre - Thursday, March 30, 2017 2:26 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)

April 1, 2017 at 8:20 pm

#1936146
RE: SQL Server DBA Certification

SQLRNNR - Saturday, April 1, 2017 4:48 PM
Jeff Moden - Thursday, March 30, 2017 8:29 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)

April 1, 2017 at 8:15 pm

#1936145
RE: Help with trigger transaction

arun@D - Saturday, April 1, 2017 8:31 AM
Jeff Moden - Friday, March 31, 2017 7:54 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)

April 1, 2017 at 8:12 pm

#1936144
RE: Removing Table Partitions

Yes... you need a MERGE of partitions before you can drop a filegroup that's involved in the partitioning.
--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)

March 31, 2017 at 7:58 pm

#1936100

Viewing 15 posts - 15,286 through 15,300 (of 59,097 total)