Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,351 through 22,365 (of 59,072 total)

RE: Please vote for the "built in Tally Table" function.

Jeff Moden (11/26/2014)
SQLRNNR (11/26/2014)
I decided to down vote this one. Everybody should just go to Oracle where they already have the functionality. (devil)
😛
BWAAAA-HAAAAA-HAAAA!!!! I thought you were...
--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)

November 26, 2014 at 8:04 am

#1761101
RE: Are the posted questions getting worse?

WayneS (11/26/2014)
Jeff - do you happen to know what the vote count was before you posted your request to up-vote the connect item?
I forgot to write it down but I...
--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)

November 26, 2014 at 7:59 am

#1761098
RE: Please vote for the "built in Tally Table" function.

SQLRNNR (11/26/2014)
I decided to down vote this one. Everybody should just go to Oracle where they already have the functionality. (devil)
😛
--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)

November 26, 2014 at 7:55 am

#1761097
RE: Are the posted questions getting worse?

Eirikur Eiriksson (11/25/2014)
Jeff Moden (11/25/2014)
Shifting gears real hard, could you good folks take a look at the following post? I think it's a really important subject even if I...
--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)

November 25, 2014 at 10:09 pm

#1760968
RE: Solution to do maintenance the large table

BTW... I don't mean to make partitioning sound so easy. It can be a real booger to setup especially if you have a bunch of indexes that aren't temporal...
--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)

November 25, 2014 at 10:04 pm

#1760966
RE: Solution to do maintenance the large table

Sagar-636902 (11/25/2014)
great, thats the plan to do next for the partition.. quick question though since we have minimum down time and if we like create db with partition in multiple...
--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)

November 25, 2014 at 10:00 pm

#1760965
RE: How Often Does Production Drift?

Yet Another DBA (11/24/2014)
Drift?? More like herding cats!!!
BWAAA_HAAAA!!!! (Sorry... did that come out loud?) 😀
--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)

November 25, 2014 at 9:34 pm

#1760962
RE: Are the posted questions getting worse?

Shifting gears real hard, could you good folks take a look at the following post? I think it's a really important subject even if I wasn't the one 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)

November 25, 2014 at 9:29 pm

#1760961
RE: Please vote for the "built in Tally Table" function.

Thanks Koen and Eirikur!
How about it folks? There a 1.7 million of you out there. Can we get a few more votes on this important subject? Thanks....
--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)

November 25, 2014 at 9:25 pm

#1760960
RE: sp_executesql within SP Acting as Ad-Hoc Query

JoshDBGuy (11/25/2014)
All,
We have dozens of stored procs with sp_executesql inside the procs. When I run an analysis to determine long-running queries, these are acting as if they are ad-hoc. Is...
--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)

November 25, 2014 at 9:17 pm

#1760958
RE: Solution to do maintenance the large table

Sagar-636902 (11/25/2014)
Thanks both for the Reply,it is sql server 2012 enterprise edition sp1
Then there's no reason why you couldn't delve into the useful if not slightly painful realm of using...
--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)

November 25, 2014 at 8:38 pm

#1760956
RE: Running total

Heh... "Holy shades of 'Office Space', Batman!"
I've had some time to do deeper dive on your request and, although I could certainly be wrong, I think there's a fundamental flaw...
--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)

November 25, 2014 at 8:32 pm

#1760955
RE: DB log growth issue

qew420 (11/25/2014)
My next Maintenance plan is schedule to run in two weeks so I will review the links, articles and scripts you all provided and hopefully come up with 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)

November 25, 2014 at 7:30 pm

#1760951
RE: Solution to do maintenance the large table

Sagar-636902 (11/20/2014)
Here is the situation, I have oltp database about 6 tb and there are couple tables they are very huge one is 1.5 tb another is 700 gb.. We...
--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)

November 25, 2014 at 7:20 pm

#1760949
RE: Solution to do maintenance the large table

arnipetursson (11/25/2014)
Books online suggest reorg if fragmentation is < 28%
http://msdn.microsoft.com/en-us/library/ms189858.aspx
On a large table, 28% is an awful lot of fragmentation. Further, reorganization is fully logged no matter what 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)

November 25, 2014 at 7:16 pm

#1760948

Viewing 15 posts - 22,351 through 22,365 (of 59,072 total)