Viewing 15 posts - 19,306 through 19,320 (of 49,552 total)
Usually none.
The idea that subqueries execute once per row of the outer query is wrong in most cases (there are only two cases where that is true). The vast majority...
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
April 6, 2012 at 3:06 am
The answer to most of those can be found in Books Online. The rest with a google search.
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
April 6, 2012 at 3:05 am
Michael Valentine Jones (4/5/2012)
GilaMonster (4/5/2012)
george sibbald (4/5/2012)
where I have added a clustered index to a heap I...
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
April 5, 2012 at 7:15 pm
Conservative Party
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
April 5, 2012 at 7:12 pm
Jan Van der Eecken (4/5/2012)
Lynn Pettis (4/5/2012)
Oh well, no bomb. Back to work.
Darn. I remember back in '79 we had a bomb scare in High School. All 600-odd of...
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
April 5, 2012 at 5:20 pm
You'll have to either remove the processor from the machine or restrict the CPUs in the BIOS (some servers that's possible on, others not). If it can be seen by...
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
April 5, 2012 at 3:21 pm
My question would be why do TOP <x> in an EXISTS when the point of an EXISTS (or NOT EXISTS) is to terminate as soon as it finds a row.
http://sqlinthewild.co.za/index.php/2011/04/05/to-top-or-not-to-top-an-exists/
Count...
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
April 5, 2012 at 2:57 pm
Evil Kraig F (4/5/2012)
Lynn Pettis (4/5/2012)
Unclaimed briefcase in the lobby and now we aren't working. The CSPD Bomb Squad is here to remove the briefcase.
20 years ago, you saw...
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
April 5, 2012 at 2:49 pm
Relying on implicit conversion is never a good idea.
Either convert the time to datetime then add (which is still replying on implied behaviour), or use dateadd and datediff.
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
April 5, 2012 at 1:36 pm
If you restore a backup of your master database you won't need to restore user databases. The restored master will still have the user databases cataloged.
It's when you rebuild master...
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
April 5, 2012 at 1:31 pm
GSquared (4/5/2012)
Stefan Krzywicki (4/5/2012)
Brandie Tarvin (4/5/2012)
I think I'll keep my...
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
April 5, 2012 at 11:37 am
That doesn't necessarily reflect the immediate situation (and no, it could not have read that for the last year, unless your log has been growing for a year)
If means 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
April 5, 2012 at 10:32 am
http://www.sqlservercentral.com/articles/Transaction+Log/72488/
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
April 5, 2012 at 10:21 am
Lynn Pettis (4/5/2012)
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
April 5, 2012 at 10:18 am
sunny.tjk (4/5/2012)
GilaMonster (4/5/2012)
Lots of database snapshots can have a serious impact on data modifications in the source DB. By lots, I don't mean...
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
April 5, 2012 at 9:56 am
Viewing 15 posts - 19,306 through 19,320 (of 49,552 total)