Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,256 through 15,270 (of 59,063 total)

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
RE: Help with trigger transaction

Your existence check using SELECT COUNT(*) is horribly expensive and is the likely cause of many of your problems. Change it to the appropriate IF EXISTS() as a starting point.
--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:54 pm

#1936099
RE: Are the posted questions getting worse?

Crud. I guess I blew it. Today was the last day to submit contributions for MVP renewal. I went to update my profile at 8:30PM and it won't take any...
--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:44 pm

#1936098
RE: Do it all in C# instead?

I'm curious. What is this supposedly complicated process?
--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 4:01 pm

#1936091
RE: Determine average

crowegreg - Friday, March 31, 2017 12:46 PM
Attached is an export of the table into an excel spreadsheet.
For report week Mar 24th,...
--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 3:55 pm

#1936090

Viewing 15 posts - 15,256 through 15,270 (of 59,063 total)