Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,271 through 15,285 (of 59,097 total)

RE: How to archive old data from sql database

Perry Whittle - Monday, April 3, 2017 7:19 AM
Jeff Moden - Saturday, April 1, 2017 8:48 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 3, 2017 at 7:47 am

#1936284
RE: Cycling the error log

Steve Jones - SSC Editor - Monday, April 3, 2017 7:12 AM
Jeff Moden - Sunday, April 2,...
--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 3, 2017 at 7:40 am

#1936282
RE: SQL Server 2008 R2 CPU Blunted Spikes

Sounds like you're taking all the right steps. There are a couple of things that may be an issue. The first is whatever monitoring software you're using. I've seen such...
--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 3, 2017 at 12:46 am

#1936207
RE: Cycling the error log

I hate answers like "You must restart the SQL Server instance" (emphasis is mine) on multiple choice question especially when there is more than one choice because you don't...
--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:58 pm

#1936201
RE: SQL Server 2008 R2 CPU Blunted Spikes

Have you checked for simple but lengthy blocking and deadlocks?
I'd also be concerned about the nearly flat 30% CPU usage you're seeing.
--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:33 pm

#1936199
RE: Stairway to Advanced T-SQL Level 9: Compare, Modify, Derive and Validate Date and Time Values

Just a couple of personal notes not covered in the article...
I certainly can't speak for anyone else but I find the ISDATE() function to have the same problems...
--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 7:49 pm

#1936197
RE: Stairway to Advanced T-SQL Level 9: Compare, Modify, Derive and Validate Date and Time Values

thisisfutile - Wednesday, November 25, 2015 7:49 AM
I have a question for the community. What's the reasoning that DATE fields can't...
--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 7:20 pm

#1936196
RE: Importing Stored Procedure execution in excel - New Columns not showing up

My recommendation would be to use an "External Data Source" in the spreadsheet rather than trying to write your own in VBA.
Other than that, you may have 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)

April 2, 2017 at 7:00 pm

#1936195
RE: Numeric as primary key

NUMERIC(19,0) works just fine for this. It does take 1 extra byte and a small bit of extra time compared to BIGINT wherever and whenever it's used but it works...
--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 6:48 pm

#1936194
RE: INSERT into table with 5 billion rows

When you do your weekly dumps, are the IDs always larger than the largest ID in the dbo.Temp table or not?
--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 6:27 pm

#1936193
RE: Search for string in stored procedures excluding comments

Heh... and then there's string literals, which may also contain things like the word "Employee", which could be the name of a table.,
--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 6:11 pm

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

Viewing 15 posts - 15,271 through 15,285 (of 59,097 total)