Viewing 15 posts - 181 through 195 (of 242 total)
Matt S. (4/7/2009)
April 7, 2009 at 4:11 pm
OK and table size in MB / GB is?
If it is a big table it takes a while.
Do you have non unique clustered indexes?
This also rebuilds all other indexes.
PRACTICAL ADVICE....
April 7, 2009 at 4:07 pm
OK, I have never tried it for this specific case so hope you can use it as you require after some further research. Good luck with your investigations.
April 7, 2009 at 3:35 pm
Its quite likely that this is just normal behaviour.
How are you rebuilding the indexes (maintenance plan, specific statements, something else)?
How big is the database? (or databases)
What is the specification of...
April 7, 2009 at 3:32 pm
DBA, there are a lot of posts at the moment about not understanding what the questioner is trying to do.
You haven't explained why you want to do this.
There is no...
April 7, 2009 at 3:22 pm
Try the undocumented sp_MSforeachdb
More details at:
http://www.databasejournal.com/features/mssql/article.php/3441031
April 7, 2009 at 3:16 pm
Why would you want to?
If you have changed the table it will recompile anyway.
If not why do you need to clear it?
April 7, 2009 at 3:09 pm
Use stored procedures, they are always better than ad-hoc SQL in a variety of different ways. Simply stated, SQL can compile and execute them more efficiently, and thet can be...
March 24, 2009 at 5:58 pm
OR alternatively if your question was whether this was normal and it's not really a problem having such a large LDF, then yes it is normal for your code and...
March 24, 2009 at 8:38 am
Whoo - that's big! Thanks for the code. I can understand the transaction log size now!
OK, basically a transaction is there to make sure that some work either ALL happens...
March 24, 2009 at 8:34 am
It would probably help if I explain my thought process.
50GB is a very big log on a system in SIMPLE recovery mode, because it usually only has to be big...
March 24, 2009 at 4:34 am
I'm confused! This says to me that your log size is 4.984375 MB and you are using 21% of it.
Where do you get the fact that it has grown to...
March 24, 2009 at 4:04 am
karthikeyan (3/23/2009)
All,Which country is best for outsourcing? I believe i will get some interesting answers.
LOL. It's credit crunch time. What sort of answer are you expecting?
Oh sorry! I mean I'm...
March 23, 2009 at 5:22 pm
GilaMonster (3/19/2009)
Krishna (3/19/2009)
GilaMonster (3/19/2009)
My criteria for clustered indexes - narrow, unchanging, unique, ever-increasing.That's a good one Gail. Explains everything just in 4 words.:-D
March 23, 2009 at 4:59 pm
Viewing 15 posts - 181 through 195 (of 242 total)