Viewing 15 posts - 751 through 765 (of 1,790 total)
Thanks Noel! I had totally read right over that. Appreciate you taking a look at this and following up! Truly appreciated.
If ever in Upstate NY feel free to drop...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 18, 2009 at 1:31 pm
Yes, I believe so. I can't guarantee as I don't handle all object changes but that is our standard and they are set to replicate DDL changes.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 18, 2009 at 12:43 pm
Jeff Moden (2/17/2009)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 17, 2009 at 10:06 pm
Check out this article [/url]and this article[/url].
Additionally, you should check out this tool which creates a performance data warehouse off your DMV information. Note it takes up some space....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 17, 2009 at 9:54 pm
Actually, after looking at the error a bit more I do wonder if you don't have a space issue during your optimizations. The m_error = 112 may be indicating a...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 17, 2009 at 9:48 pm
Michael Valentine Jones (2/17/2009)
Dev Email 5: Do I have to tell you every little thing?Me Email 5:
...Only if you want me to create the login and give you...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 17, 2009 at 9:42 pm
Jason Crider (2/17/2009)
True, and as much as I love the idea of that it's a time management thing as well.
Definitely understand that one. 😉
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 17, 2009 at 9:32 pm
It really doesn't decide to put it in a datafile. Rather than me typing all this out, the following is from BOL and explains things pretty well;
Filegroups use a...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 17, 2009 at 9:31 pm
Just a thought but, see if they will let you develop the procedure. It will give you the opportunity to get some of that experience and then you can share...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 17, 2009 at 9:24 pm
I believe Gail's response was based on the error and I would agree. The error for space issues is pretty well known and a simple google would have pulled that...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 17, 2009 at 9:09 pm
I actually worked on a project on an application as you describe, actually ran on an Oracle database too, that we ended up working with the vendor to provide them...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 17, 2009 at 8:55 pm
I would try sorting on that column desc to see what you find in there. Look either at the first or the last record to see if you have some...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 17, 2009 at 7:21 pm
The following query will help you see what is happening with the index when you insert. Best thing to do is create a test table with an index and run...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 14, 2009 at 8:56 pm
Lynn Pettis (2/13/2009)
A testament to the professionalism of the founders and those that call SSC home.
Very much agreed! 😉
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 13, 2009 at 3:03 pm
I know that Read Committed Snapshot can alleviate some blocking and have used it in certain circumstances in our environment, mainly because we have an OLTP / Data Warehouse mix...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 13, 2009 at 1:41 pm
Viewing 15 posts - 751 through 765 (of 1,790 total)