Viewing 15 posts - 36,766 through 36,780 (of 49,552 total)
Mike McQueen (8/27/2009)
If I ever discover the technology and/or power to suck information from another's brain, yours way up there in my list of brains 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
August 27, 2009 at 1:30 pm
I said not by adding a cursor or a while loop.
Think of what you need to do to the resultset as a whole, not one row at a time. 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
August 27, 2009 at 1:05 pm
Is this SQL 2000 or 2008, seeing as you posted in both forums?
Before getting to the syntax error, there's a major design error in your trigger. Triggers are fired once...
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
August 27, 2009 at 12:38 pm
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic778571-8-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
August 27, 2009 at 12:35 pm
Lynn Pettis (8/27/2009)
Now to this one. This individual really needs to figure out how to open and read BOL.
Agreed. I'm getting a little tired of his very basic, no...
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
August 27, 2009 at 12:02 pm
If not, start with this, and check out the blog posts it links to as well.
http://sqlinthewild.co.za/index.php/2007/12/30/execution-plan-operations-joins/
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
August 27, 2009 at 11:59 am
Lynn Pettis (8/27/2009)
GilaMonster (8/27/2009)
I love these kinds of questions. http://www.sqlservercentral.com/Forums/Topic778499-146-1.aspxMaybe I'll elaborate later on what it depends on...
Personally, looks like a good reseearch topic for some one. I'd just...
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
August 27, 2009 at 11:40 am
Yes, it's nuts, unless you've verified that the NAS supports write order preservation and write-through guarantees
http://support.microsoft.com/kb/304261
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
August 27, 2009 at 11:36 am
Query sys.databases (use sysdatabases and the DATABASEPROPERTYEX function on SQL 2000 and below)
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
August 27, 2009 at 11:33 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic778508-146-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
August 27, 2009 at 11:32 am
I love these kinds of questions. http://www.sqlservercentral.com/Forums/Topic778499-146-1.aspx
Maybe I'll elaborate later on what it depends on...
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
August 27, 2009 at 11:25 am
Yup, but that's only for errors in sys.sql_dependencies. Fixing this kind of error if it's in sys.objects or any other system table is a massive amount harder.
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
August 27, 2009 at 11:24 am
Did you listen to the podcast I recommended?
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
August 27, 2009 at 11:23 am
It depends.
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
August 27, 2009 at 11:22 am
From what I can tell it's deleted 4 rows from the table (a heap, if I'm not mistaken) and their corresponding off-row (lob columns or row overflow) data.
These are the...
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
August 27, 2009 at 10:38 am
Viewing 15 posts - 36,766 through 36,780 (of 49,552 total)