Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,931 through 15,945 (of 59,063 total)

RE: Heads up on changes to the CHECKSUM function in APDW

pcd_au (1/5/2017)
There's plenty of forum information available on the weakness of the checksum function. I'm currently using it just for testing so whilst this is a pain for me, it'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)

January 5, 2017 at 11:25 pm

#1921034
RE: two backups - false alert

Without having access to either the maintenance plan or the job, it's not likely we'll be able to help you find the problem.
Are both the files pretty close to being...
--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)

January 5, 2017 at 11:10 pm

#1921033
RE: Your 2017 Goals

I just got notified today that they're going to let me upgrade all of the servers at work to 2016. The timing with the inclusion of Enterprise features in...
--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)

January 5, 2017 at 11:01 pm

#1921030
RE: meaning of close and deallocate cursor in stored procedure

Eric M Russell (1/5/2017)
I try to minimize the amount of complexity within the CATCH block of an error handler. According to MSDN there is no technical reason to explicitly close...
--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)

January 5, 2017 at 5:39 pm

#1921017
RE: Query took a nose dive

LeeFAR (1/5/2017)
It looks like it may have been a while.
Attached is the query plan. The main query that is the trouble is Query 3. As you...
--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)

January 5, 2017 at 5:36 pm

#1921016
RE: Are the posted questions getting worse?

Ed Wagner (1/4/2017)
Sean Lange (1/4/2017)
Steve Jones - SSC Editor (1/4/2017)
Testing and bug fixes for the forum upgrade is going well.
Right now we have a final test release set for Tues,...
--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)

January 5, 2017 at 5:34 pm

#1921015
RE: meaning of close and deallocate cursor in stored procedure

It would appear the @ID contains certain user roles that are required to conditionally open a cursor somewhere else in the code. When an error occurs for other user...
--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)

January 5, 2017 at 10:44 am

#1920940
RE: Query took a nose dive

When is the last time you rebuilt statistics on the other tables that you're joining to this one?
--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)

January 5, 2017 at 10:37 am

#1920936
RE: Split Function Usage for Multiple Multi-Select Parameters

You can find the article on the improvements made to the DelimitedSplit8K function with performance tests against other types of splitters as well as the code (see the RESOURCES section...
--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)

January 5, 2017 at 10:26 am

#1920933
RE: Deadlock Problem on a Heap Table

Or, do the BSOFH thing. 😉 Set up an alert to email the devs and their boss every time a deadlock occurs. Make sure it also get'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)

January 5, 2017 at 10:22 am

#1920931
RE: NEWBIE TO THE DBA LIFE

I realize this post has been around for a while but my recommendation is that if you want to be a really good DBA, you'd better be really good at...
--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)

January 5, 2017 at 8:03 am

#1920884
RE: Most likely answering my own question but ..

Stuart Davies (1/5/2017)
As the title says - I think I'm answering my own question, but periodically I see the front page of the the forums have some pink borders around...
--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)

January 5, 2017 at 8:00 am

#1920883
RE: Merge consecutive rows into single row

Why not just replace the embedded carriage returns with an empty string?
--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)

January 5, 2017 at 7:48 am

#1920880
RE: Are there any limits to Pivoting

I'll also say that none of this should require such a load on TempDB. It's a very strong indicator that there's at least one (and it only takes 1...
--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)

January 5, 2017 at 7:40 am

#1920876
RE: Application Upgrade and Index Rebuild

chuck.forbes (1/4/2017)
First off, I appreciate all of the education everyone's been providing to me over the last year and a half.
After reading over everyone's suggestions, I think there's a couple...
--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)

January 4, 2017 at 8:55 am

#1920664

Viewing 15 posts - 15,931 through 15,945 (of 59,063 total)