Viewing 15 posts - 17,446 through 17,460 (of 22,214 total)
Jacob Pressures (5/13/2009)
May 14, 2009 at 7:11 am
PaulB (5/14/2009)
sabutp (5/14/2009)I am not sure in MS SQL but in Sysbase SQL separate indexes are created automatically for primary and foreign keys.
MS SQL Server != Sybase
They departed ways...
May 14, 2009 at 7:08 am
You should probably try generating the database as a script, recreate it, empty, and then migrate the data over. You could continue using SELECT statements or you might want to...
May 14, 2009 at 7:06 am
That's a huge topic. If you're expected to deliver all this stuff NOW and you don't know how, you really are over your head. However, this is a high level...
May 14, 2009 at 6:56 am
It really depends on the query being run. Most of the time, a JOIN is the preferred methodology. However, there are queries where the IN statement will work just as...
May 14, 2009 at 6:54 am
The the vast and overwhelming majority of systems, you should do both.
The algorythm that decides whether or not to update statistics is pretty good, but it's not perfect. Most people...
May 14, 2009 at 6:51 am
Sounds like a good problem to have.
Buy a big box, with lots of memory... Sorry, but no one can help much past that without a lot more definition of the...
May 14, 2009 at 6:42 am
I think this one will require application of the Mk1 Eyeball and the 19xx release of Brain.
There are too many variables possible for a script to automate the process. For...
May 14, 2009 at 6:41 am
I agree, it depends.
A large majority of our applications have transaction control from the code, not within the procedures, so while we use TRY/CATCH error handling, we don't have a...
May 14, 2009 at 6:35 am
No index is automatically created when you create foreign keys.
May 14, 2009 at 6:23 am
And the size of the databases in production keep growing so you have to have 5-10 times as much space in dev since you have multiple copies of everything. Then...
May 13, 2009 at 5:37 pm
Ah, I didn't see the bit about the rowmodctr. And I forgot all about it. However, since it only takes a single modification to make a statistic available for update......
May 13, 2009 at 12:06 pm
Hmmm... It's my understanding that sp_updatestats does nothing more than cursor through all the tables in the system running UPDATE STATISTICS against them. I just rechecked that in the Books...
May 13, 2009 at 10:40 am
I've been losing this fight for years. Just recently we had the financial people get involved. When they found out that the developers couldn't guarantee consistent tests since the production...
May 13, 2009 at 9:56 am
If you're running it in conjunction, run it before and then run the new script.
May 13, 2009 at 8:59 am
Viewing 15 posts - 17,446 through 17,460 (of 22,214 total)