Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,046 through 24,060 (of 59,099 total)

RE: which way is the better for 1 million records inserting into one table

That article on loading 1TB in 30 minutes seems to be impressive testament for SSIS but they had 4 instances of SSIS running 56 streams to a 64 processor database...
--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 27, 2014 at 10:56 pm

#1700974
RE: Blocking

Admingod (3/27/2014)
Lets consider 2 different tables TABLE A and TABLE B.Now, suppose that there are two different sessions with different activity. Does one of the session will be blocked or...
--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 27, 2014 at 10:29 pm

#1700972
RE: Converting sequential time records into IN and OUT times

pssudarshan (3/27/2014)
True. But the problem is that the IN time and the OUT time are not on the same row. My difficulty is in getting the IN time...
--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 27, 2014 at 10:26 pm

#1700971
RE: Converting sequential time records into IN and OUT times

pssudarshan (3/27/2014)
Hi Jeff,
Lobbying for a change in the clock design is not an option at present. I am stuck with this clock and I now have to work out...
--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 27, 2014 at 9:50 pm

#1700966
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (3/27/2014)
For your Thur entertainment: http://www.red-gate.com/products/dba/dba-bundle/entrypage/about-the-dba-team?utm_source=ssc&utm_medium=displayad&utm_campaign=sqldbabundle&utm_term=steve_video
BWAAA-HAAA-HAAAA-HAAA!!!! That's too funny. You guys even dubbed in a helo in the background!
Whup? Wait a minute... What'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)

March 27, 2014 at 8:14 pm

#1700960
RE: Are the posted questions getting worse?

Koen Verbeeck (3/27/2014)
W00t w00t, this one makes my 12000th point. 😎
The next 12,000 will be even easier! 😛 Well done Koen!
--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 27, 2014 at 8:09 pm

#1700959
RE: Converting sequential time records into IN and OUT times

@pssudarshan,
Thanks for the great feedback and posting what you did. If it were me, I'd still lobby heavily for the clock punches that came out of the "Pay Punch"...
--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 27, 2014 at 8:04 pm

#1700958
RE: Are the posted questions getting worse?

Grant Fritchey (3/27/2014)
jcrawf02 (3/27/2014)
We have a written test we use to weed out people who don't know the first thing about SQL (report writing position, not DBA stuff), it's pretty...
--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 27, 2014 at 5:51 pm

#1700932
RE: Need help with runaway query using multiple APPLY joins

bncaffey (3/27/2014)
Thanks.
So I actually came up with an alternate solution shortly after making this post. However, getting an alternate solution was not my goal with this post. My...
--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 27, 2014 at 5:46 pm

#1700931
RE: Duplicate key issue ... again ... and again ...

sql-lover (3/27/2014)
TheSQLGuru (3/27/2014)
This is a concurrency issue, therefore I am 99.984% certain it is a CODE issue. Something somewhere is not properly handling locking and concurrency. As for...
--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 27, 2014 at 5:24 pm

#1700923
RE: Trn log backup chain

Barcelona10 (3/27/2014)
Hi all
I have setup maintenance plan which does 2 full(12AM and 5AM) backups and trn log backup starting 5am(every 5 min) and ends 10PM.If i take extra...
--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 27, 2014 at 5:17 pm

#1700921
RE: Evenly splitting large DB files

SQLRNNR (3/27/2014)
8 Files for a 4.5GB database is overkill. For a database that small, I would not split the files. I would look to performance tune the code.
That...
--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 27, 2014 at 11:56 am

#1700832
RE: what is the difference if we create index (at time create table or after insert data into that table ?)

Heh... I'll second the "It Depends" aspect.
What Recovery Model is the database in?
What kind of index are you trying to build?
How many rows are you inserting in the initial batch...
--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 26, 2014 at 4:48 pm

#1700508
RE: Evenly splitting large DB files

I have to ask again, why are you going through all of this? What advantage do you think you're getting out of all this?
--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 26, 2014 at 4:27 pm

#1700500
RE: Datediff

Using Jason's setup code for this problem, here's a way to simplify the code a bit...
SELECT CAST(DATEDIFF(hh,0,@MaxDate-@MinDate) AS VARCHAR(10))
+RIGHT(CONVERT(CHAR(8),@MaxDate-@MinDate,108),6);
--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 26, 2014 at 4:23 pm

#1700499

Viewing 15 posts - 24,046 through 24,060 (of 59,099 total)