Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,166 through 24,180 (of 59,102 total)

RE: How can i pivot this code?

simflex-897410 (3/13/2014)
Thanks Jeff,
My fault. My reasoning was that our production server hosts sql server 2008.
So, I figured it is better to have a sql server 2008 solution than 2005 because...
--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)

March 13, 2014 at 11:23 am

#1696896
RE: help with a instead of trigger

gfoulks (3/13/2014)
Jeff all valid points. The ssn right now is last four and the plan is to go to a hashed number right now the table is in the proof...
--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)

March 13, 2014 at 11:16 am

#1696890
RE: Assistance with Partition-level locking and X lock on UPDSTATS

jack.odom 35193 (3/13/2014)
Thanks for the reply Jeff. I've updated the data set to more accurately simulate the data I'm actually using, and you are correct that I am not getting...
--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)

March 13, 2014 at 11:14 am

#1696888
RE: Insert Statement for 2 million rows

pretea (3/13/2014)
It is how the vendor sent in the script?
Other thing I can try is to ask them to load data into text file and use BCP.
Heh... I can...
--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)

March 13, 2014 at 11:06 am

#1696885
RE: Insert Statement for 2 million rows

pretea (3/13/2014)
Hi!
I have multiple (individual) insert statement to insert around 2 million rows (using sqlcmd because the insert stament is around 8 thou lines).
It took about an hr to insert...
--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)

March 13, 2014 at 10:20 am

#1696865
RE: help with a instead of trigger

gfoulks (3/13/2014)
Jeff no issues with Columbus just using that area code as the example.
Anyway I created the trigger suggested replacing my example data with the data that I want 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)

March 13, 2014 at 10:16 am

#1696863
RE: Reset memory cache for query tuning?

GilaMonster (3/13/2014)
Jeff Moden (3/12/2014)
Using "Statistics TIME, IO" will also be way off if there are any non iTVF functions in the mix.
IO will be. Time, if you look at 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)

March 13, 2014 at 8:53 am

#1696829
RE: I need to delete 20 million rows from a table...

GilaMonster (3/13/2014)
Jeff Moden (3/12/2014)
Yes... according to MS definitions... which I happen to disagree with and only because they cause so much confusion. 😉
According to how things behave. Adding a third...
--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)

March 13, 2014 at 8:46 am

#1696824
RE: How can i pivot this code?

simflex-897410 (3/13/2014)
Hi Jeff,
Thanks so much for your help sir.
Yes, you are right; I should know better - sorry about that.
I am trying to test your code but keep getting errors.
First...
--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)

March 13, 2014 at 8:38 am

#1696822
RE: What are the steps to capture workload from production and replay on test env.

sqlbuddy123 (3/12/2014)
fsession12 39949 (3/12/2014)
Many thanks for the website link through PM matey, great add-on.
Just had a potential reduce right here so my site may well not been employed before, all...
--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)

March 12, 2014 at 11:51 pm

#1696653
RE: How to use begin try and transaction with in a loop which call other stored procs.

rajemessage 14195 (3/3/2014)
Dear ALL
I have to call few strored precedure like sp1 sp2 sp3 from spmain.
spmain will be scheduled and it will run on time basis.
i want to trap each...
--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)

March 12, 2014 at 11:44 pm

#1696651
RE: Select into #t vs. Create @t table + Insert @t select from ...

Although it's a bit dated, I still consider the following article to be one of the best on the subject of Temp Tables vs Table Variables.
http://www.sqlservercentral.com/articles/Temporary+Tables/66720/
My personal feeling, especially when...
--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)

March 12, 2014 at 11:39 pm

#1696649
RE: SQL Server developer entry level jobs

I'd send them their requirements back with a % (0-100%) with 0% having no clue and 100% being an absolute master on the requirement for each requirement they have. ...
--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)

March 12, 2014 at 11:31 pm

#1696648
RE: How can i pivot this code?

pietlinden (3/12/2014)
That's not a pivot.
Easiest way to do what you are describing is to use Reporting Services and add a Grouping level to your table.
So let's see the easiest 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)

March 12, 2014 at 11:10 pm

#1696644
RE: How can i pivot this code?

simflex-897410 (3/12/2014)
Hi,
When I run the following query:
SELECT ElectionName, Position, CandidateName, c.PositionId,CurrentOfficeHolder,AnswerType FROM Candidates c
...
--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)

March 12, 2014 at 11:08 pm

#1696643

Viewing 15 posts - 24,166 through 24,180 (of 59,102 total)