Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,491 through 20,505 (of 59,072 total)

RE: Are the posted questions getting worse?

Ed Wagner (6/2/2015)
Jack Corbett (6/2/2015)
Alvin Ramard (6/2/2015)
Brandie Tarvin (6/2/2015)
So long as no one brings up the whipped cream incident, everything should be fine.
What about the pork chops?...
--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)

June 3, 2015 at 6:01 am

#1802571
RE: Are the posted questions getting worse?

Eirikur Eiriksson (6/2/2015)
Alvin Ramard (6/2/2015)
I might need a pork chop soon. I won't care if it's coated in whipped cream, BBQ sauce, or anything else!
Maybe mint jelly or 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)

June 3, 2015 at 5:58 am

#1802570
RE: A Case FOR Cursors...

Lenochka (6/1/2015)
Thank you for writing this. I used to ask a cursor question when interviewing candidates and I got the same answer every time “you shouldn’t use cursors,...
--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)

June 3, 2015 at 5:56 am

#1802567
RE: A Case FOR Cursors...

Andy DBA (6/2/2015)
fundpc (6/2/2015)
...and yes I am old enough to have been there when our IBM RD281 disk pack, read heads driven with hydraulic rams, blew a packing 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)

June 3, 2015 at 5:53 am

#1802564
RE: Creation of random password which is easy to remember!!

SQL-DBA-01 (6/2/2015)
Thnx Lowell for giving me the approach and the nice script indeed. Many thnx.
Hi Luis
I can go to online site to steal their password if incase I have a...
--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)

June 2, 2015 at 8:11 pm

#1802485
RE: Table Locking & Killed/Roll-back Session Issue

This is a tough one. You have to find the connection on the DB2 side of the house and kill it before the SQL Server connection will rollback.
--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)

June 2, 2015 at 8:03 pm

#1802484
RE: Query assistance....

Ozzmodiar (6/2/2015)
I see you have a perfectly valid solution, so I won't bother typing it all up unless you're interested.
There is a very elegant solution to this problem using 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)

June 2, 2015 at 7:59 pm

#1802482
RE: Missing Identity Numbers

Frank Cazabon (6/2/2015)
Thanks to all, especially the link to the bug when restarting the service.
It's actually not a "BUG". It's a performance feature. They preallocate 1,000 IDs 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)

June 2, 2015 at 7:56 pm

#1802481
RE: Running totals with OVER clause

devsql123 (6/2/2015)
Hi Folks i am in similar situation...can you please see my post and reply me.
My Post title is: "Trying to get running Total in SQL Server"
Thanks
Devsql
Eirikur's most recent answer...
--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)

June 2, 2015 at 5:52 am

#1802249
RE: Writing Better T-SQL: Top-Down Design May Not be the Best Choice

While this is a good example and it's a good article (thank you SQLMickey for taking the time to write it), it IS an example of 1. "Divide'n'Conquer" methods...
--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)

June 2, 2015 at 5:18 am

#1802244
RE: A Case FOR Cursors...

There's a pretty good chance on most systems that 1) 100,000 rows would not cause a 1.3 second blip. It would normally take an order of magnitude higher number...
--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)

June 1, 2015 at 9:30 pm

#1802213
RE: Are the posted questions getting worse?

Maybe it's just me. I might be getting too old for this business. I don't understand why people make such ridiculous posts.
http://www.sqlservercentral.com/Forums/FindPost1690570.aspx
--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)

June 1, 2015 at 8:05 pm

#1802204
RE: Find out the size of database tables, row count, data size, index growth

mark.the.dba (6/1/2015)
I updated the script to handle tables in different schema's. I was using this today and found I have issues when the tables had different schema's.
/quote]
I hope they...
--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)

June 1, 2015 at 8:00 pm

#1802202
RE: Find out the size of database tables, row count, data size, index growth

mark.the.dba (6/1/2015)
I updated the script to handle tables in different schema's. I was using this today and found I have issues when the tables had different schema's.
I hope they...
--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)

June 1, 2015 at 8:00 pm

#1802201
RE: Combining Temp Table Results

Union all should have worked but it's impossible to tell without seeing your code, at the very least.
--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)

June 1, 2015 at 7:50 pm

#1802200

Viewing 15 posts - 20,491 through 20,505 (of 59,072 total)