Viewing 15 posts - 35,581 through 35,595 (of 49,552 total)
Anyone feel like tackling this? I do not have the free time today to give it the attention it looks like it needs
http://www.sqlservercentral.com/Forums/Topic826285-1291-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
November 30, 2009 at 9:24 pm
Sherri Barkley (11/30/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
November 30, 2009 at 9:22 pm
The best fix for this is to restore from backup. Don't try and restore then DTS stuff around. The system tables are not to be messed around with in 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
November 30, 2009 at 9:34 am
dzordz_parowkowy (11/30/2009)
but I got error message:Msg 208, Level 16, State 1, Line 4
Invalid object name 'inserted'.
What can be the reason?
Because inserted is only visible in the trigger itself, not in...
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
November 30, 2009 at 9:23 am
Sample data and expected results please. Also, the definition of the cursor (and whatever table it's based on).
As it is, I can't test on my own machine and get you...
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
November 30, 2009 at 9:21 am
Not sure how knowing VB or C# will help in troubleshooting SQL.
So this is for SSIS, not SQL itself? If so, I'll ask the mod to move the thread...
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
November 30, 2009 at 9:16 am
You mean to write front-end apps to interface with SQL?
If you're not familiar with the language I'd suggest a good 'beginner's guide to..' type book.
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
November 30, 2009 at 9:09 am
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
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
November 30, 2009 at 9:08 am
Steve Jones - Editor (11/30/2009)
As Bru mentioned, you haven't joined TableA
It is joined, just the ON clauses are missing
DELETE FROM a -- table to be deleted from
FROM ATable...
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
November 30, 2009 at 9:04 am
A delete can only affect a single table. It will affect the table that's specified straight after the DELETE [FROM]. Any tables after the second FROM are just used to...
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
November 30, 2009 at 8:15 am
RGDavis396 (11/30/2009)
Searches against string values tend to be slower than those against numerical values
Have you tested against large volumes of data under load? If so, are you seeing a measurable,...
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
November 30, 2009 at 8:09 am
--check if record already exists.
IF NOT EXISTS (SELECT ID FROM TableOne WHERE Col1 = @var1 )
BEGIN
IF @var2 = 1
...
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
November 30, 2009 at 7:35 am
GSquared (11/30/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
November 30, 2009 at 7:33 am
Piotr.Rodak (11/30/2009)
Well, if the database is offline you can't connect to it, so why would you want to write anything to it?
The insert is in the ELSE portion, ie...
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
November 30, 2009 at 7:24 am
Give us some background on what happened before this error appeared.
Is the log file there? If not, do you know what happened to 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
November 30, 2009 at 6:43 am
Viewing 15 posts - 35,581 through 35,595 (of 49,552 total)