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...
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.
February 18, 2009 at 12:43 pm
Jeff Moden (2/17/2009)
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....
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...
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...
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. 😉
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...
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...
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...
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...
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...
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...
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! 😉
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...
February 13, 2009 at 1:41 pm
Viewing 15 posts - 751 through 765 (of 1,790 total)