Viewing 15 posts - 33,406 through 33,420 (of 39,736 total)
Are all the tables indexed on the columns being referenced in the join? For example, is there an index on shipment.shipment?
Have you looked at the query plan to see what...
December 29, 2005 at 10:39 am
round()?
declare @i numeric( 6, 4)
select @i = 1.6025
select @i, round(@i, 2)
December 29, 2005 at 10:37 am
That's what I thought and no offense. The questions seem a little silly to me sometimes because I have worked with them for so long and you are questioning things...
December 29, 2005 at 9:24 am
I like "slightly denormalized" data for reporting, if it's a secondary data store and not a primary one.
I agree with David that this can become cumbersome, not only for deletes,...
December 29, 2005 at 9:22 am
Interesting thread. Space in the log or data file could be an issue. While SQL Server autogrows, all activity in the db stops, which can appear as "freezing up". this...
December 29, 2005 at 9:20 am
I haven't ever thought about distribution, but I have removed it from model. I don't want any guest permissions on servers, only those that I explicitly have setup.
If it breaks...
December 29, 2005 at 9:17 am
I saw a presentation about 4 years ago from a guy on hardware tuning. He talked about a few interesting things with disks. First was that you start to really...
December 29, 2005 at 9:15 am
You probably need to run a backup transaction xxx with no_log to free up space. You would also want to setup a regular log backup or move to simple mode.
December 29, 2005 at 9:06 am
The server decides this and the DBA has no control over this.
December 29, 2005 at 9:04 am
You'll need to reduce the size of the result set, or remove some things like ordering. What kind of 50M result set can you actually work with? If this is...
December 28, 2005 at 9:53 pm
I think you need to enable remote connections as a server setting. Try sp_configure or the properties for the server.
December 28, 2005 at 9:52 pm
And the key should be periodically changed. Wouldn't want someone to "crack" last year's backup and then be able to use the key to get current card numbers.
With that, be...
December 28, 2005 at 4:29 pm
Anytime and definitely a varchar. Perf should be fine.
December 28, 2005 at 4:27 pm
Haven't changed anything. Is it IE 6?
December 28, 2005 at 4:26 pm
Viewing 15 posts - 33,406 through 33,420 (of 39,736 total)