Viewing 15 posts - 931 through 945 (of 1,790 total)
As Grant stated far more eloquently than I can, having the clustered index there may be causing you to split pages as the token is probably not a sequential id....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 14, 2009 at 1:14 pm
It does look cool. Very Oraclesque.... 😛
;
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 14, 2009 at 12:44 pm
I don't actually run it either for a couple of reasons but it is more robust than intellisense. Due to the size of our environment I really can't use it...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 14, 2009 at 12:39 pm
When you try Intellisense you will find that it is not as robust as SQL Prompt. Of course that is opinion but you should still check it out prior to...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 14, 2009 at 12:18 pm
Nope, just with 2008 installs. The tools work great though and there are some benefits, like recommended indexes when looking at execution plans and you actually get flagged when there...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 14, 2009 at 10:57 am
You stated that you have a dedicated pipe to the SAN but is it possible that the volume group (SAN level) in question is shared across more than one drive...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 14, 2009 at 10:47 am
Yup, just making sure that there wasn't confusion between the two. Thanks for the clarification.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 14, 2009 at 10:17 am
Just a note from BOL;
"Rebuilding a clustered index does not rebuild associated nonclustered indexes unless the keyword ALL is specified."
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 14, 2009 at 9:53 am
Thanks. That would be great. You can contact me directly by sending me an email via my profile information.
Thanks again!
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 14, 2009 at 9:09 am
Nice. Thanks for sharing and glad it worked.
We are doing a upgrade to 2008 on 64-Bit in a couple months and part of that is moving servers that are...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 14, 2009 at 9:01 am
Curious as to what you were trying to do and what you ended up with as a functional solution. If you can post that it may help others in the...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 14, 2009 at 8:51 am
I honestly don't know. Haven't tried it. I could try to test it in the next day or so but not immediately as I'm a wee bit busy lately.
Anyone...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 13, 2009 at 3:27 pm
No, I was referring to Mani's comment about having 2 servers. If that was possible then you could do the rename at the end. Sorry for the confusion.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 13, 2009 at 2:27 pm
Blocking is required for databases to function so no, there is no way to avoid it completely. 🙂 Your solution is definitely a possibility and probably pretty sound.
The other...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 13, 2009 at 12:57 pm
A couple of queries as follows;
--Help to isolate physical disk(s) that are involved in the I/O bottlenecks
select
db_name(t1.database_id) AS DatabaseName,
t1.database_id,
t1.file_id,
substring(mf.physical_name, 1, 2) as DriveLetter,...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 13, 2009 at 12:49 pm
Viewing 15 posts - 931 through 945 (of 1,790 total)