Click here to Skip to main content
15,896,207 members

The Insider News

   

The Insider News is for breaking IT and Software development news. Post your news, your alerts and your inside scoops. This is an IT news-only forum - all off-topic, non-news posts will be removed. If you wish to ask a programming question please post it here.

Get The Daily Insider direct to your mailbox every day. Subscribe now!

 
GeneralRe: Most SQL users flunk performance test Pin
Rob Grainger25-Feb-14 22:52
Rob Grainger25-Feb-14 22:52 
GeneralRe: Most SQL users flunk performance test Pin
Duncan Edwards Jones26-Feb-14 0:12
professionalDuncan Edwards Jones26-Feb-14 0:12 
GeneralRe: Most SQL users flunk performance test Pin
Rob Grainger26-Feb-14 1:47
Rob Grainger26-Feb-14 1:47 
GeneralRe: Most SQL users flunk performance test Pin
PIEBALDconsult25-Feb-14 12:19
mvePIEBALDconsult25-Feb-14 12:19 
GeneralRe: Most SQL users flunk performance test Pin
Kent Sharkey25-Feb-14 12:20
staffKent Sharkey25-Feb-14 12:20 
GeneralRe: Most SQL users flunk performance test Pin
PIEBALDconsult25-Feb-14 12:48
mvePIEBALDconsult25-Feb-14 12:48 
GeneralRe: Most SQL users flunk performance test Pin
Kent Sharkey25-Feb-14 12:48
staffKent Sharkey25-Feb-14 12:48 
GeneralRe: Most SQL users flunk performance test Pin
Dan Neely26-Feb-14 3:37
Dan Neely26-Feb-14 3:37 
Could someone give an extended explanation for the 5th question? In particular, why can't the DB optimize it by first doing WHERE a = @a over the entire table to get a subset of 100 records and then doing WHERE b = @b over just those hundred? Since the brute force/non-indexed where clause is only being done over ~100 records it shouldn't require a significant amount of time to do.
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, waging all things in the balance of reason?
Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful?
--Zachris Topelius

Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies.
-- Sarah Hoyt

GeneralRe: Most SQL users flunk performance test Pin
Tim Carmichael26-Feb-14 3:57
Tim Carmichael26-Feb-14 3:57 
NewsApple’s reputation for software security a 'myth': expert Pin
Kent Sharkey25-Feb-14 7:42
staffKent Sharkey25-Feb-14 7:42 
GeneralRe: Apple’s reputation for software security a 'myth': expert Pin
Duncan Edwards Jones25-Feb-14 8:29
professionalDuncan Edwards Jones25-Feb-14 8:29 
GeneralRe: Apple’s reputation for software security a 'myth': expert Pin
MacSpudster25-Feb-14 11:12
professionalMacSpudster25-Feb-14 11:12 
GeneralRe: Apple’s reputation for software security a 'myth': expert Pin
MacSpudster25-Feb-14 11:17
professionalMacSpudster25-Feb-14 11:17 
GeneralRe: Apple’s reputation for software security a 'myth': expert Pin
Rob Grainger25-Feb-14 23:02
Rob Grainger25-Feb-14 23:02 
GeneralRe: Apple’s reputation for software security a 'myth': expert Pin
Bernhard Hiller25-Feb-14 23:03
Bernhard Hiller25-Feb-14 23:03 
GeneralRe: Apple’s reputation for software security a 'myth': expert Pin
Rob Grainger25-Feb-14 23:54
Rob Grainger25-Feb-14 23:54 
NewsBlackBerry CEO focuses on a turnaround, but says he'd sell BBM for $19 billion Pin
Kent Sharkey25-Feb-14 7:40
staffKent Sharkey25-Feb-14 7:40 
GeneralRe: BlackBerry CEO focuses on a turnaround, but says he'd sell BBM for $19 billion Pin
Ron Anders25-Feb-14 8:26
Ron Anders25-Feb-14 8:26 
GeneralRe: BlackBerry CEO focuses on a turnaround, but says he'd sell BBM for $19 billion Pin
TheGreatAndPowerfulOz25-Feb-14 8:27
TheGreatAndPowerfulOz25-Feb-14 8:27 
GeneralRe: BlackBerry CEO focuses on a turnaround, but says he'd sell BBM for $19 billion Pin
Kent Sharkey25-Feb-14 8:51
staffKent Sharkey25-Feb-14 8:51 
GeneralRe: BlackBerry CEO focuses on a turnaround, but says he'd sell BBM for $19 billion Pin
TheGreatAndPowerfulOz25-Feb-14 8:52
TheGreatAndPowerfulOz25-Feb-14 8:52 
GeneralRe: BlackBerry CEO focuses on a turnaround, but says he'd sell BBM for $19 billion Pin
Christopher Shields25-Feb-14 9:13
Christopher Shields25-Feb-14 9:13 
GeneralRe: BlackBerry CEO focuses on a turnaround, but says he'd sell BBM for $19 billion Pin
TheGreatAndPowerfulOz25-Feb-14 9:23
TheGreatAndPowerfulOz25-Feb-14 9:23 
GeneralRe: BlackBerry CEO focuses on a turnaround, but says he'd sell BBM for $19 billion Pin
Septimus Hedgehog25-Feb-14 22:24
Septimus Hedgehog25-Feb-14 22:24 
NewsAgile Mastery: Destroy the (False) Deadlines Pin
Nathan Gonzalez24-Feb-14 16:49
Nathan Gonzalez24-Feb-14 16:49 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.