Jeff Moden

Forum Replies Created

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

RE: Showing users that have created 0 records

It would be much easier to help you resolve this if you provided some readily consumable test data. See the first link in my signature line for how to do...
--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:39 pm

#1936190
RE: Stored Procedure execution

sam 55243 - Thursday, December 17, 2015 6:38 AM
Hi, Below is the scenario.CREATE PROCEDURE SP_MAINASBEGIN-- SET NOCOUNT ON added to prevent extra...
--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:36 pm

#1936189
RE: No PKs on fact tables

You can have a HEAP with a PK because a PK does not have to be a clustered index.
Shifting gears, yes... I've seen the problem that you describe...
--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:33 pm

#1936188
RE: Actifio?

SQLRNNR - Saturday, April 1, 2017 9:46 PM
Local first and then file copy off to SAN after that. Takes another 30...
--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:05 pm

#1936186
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

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