While working with DropBox today, I created shared links to a file, and the links looked like this:
This link goes to a nice DropBox web page that provides a lot of information — information that would confuse a less-sophisticated user. Why can’t we just get them right to the download?
You can. In the DropBox shared file link, change the “dl=0” at the end of the URL to “dl-1”.
So the same URL above as a direct download would be:
It’s always fun hacking URLs!
Exception handling in .Net (and other languages) is very powerful – and I’ve often seen it misused. Here are my six rules for exception handling. Continue reading
All databases on one SQL instance shares only one tempdb. System internal processing (such as sorting) also uses tempdb. Excessive usage of temporary tables incurs heavy traffic to tempdb and the underlying disc I/O.
Consider the following when using temporary tables. Continue reading
There are three ways to create temporary tables:
create table #temp ( mycol int );
create table ##temp ( mycol int );
create table tempdb.dbo.temp ( mycol int );
What is the difference between those three techniques? Continue reading
Table hints are statements which instruct SQL to use specific locking methods or indexes when optimizing a query. One of the most common table hints is NOLOCK (or, its equivalent, READUNCOMMITTED), which I have sometimes seen used so extensively that it is as common as the table name itself. Continue reading