Viewing 15 posts - 1,141 through 1,155 (of 1,412 total)
Have you run DBCC CHECKTABLE? Any errors? What kind of index(es) do you have for the table?
--
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
March 25, 2003 at 10:36 am
Well, they may do it that way, but to simply spit out an image stored in a database to a client browser (or whatever communicating with your webserver via HTTP)...
March 25, 2003 at 10:26 am
quote:
Through experience with both I feel that Oracle is more forgiving to a poorly designed DB.
March 25, 2003 at 10:20 am
You can have them installed on the same machine, but not both active at the same time.
--
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
March 25, 2003 at 10:10 am
My guess would be that they just store the binary data of the image in SQL Server, then when someone requests it they return it through an ADO Stream object....
March 25, 2003 at 8:07 am
Very unlucky indeed. And weird...
How are you running the queries? Is it in Query Analyzer, or through some other tool? Have you tried running it with ANSI_NULLS explicitly set on...
March 25, 2003 at 8:03 am
It is not different really, just that you can control it better. Other than this, there really aren't much you can do. If you have 4 GB of data you...
March 25, 2003 at 7:32 am
OK, now I'm really getting confused. Are you sure ANSI_NULLS are set off? What does these statements return? Change DATABASENAME to your database's name.
SELECT DATABASEPROPERTYEX('DATABASENAME','IsAnsiNullsEnabled')
SELECT DATABASEPROPERTYEX('DATABASENAME','IsAnsiNullDefault')
If the values are really...
March 25, 2003 at 7:27 am
quote:
Oh, so if I do an update like the one I demonstrated above, the trigger fires only once and I would need...
March 25, 2003 at 7:22 am
You can shrink it manually, file by file. Is it your transaction log that is growing on you? If so then backing up the log more often might help.
--
Chris Hedgate...
March 25, 2003 at 6:37 am
quote:
HI, the box is unticked.
Ok, so that means that the following statement returns 3982466, right?
select...
March 25, 2003 at 6:34 am
Please continue discussion in duplicate thread where answers exist: http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=10830&FORUM_ID=9&CAT_ID=1&Topic_Title=sql+server+unable+to+evaluate+null&Forum_Title=General
--
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
March 25, 2003 at 6:31 am
Please don't cross-post. See answers and post new ones in other thread: http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=10830&FORUM_ID=9&CAT_ID=1&Topic_Title=sql+server+unable+to+evaluate+null&Forum_Title=General
--
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
March 25, 2003 at 6:30 am
Hmm, really strange. Not that I think it is the cause of the problem, but what is ANSI_NULLS set to?
--
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
March 25, 2003 at 6:29 am
If you don't know if tracing is on or not, I'd guess it's not. 🙂
However, if your transaction log is set to grow automatically (and I guess it is, otherwise...
March 25, 2003 at 4:45 am
Viewing 15 posts - 1,141 through 1,155 (of 1,412 total)