Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,961 through 15,975 (of 59,098 total)

RE: Data loading is incomplete -

ramana3327 (1/7/2017)
Hi,
We have a SQL Job that truncate tables in one database then insert into the tables from different database. Some times we are missing some data with in the...
--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 7, 2017 at 4:08 pm

#1921252
RE: Add loginName...etc on select * from sys.procedures

Tac11 (1/6/2017)
Hi expert,
How to add LoginName, ApplicationName, HostName on select * from sys.procedures to find out who altered the Store procedure. I tried from default trace but not working it'...
--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 7, 2017 at 8:20 am

#1921240
RE: The Salary Range

Gary Varga (1/7/2017)
Steve Jones - SSC Editor (1/6/2017)
Gary Varga (1/4/2017)
Just because someone enjoys doing something doesn't mean they are any good at it.
I enjoy singing in my car. When alone....
--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 7, 2017 at 7:50 am

#1921239
RE: The Salary Range

Alan.B (1/3/2017)
Great post Steve, 5 stars.
I found out a few weeks back that my department is moving to Phoenix AZ. I did not chose to transfer so I'll be...
--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 7, 2017 at 7:22 am

#1921238
RE: Long wait times for parallel queries

but, looking at the statistics it was doing a lot of reading but no writing with intermittent PAGEIOLATCH_SH waits before returning to runnable status but never see running.
I don't know...
--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 6, 2017 at 5:17 pm

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

Viewing 15 posts - 15,961 through 15,975 (of 59,098 total)