Viewing 15 posts - 106 through 120 (of 1,790 total)
Based on that it doesn't look like your log backups will be that big. Another question, what performance measures are you seeing for avg disk sec / read and avg...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 7, 2012 at 10:31 am
skrilla99 (3/6/2012)
Thanks to you both.That is what I figured, but I don't want to leave any metadata laying around that could bite me later.
-Dan B
Definitely a wise thing...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 6, 2012 at 1:08 pm
Yes, if you are not using updateable subscriptions it is safe to remove it.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 6, 2012 at 12:57 pm
Along with Chris's note, can you run the following;
dbcc sqlperf (logspace) and provide the output.
Thanks.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 5, 2012 at 10:19 am
Wow - you have 50 GB of changes every 30 minutes on a given database and 20 GB on all others. That is a lot of data change in a...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 5, 2012 at 10:07 am
...and how frequently are you running them?
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 5, 2012 at 9:51 am
How are you doing your log backups? Are you using a third-party program for those backups? How large are the log backups?
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 5, 2012 at 9:29 am
LOL - I'll concede. Sort of like trying to claim the idea behind the internet huh? 🙂
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 17, 2012 at 1:57 pm
Once you use a Tally table you will want it around for other uses as well which is why master is recommended. They're pretty handy.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 17, 2012 at 1:51 pm
Stefan Krzywicki (2/17/2012)
GSquared (2/17/2012)
Evil Kraig F (2/17/2012)
GSquared (2/17/2012)
bitbucket-25253 (2/17/2012)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 17, 2012 at 1:49 pm
SteffenW (2/17/2012)
and well I'm running SQL in a German enviroment so Date is like: DD.MM.YYYY
I guessed something like that so formatted the dates you provided to meet my date...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 17, 2012 at 1:45 pm
I'll add a small change to the version the previous poster put up using a CTE numbers table. This result will get all the days and I have spot checked...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 17, 2012 at 1:41 pm
SteffenW (2/17/2012)
I'll put a CREATE skript together 😉Well yes...reading Forum etiquette first would help *darn 😉
I'll be back in a bit
Sounds great. Thanks for checking out the article as well....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 17, 2012 at 11:08 am
Yes. I'm thinking that you don't need the second table but could rather just do that with a query and be able to get the data in the format you...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 17, 2012 at 11:01 am
Wondering if you have considered writing a query that will put the data in the format that you are looking for?..? That will allow you to load the data as...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 17, 2012 at 10:47 am
Viewing 15 posts - 106 through 120 (of 1,790 total)