Viewing 8 posts - 1 through 8 (of 8 total)
RSS feeds for blogs. I am following nearly 80 different feeds using bloglines. Today there where 28 new blog posts in my SQL section.
March 10, 2006 at 6:27 am
Are you doing this in Query Analyzer? If so, in options under results the max number of characters returned for a single column is 256. Change it to what you...
January 11, 2006 at 2:53 pm
try this in place of your code.
SELECT RMSFILENUM,
sum(rmstranamt) AS rmstranamt10 1 or not
FROM RFINANL
WHERE RMSTRANCDE = '10'
GROUP...
January 11, 2006 at 2:50 pm
yes those values are correct if you perform a bitwise and comparison on the value and a nonzero value is returned. This must be performed for each status value, since...
January 11, 2006 at 2:46 pm
To find out some information, look in the master db for sp_helpindex. Stats are used to indicate the following:
ignore duplicate keys
unique
ignore duplicate rows
hypothetical
statistics
primary key
unique key
auto create
stats no recompute
January 11, 2006 at 8:56 am
In general, upgrading injects a lot of chaos in the enterprise and we try to avoid it. When MS added Reporting services to the tool set for SQL Server that...
December 2, 2005 at 6:59 am
I have to agree that in my experience DAS is a better solution is some cases. I recently worked on a project where the size of the databases ranged up...
June 22, 2005 at 11:33 am
While I won't say this relates to your problem, I have run across similar types of odd behavior. On one occasion the presence of other indexes on the table was...
April 8, 2005 at 6:22 am
Viewing 8 posts - 1 through 8 (of 8 total)