Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,381 through 22,395 (of 59,098 total)

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
RE: Running total

GrassHopper (11/25/2014)
Tried this:
Select groupid, [line number], [to]-[from] as ToFrom,
MAX([to]-[from]) over (partition by groupid
order by [line number]
rows between 1 Preceding
AND 1 preceding) as prevToFrom,
MAX([to]-[from]) over (partition by...
--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:01 am

#1760822
RE: Running total

pietlinden (11/24/2014)
If you use windowing functions, this isn't that hard. Since I didn't understand how the create table/insert statements were related to your question, this is a somewhat generic...
--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:56 am

#1760820
RE: Split out a field of comma separated values based on a unique code in the same row.

Koen Verbeeck (10/21/2014)
Take a look at this excellent splitter function by Jeff Moden[/url].
Thank you for the kudo, Koen. :blush:
--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 24, 2014 at 10:10 pm

#1760690
RE: Split out a field of comma separated values based on a unique code in the same row.

@ Trawler,
Are you all set on this one?
--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 24, 2014 at 10:09 pm

#1760689

Viewing 15 posts - 22,381 through 22,395 (of 59,098 total)