Jeff Moden

Forum Replies Created

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

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
RE: Reset memory cache for query tuning?

SQLRNNR (3/4/2014)
Cost can help you determine if the query has been tuned.
In addition, you could use statistics time and statistics IO.
Examining the execution plan can really help to determine if...
--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 9:01 pm

#1696625
RE: Really need help with query taking longer after backup!

It could be that you're clearing the cache but not the execution plan. Try adding a CHECKPOINT and DBCC FREEPROCCACHE before the DBCC DROPCLEANBUFFERS and see what you get.
--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 8:56 pm

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

Partitioning helps on something like this but not when you change 50% of the table, which is exactly what you're doing with the Client2 insert. Change that to 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 12, 2014 at 8:49 pm

#1696623

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