Jeff Moden

Forum Replies Created

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

RE: Are the posted questions getting worse?

GilaMonster (3/28/2014)
Ed Wagner (3/28/2014)
Grant - You have booth babes??? :w00t:
Grant *is* the booth 'babe' 🙂
Heh... especially on kilt day. 😀
--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 28, 2014 at 10:36 am

#1701215
RE: Log file is filling up

New Born DBA (3/28/2014)
Come to think of it, I don't know how adding initial size to 1000 MB and set the growth to 1000 MB will help. The auto-growth of...
--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 28, 2014 at 9:13 am

#1701173
RE: Are the posted questions getting worse?

SQLRNNR (3/28/2014)
Sean Lange (3/28/2014)
dwain.c (3/28/2014)
Ville-Pekka Vahteala (3/27/2014)
Luis Cazares (3/27/2014)
How is it possible that someone writes a cursor instead of using SUM()?
I'm afraid that this database is full of these pieces...
--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 28, 2014 at 8:08 am

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

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