Viewing 15 posts - 40,606 through 40,620 (of 49,552 total)
Grant Fritchey (3/4/2009)
Can I just add that I think this is the first time I've seen an active blanket party on this site.
I've seen one before. Happened when one...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 4, 2009 at 7:05 am
Santhosh (3/4/2009)
but the requirement is1. to compare two tables
If all you're trying to do is compare two tables, have you considered using the tablediff utility that comes with SQL?
http://msdn.microsoft.com/en-us/library/ms162843(SQL.90).aspx
If...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 4, 2009 at 6:57 am
Post that portion of the error log please?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 4, 2009 at 6:44 am
Mangal Pardeshi (3/4/2009)
I can make out who is asking for right intention and who is just increasing his pots counts.
Can you really?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 4, 2009 at 6:42 am
Krishna (3/4/2009)
Which one will be the victim for the dead lock agent?
Who knows?
The victim is typically the process that is cheaper to roll back. It has nothing to do with...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 4, 2009 at 6:40 am
Check the SQL error log. There should be details in there about what SQL was doing for that time. My guess, there was a rather large transaction that it had...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 4, 2009 at 6:36 am
Jack Corbett (3/4/2009)
The funny thing is I don't ever recall seeing the name on any other posts.
19 threads in total (including the Answered posts one), mostly a single post per...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 4, 2009 at 6:32 am
mail2payan (3/2/2009)
I now declared a trigger, which will update DestinationTable, whenever data is being inserted in MyTable.
Actually, your trigger as written will insert into DestinationTable whenever data is been...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 4, 2009 at 6:27 am
Advertising. Reported to moderator.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 4, 2009 at 6:26 am
graham.boyle (3/4/2009)
I want to run some DBCC checks on a Database in SqlServer 2000
What DBCC checks? There are a lot of DBCC commands. Which one in particular are you talking...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 4, 2009 at 6:25 am
iainthepitman (3/4/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 4, 2009 at 6:21 am
tony (3/4/2009)
CREATE PROCEDURE UPDATE_TABLE_COUNT @NAME VARCHAR, @COUNT INT
Just to explain why. If you define a varchar (or char, nchar, nvarchar, binary, varbinary) without giving a length parameter, the default length...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 4, 2009 at 6:18 am
Mangal Pardeshi (3/4/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 4, 2009 at 6:15 am
saravanantvr1984 (3/4/2009)
Hi dear all,If I give one date like '2008-03-04' i need the result next month last day or date
Not quite sure I understand. Do you need the last day...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 4, 2009 at 6:11 am
Grant Fritchey (3/4/2009)
He may as well be quoting from my posts because I'm "guilty" of all the "crimes" he listed.
Likewise, most of them very recently
But hey, don't take it...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 4, 2009 at 6:05 am
Viewing 15 posts - 40,606 through 40,620 (of 49,552 total)