Viewing 15 posts - 21,241 through 21,255 (of 22,184 total)
The one piece of advice I can give you is to get the Microsoft Upgrade Advisor. This will identify the places where you need work in your existing 2000 database.
January 13, 2008 at 4:27 am
Fourth, assuming that's not homework, if it's proprietary information, you sure shouldn't be posting it willy-nilly on the internet.
January 12, 2008 at 4:38 am
Rereading your description, it sounds like you might be doing RBAR (row-by-agonizing-row) processing. Are you sure the process that you mention that is row-by-row can't be done as a batch?...
January 12, 2008 at 4:31 am
Thanks. His blog seems to be offline right now. I'll check on it later.
I understood that there were few if any fundamental changes, but I just wanted the chance to...
January 11, 2008 at 11:42 am
Oh, sorry. Yeah, I did post the 2005 code. This is the 2005 forum after all. Sorry about that.
January 11, 2008 at 11:38 am
In addition to the suggestion above to use XML and XPath queries, you might look into the XML Bulk loader. It sounds like you've got a perfect place to use...
January 11, 2008 at 11:35 am
Subversion was recommended above. I've used VSS in the past. I'm currently using TFS, Team Foundation System, the new management tool from Microsoft.
Picking the code management tool is the...
January 11, 2008 at 7:21 am
iain lastname (1/11/2008)
I'd also suggest some source control, we use Subversion and it's quite good but there are others.
I'd like to second this suggestion. You should treat the code in...
January 11, 2008 at 6:36 am
Actually, you could also get one of the third party log explorer tools and retrieve the older version of the procedure from the log IF you have your recovery set...
January 11, 2008 at 6:32 am
Not really.
You could restore a previous backup of the database to a different location and retrieve it that way.
January 11, 2008 at 6:30 am
Removing them and readding them will work. You could just run:
DISABLE TRIGGER ALL ON dbo.TableName
Just remember to run:
ENABLE TRIGGER ALL ON dbo.TableName
Otherwise, whatever the trigger does for you... it's not...
January 11, 2008 at 5:39 am
Depending on the data type & how you write the query, the MAX should work too. I've just found that the TOP... ORDER BY works better especially with a clustered...
January 10, 2008 at 1:42 pm
I think that your SQL Server instance is running under the local service account and does not have access to the network. You either have to expose the network to...
January 10, 2008 at 1:06 pm
Below my post is a button that reads "Add Topic"
Click that, fill in the blanks and more people will see the question.
I take it my answer wasn't helpful.
January 10, 2008 at 12:49 pm
Viewing 15 posts - 21,241 through 21,255 (of 22,184 total)