Viewing 15 posts - 301 through 315 (of 455 total)
Good article.
Of course, the point you omitted is how the actual probability of any given failure alters the calculations.
With the lottery example, because each of the numbers is (supposedly)...
October 19, 2011 at 8:10 am
The answer is correct but the explanation ("The reason is that the table variable causes a recompilation") is 100% wrong.
The reason the table variable code is so slow is precisely...
October 3, 2011 at 7:44 am
Tony++ (9/22/2011)
I knew that union deduped the sets, but I never thought it through to the logical conclusion that it dedups all rows in...
September 22, 2011 at 7:25 am
Ninja's_RGR'us (9/14/2011)
Gianluca Sartori (9/14/2011)
I guess now I'll have to write it 100 times on the blackboard...It worked with "definitely", so... why not?
country
country
country
country
country
....
😀
Ah the good old day, when techers didn't know...
September 14, 2011 at 8:10 am
Toreador (9/14/2011)
sanbornd (9/14/2011)
How many points do you lose for posting a question with the wrong answer? How about the sum of all the wrong answer.
Good idea.
But how many points should...
September 14, 2011 at 8:03 am
pnewhart (6/23/2011)
September 14, 2011 at 7:44 am
Sudhir Dwivedi (9/12/2011)
45% incorrect answers would imply that it wasn't an easy question! Well done to those who knew the correct answer or, like me, guessed there would be...
September 12, 2011 at 7:29 am
Interesting article. Since you are logging errors, do you have any statistics on how often laptop users disconnect even though they've been sent the e-mail?
In my workplace that would be...
September 12, 2011 at 7:25 am
Kenneth Wymore (9/2/2011)
Nice question. I had to look up evaluation edition because I didn't know how it stacked up with the others.
Generally, evaluation and developer editions have all of the...
September 2, 2011 at 11:02 am
I do a lot of reports from the same datasets. 🙂
But our reporting server is still on 2005. :crying:
But I'm getting a 2008R2 server this month. 😀
August 12, 2011 at 9:08 am
SQLkiwi (8/4/2011)
IsNumeric - sigh.Thank goodness for the improvements in the next version of SQL Server like TRY_CONVERT.
TRY_CONVERT - sigh.
While it's in many ways better than IsNumeric, TRY_CONVERT does have some...
August 4, 2011 at 9:06 am
SQLkiwi (8/2/2011)
bitbucket-25253 (8/1/2011)
DBCC INDEXDEFRAG (Master,"dbo.spt_values",ix2_spt_values_nu_nc)DBCC INDEXDEFRAG (AdventureWorks_regular,"cdc.ddl_history",ddl_history_clustered_idx)-- a system table in the AdventureWorks_regular DB
Neither of those are system tables, they are ordinary tables that happen to be used by the...
August 2, 2011 at 8:01 am
sjimmo (7/25/2011)
July 25, 2011 at 10:38 am
SanDroid (7/25/2011)
sknox (7/25/2011)
SanDroid (7/25/2011)
Precedence has always and will always mater on all versions, flavors, and RDBMS servers that support SQL.True, but that's not the cause of the discussion here.
WRONG. :w00t:
The...
July 25, 2011 at 8:26 am
SanDroid (7/25/2011)
Precedence has always and will always mater on all versions, flavors, and RDBMS servers that support SQL.
True, but that's not the cause of the discussion here.
Precedence and the fact...
July 25, 2011 at 7:52 am
Viewing 15 posts - 301 through 315 (of 455 total)