Viewing 15 posts - 1 through 15 (of 52 total)
Buy a copy of SQL Data Compare - it will compare data in any number of tables on the same server or separate servers and create a script to sync...
July 22, 2008 at 2:39 pm
You may also want to take a look at the error trapping
EXEC (@sql)
SELECT @sql =''
SET @intErrorCode=@@error
In the above instance, @@error...
July 15, 2008 at 5:34 pm
I can't speak to the Apex tool but I have been using SQL Compare for the last 2 years - it has saved me hours and hours of work -...
July 14, 2008 at 3:30 pm
Thanks for the sample code and excellent explanation.
Regards,
Harley
May 9, 2008 at 12:49 pm
GSquared,
Can you give me an idea what the SP dbo.Error_CatchCommon contains?
Thanks,
Harley
May 8, 2008 at 4:23 pm
Steve,
The plans are very different - index seek on xDate in both - then loop join to TableB - then
> the poor plan scans TableC and shows 77M records...
December 3, 2007 at 5:02 pm
Steve,
Dates from mid-Nov back all behave the same and seem to operate properly when run either way - the more recent dates are subject to the odd pattern - the...
December 3, 2007 at 1:06 pm
Another vote for SQL Compare - very fast and accurate - well worth the cover charge!
Regards,
Harley
July 27, 2007 at 5:35 pm
Steve and Redd,
Thanks for the well thought-out responses. Given the supporting apps running on the server, and the lack of an ability to do meaningful comparisons of various configs, it sounds...
July 2, 2007 at 5:01 pm
Edogg,
Thanks for the response - actually, the service company recommended lowering the SQL max to 12GB to leave 4 for the OS and other apps noted above - again, I'm...
June 29, 2007 at 11:35 am
Alan,
One way to handle it is with a UDF - thanks to whoever posted this -
CREATE FUNCTION fn_ConcatStrings
(@ID int)
RETURNS varchar(500)
AS
BEGIN
declare @String varchar(500)
select @String = coalesce(@String,'') + Col +...
June 28, 2007 at 10:54 am
Thanks for the responses - the change was made without any supporting metrics - it was based on a blanket statement by an admin that 2003 in a clustered environment will...
June 28, 2007 at 9:53 am
Wayne,
I have great sympathy - I work as DBA for a large financial institution where data security is a high priority. I have read-only access to PROD data but no...
June 20, 2007 at 11:01 am
SQLGuru,
I agree with your thought - bouncing SQL seemed to remove it from the list of suspects...and no, I have no access to the box at all - except through the...
June 13, 2007 at 10:37 am
The only time I have seen a sev 19 error was once when we had disk controller problems on the SAN.......you can try rebooting, run diagnostics on the drives and then...
June 12, 2007 at 3:29 pm
Viewing 15 posts - 1 through 15 (of 52 total)