Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,101 through 17,115 (of 59,067 total)

RE: Finding related records within the same table

Hugo Kornelis (8/5/2016)
First of all, I never buy the "we cannot change the data structure anymore" argument. The only argument I buy is that it would be too expensive, and...
--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)

August 5, 2016 at 7:18 pm

#1894170
RE: Finding related records within the same table

drew.allen (8/5/2016)
sku370870 (8/5/2016)
drew.allen (8/5/2016)
sku370870 (8/5/2016)
Thanks for your reply. But when I am on any particular stage, all I have to hand is the StakeholderID for that stage - so I...
--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)

August 5, 2016 at 7:15 pm

#1894169
RE: Finding related records within the same table

sku370870 (8/4/2016)
CREATE TABLE #tblStakeholders
(
StakeholderID int,
StageID...
--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)

August 5, 2016 at 6:57 pm

#1894168
RE: Query Suddenly Performing Badly

It was me that talked about stats and Kevin is correct. Even though you're using Ola's fine code, you've not verified the condition of the stats on the table(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)

August 5, 2016 at 5:14 pm

#1894166
RE: Query Suddenly Performing Badly

TheSQLGuru (8/5/2016)
Jeff Moden (8/5/2016)
lmarkum (8/5/2016)
Jeff Moden (8/5/2016)
lmarkum (8/5/2016)
I forgot to mention that in these plans there will be a missing index recommendation on the NewsletterHistory. I don't understand 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)

August 5, 2016 at 4:35 pm

#1894164
RE: Query Suddenly Performing Badly

Also, you ARE rebuilding stats on the indexes for this table on a regular basis, correct?
--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)

August 5, 2016 at 12:19 pm

#1894137
RE: Query Suddenly Performing Badly

lmarkum (8/5/2016)
Jeff Moden (8/5/2016)
lmarkum (8/5/2016)
I forgot to mention that in these plans there will be a missing index recommendation on the NewsletterHistory. I don't understand the recommendation because 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)

August 5, 2016 at 12:18 pm

#1894136
RE: Lowest PLE value so far

I do look at PLE but not for the reason that a lot of others might. It's usually a pretty good indication that there's some seriously inefficient code 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)

August 5, 2016 at 11:32 am

#1894119
RE: Differences between MS SQL Server and Gupta SQL Server

shanalalkasim (8/5/2016)
Hi,
I have 7+ yr experience in Gupta SQL. It's entirely different from SQL server. If you need any help please contact me. My mail id is shanalalkasim@gmail.com
The original post...
--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)

August 5, 2016 at 11:21 am

#1894116
RE: Query Suddenly Performing Badly

lmarkum (8/5/2016)
I forgot to mention that in these plans there will be a missing index recommendation on the NewsletterHistory. I don't understand the recommendation because the only place I...
--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)

August 5, 2016 at 11:18 am

#1894112
RE: Most efficient/least painful way to anonymise data in a large table

James Lavery (8/5/2016)
Hi Steve,
Thanks - that's what I thought.
The problem is the customer wants to put representative data in terms of volumes on the new system, but wants it anonymised....
--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)

August 5, 2016 at 11:11 am

#1894110
RE: Bulk insert with format file - handling quotation mark text qualifiers in header row

vinaypandey28 8266 (8/5/2016)
Hi Jeff,
I am facing difficulty when column row is not having any text qualifier but data rows have.
what would be the format file structure in this case.
--Data file...
--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)

August 5, 2016 at 10:51 am

#1894103
RE: Add New Column with RowID

Nusc (8/4/2016)
This is not an issue. This whole thing has been solved.
Two way street here, please. What is the solution you ended up with?
--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)

August 4, 2016 at 6:48 pm

#1893966
RE: Count the occurrence of word in a Resume Table

shambhavi13 (8/3/2016)
I have a table called Resume with columns in Text, Word and PDF format. I enabled Full Text Search on the table and able to search the keyword through...
--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)

August 3, 2016 at 9:59 pm

#1893663
RE: How to get rid of implicit conversions ??

vsamantha35 (8/3/2016)
Thats Awesome Eirikur Eiriksson. Other thing, it came into my mind looking at the Execution Plan, I see sort and the Merge join is happening.
Is there an way,...
--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)

August 3, 2016 at 7:02 pm

#1893657

Viewing 15 posts - 17,101 through 17,115 (of 59,067 total)