Viewing 15 posts - 23,896 through 23,910 (of 26,490 total)
WHY is everyone so eager to shrink their databases transaction log files? If they keep shrinking them after backups, they will just grow again. You should size your...
November 4, 2008 at 6:23 pm
Here is the actual quote from movie:
He is intelligent, but not experienced. His pattern indicates 2 dimensional thinking. -- Spock
November 4, 2008 at 3:35 pm
Randal Burke (11/4/2008)
2) Captain Kirk once said, in his final battle with Khan - "He is evidencing classic two dimensional thinking" - we all evidence that quite often.
I would...
November 4, 2008 at 3:29 pm
I don't remember, and I'm too lazy to look back, did you ever update statistics with a full scan on the SQL Server 2005 database?
The query engine and optimizer are...
November 4, 2008 at 3:01 pm
Mark.Brown (11/4/2008)
I got some help with this and found a resolution. Thanks to anyone who took a look at it.
The proper thing to do now is post your resolution to...
November 4, 2008 at 2:58 pm
No, my typing is. The denominator for my calculations should have been 10 not 5. Nice catch!
November 4, 2008 at 1:48 pm
If you need to do it in the query, does this do what you want?
SELECT
[tbl_IDS_Extract_Local-2].Customer_No,
MasterProductTable_Database.SFAProductCategory,
MasterProductTable_Database.ProductLevel,
...
November 4, 2008 at 1:09 pm
Where is this query being used, a report, a front end app?
November 4, 2008 at 1:05 pm
What I got from the version is that you are using the same base code. Your version of MSDE wasn't SQL Server 7.0 or (7.5). You still would...
November 4, 2008 at 1:01 pm
Original snippet from your code:
(t.ItmRecvdYR1 - t.ItmRecvdYR2)/t.ItmRecvdYR1
This is integer arithmetic. ItmRecvdYR1 - ItmRecvdYR2 is less than ItmRecvdYR1, ie (10 - 5) / 5 = 0.
By multiplying one of...
November 4, 2008 at 12:42 pm
Looks about right. All you have to do now is test it.
November 4, 2008 at 12:30 pm
What do the execution plans for the updates show?
November 4, 2008 at 12:26 pm
Try this in its place and let us know if it works:
SELECT
t.Loc + ' ' + upper(l.abbreviation)[Abbr],
t.VendorID,
DATEPART(YEAR,t.DateYR1)...
November 4, 2008 at 12:09 pm
ALTER DATABASE. Look it up in BOL.
November 4, 2008 at 11:58 am
Viewing 15 posts - 23,896 through 23,910 (of 26,490 total)