Viewing 15 posts - 47,386 through 47,400 (of 49,571 total)
The thing is, you can't create a variable of type image. If it were SQL 2005, you could use varbinar(max) but that's not an option on 2000. So the suggested...
February 14, 2008 at 12:19 am
Can you post the import proc please?
There are serveral people here very good at 'fixing' cursors (by replacing them with set-based code)
February 13, 2008 at 10:16 pm
The do work together pretty well.
Make sure when you install 2005 that you create a new instance and don't upgrade the 2000 instance.
I would recommend setting the max memory...
February 13, 2008 at 9:58 pm
Absolutely. While it wouldn't speed up the entire process, it would shorten the length of the locks on the updated table.
February 13, 2008 at 9:55 pm
Not quite as simple.
Right click the DB, Tasks -> Export Data
Work through the various steps of the wizard. If you have problems, shout.
February 13, 2008 at 9:53 pm
If you want no one to access the DB, sysadmin or otherwise, take the DB offline
February 13, 2008 at 9:51 pm
Check the link in the first post. It's a blog post by Conor Cunningham, former member of the SQL Server Query processing team and former development lead on the Query...
February 13, 2008 at 9:49 pm
You can save the package out as VB code. If you have anyone there who can read VB, it may be of use.
February 13, 2008 at 1:33 pm
Restricted user means that only members of the sysadmin server role or db_owner database rolw can connect to the DB.
Is that what you're looking for?
February 13, 2008 at 1:31 pm
Barely. I would doubt it would be visible.
I prefer the .. EXISTS (SELECT <constant> ... format, as it's fairly clear from that that no values are been returned
February 13, 2008 at 1:29 pm
Can you post the code, the schema and indexes on the table and an approx row count please?
February 13, 2008 at 1:26 pm
It is definitely possible. My work machine's set up that way.
Make sure you install SQL 2000 first (perhaps as the default instance) and then 2005 as a named
February 13, 2008 at 1:20 pm
Sugesh Kumar (2/13/2008)
blocking can be avoided using locking hints and isolationlevels.
Or by writing optimal code and ensuring that indexes are appropriate.
February 13, 2008 at 9:18 am
Make sure you're running this in the database that the procs are in. Object_name, when passed one param, looks in the current DB.
If you're running SP2, you can use the...
February 13, 2008 at 9:15 am
There's a massive difference between the statements
Select 1 where exists(select * from dbo.WordIndex where Term='inc')
and
select * from dbo.WordIndex where Term='inc'
Exists is only checking for the existence of a row. It...
February 13, 2008 at 9:10 am
Viewing 15 posts - 47,386 through 47,400 (of 49,571 total)