Viewing 15 posts - 40,591 through 40,605 (of 49,552 total)
mail2payan (3/4/2009)
Which columns determine the matching row in DestinationTable?
Sorry, I did not get this question.
When rows are inserted into MyTable, the matching rows in DestinationTable are updated with cumulative totoals....
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 9:07 am
Mangal Pardeshi (3/4/2009)
Ahh, thank very much Gila for asking this question.
If I suggested that a number of the top posters there were useless, would I really get those same top...
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 8:56 am
Roy Ernest (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 8:51 am
Grant Fritchey (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 8:42 am
Ok, so on insert, a row must be inserted into Destination table if it doesn't exist and updated if it does? Which columns determine the matching row in DestinationTable?
What must...
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 8:40 am
Mangal Pardeshi (3/4/2009)
Those were my general comments about forums offenders
Tell me, if I were to drop into the MSDN forums (which seems to be your primary haunt) as a...
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 8:31 am
mail2payan (3/4/2009)
Hope, I can make you understand where is my problem??
Not quite. What should happen when a row is inserted into MyTable? What should happen when that row is updated?
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 8:17 am
Is this SQL Express?
Have a look at this discussion:
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:50 am
Kit G (3/4/2009)
Looks like Mangal deleted some of his posts as they are only now recorded in the quotes other posters used.
I hate it when people do that.
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:42 am
Same as any complex code. Deconstruct (or build it) piece by piece.
Broken down for explanation only:
DECLARE @dt datetime
SET@dt = '2009/03/04'
DECLARE @TwoMonthsFromNow DATETIME
DECLARE @StartOfMonthAfterNext DATETIME
DECLARE @EndOfNextMonth DATETIME
SET @TwoMonthsFromNow = DATEADD(mm,2,@dt)
SET @StartOfMonthAfterNext...
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:36 am
There's not much written about it anywhere that I've found, (other than in BoL) and I've been told that it can change between versions.
If you want to control which is...
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:31 am
If the request is indeed for the last day of the following month, rather use this. Manipulating datetime using Dateadd and datediff is notably faster than converting pieces to string,...
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:19 am
As text please. There's an entry there that says "SQL resumed execution after... Reason:" but it's cut off.
The error log's just a text file. You can open it in notepad...
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:16 am
Chris Morris (3/4/2009)
..you're not going to ask the business reason then? 😉
Free beer means no questions asked.
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:13 am
GSquared (3/4/2009)
Has that thread been deleted?
Not yet
http://www.sqlservercentral.com/Forums/Topic666402-4-1.aspx
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:07 am
Viewing 15 posts - 40,591 through 40,605 (of 49,552 total)