Viewing 15 posts - 32,626 through 32,640 (of 39,914 total)
Do you know when things changed? If so, you might be able to correct out some of the other data.
If you change the Windows system time, the SQL Server time...
March 13, 2007 at 4:32 pm
March 13, 2007 at 4:27 pm
Have you compared query plans on something that performs differently?
March 13, 2007 at 7:43 am
I think you want to manage schema changes so if you need to restore old information, you're covered.
Any scheme you come up with will have the possibilty of error. Or...
March 13, 2007 at 7:41 am
Wouldn't you need a placeholder for the first column in Excel?
SQL doesn't have the concept of a record, so finding the 2nd, 3rd, etc. occurrance is difficult. I'm not sure...
March 13, 2007 at 7:36 am
Is this an ASP error or a SQL error? You can grab information like @@error, @@error_description, etc. and send it back to the client from a stored proc.
If this is...
March 13, 2007 at 7:19 am
I agree with Scott on the function thing. I'd use a function as it would work well and I'd put the time zones in a table. You can use UTC...
March 13, 2007 at 7:17 am
check the filesystem or tape logs as well.
March 13, 2007 at 7:13 am
I'm not 100% sure, but I guess all DML statements are checked against triggers to see if they match. However the check doesn't create any load. If it does on...
March 13, 2007 at 7:11 am
Since you're working cross platform, I'd recommend calling Microsoft PSS and having them work with you.
Are there any other errors that are occurring? Is it always in the same types...
March 13, 2007 at 7:11 am
Very strange. HAve you run DBCCs on them? Any issues accessing them once they are open?
If you try to access one before it's started, does it work?
March 13, 2007 at 7:08 am
I'd suggest some logging as well. Create a table to store IDs or PKs or just varchar data, then insert data at various points in the table to determine what...
March 13, 2007 at 6:50 am
The new KB article is for 2000 and I should have called that out, though I think it's still a bad programming problem.
I agree with Ed that regular SPs would...
March 13, 2007 at 6:39 am
I think SQL Server developers have more jobs because there are typically more of them than DBAs. However BI/warehousing is a place where I am seeing more growth.
March 12, 2007 at 3:58 pm
I've heard Vista is "usable" with 1GB. Luckily I've got 2GB sitting around ![]()
March 11, 2007 at 8:14 am
Viewing 15 posts - 32,626 through 32,640 (of 39,914 total)