Viewing 15 posts - 12,826 through 12,840 (of 18,923 total)
The real question would be ; How many users do you have on the db and what are they doing on it??
September 28, 2005 at 11:49 am
You should always normalize.
You should denormalize only when you have no other choice (for performance) and if the data is for reports only (less overhead of keeping 2-3 tables in...
September 28, 2005 at 11:48 am
Actually it means that the server will read ALL data, committed or not (read even if the commit transaction hasn't been issued).
So I would doubt that this is the problem...
September 28, 2005 at 11:41 am
Can we see some sample data?
September 28, 2005 at 10:05 am
Check the calling applications to make sure they are not calling using "with recompile".
Also make sure that all the calls made are using the same format >>
With and without the...
September 28, 2005 at 9:58 am
Just merge those columns in the main design.. then it'll be much easier.
Are all those columns datetimes (as in not varchars or ints)??
September 28, 2005 at 9:51 am
That would be one other major flaw I'd want to avoid
.
September 28, 2005 at 9:45 am
Check my latest version, it'll perfom faster than the first one I did. Make sure understand the where clause in the final select... it's the validation part and it...
September 28, 2005 at 9:41 am
Isn't there any tables that have inserts in them???
Maybe the db was just set to a huge size and didn't need to grow, but now that the db is "full",...
September 28, 2005 at 9:27 am
First of all you are right; My solution didn't provide exactly what was needed (actually was shipping out too much). This opens the door for a real set based...
September 28, 2005 at 9:12 am
If only that were true
.
September 28, 2005 at 8:39 am
I wouldn't be mysefl without my usual typeaus
.
September 28, 2005 at 8:19 am
23 spellings????????????????
can we see a list
.
September 28, 2005 at 6:56 am
Viewing 15 posts - 12,826 through 12,840 (of 18,923 total)