In T-SQL you should use the IS NULL keywords to test for a null value. But David Poole runs into a strange gotcha in one of his applications where he is testing for a null value. It's an interesting read following Sherlock Poole around on his hunt to find an error.
2004-07-14
11,703 reads
Reducing the amount of round trips between a server and client is something that can give you a great boost in performance. David Poole looks at how he solved a problem with HTML checkboxes and the challenges they solve in a programming environment. Without Dynamic SQL!
2004-06-11
9,234 reads
A little off topic (or is it?), David needed to vent a little - something we can all appreciate. Meant to be light hearted fun, please don't take too seriously.
2004-04-19
10,841 reads
I bet most of us count and sum fairly often, but how often do you use the rest of the 'in the box' statistical functions? Learn these now and be ready when you need them.
2004-01-12
27,589 reads
David recently worked on a project where it turned out storing the answers to a survey using bitmapping was a good approach. He was good enough to write some of it down and share. As he notes bitmapping isn't used as often as it used to be, but it can still be a useful technique to have around.
2004-01-06
6,415 reads
David writes about the system he put together to handle addresses and the pros and cons of various techiques. Familiar with Soundex? He uses that too! Even though some of the info is specific to Great Britain, it's good reading. Addresses are one of the hardest pieces of information to handle!
2003-07-01
11,209 reads
David takes us through why he believes trying to run SQL and IIS on the same box is a bad idea. It's a common notion that it IS a bad thing to do, but you have real justification? Read this and you will!
2003-06-20
14,561 reads
David tries his hand at Project Management and what follows is a list of tips and problems from that experience. As David points out, it's interesting to see things from the other (not developer or DBA) point of view.
2003-06-04
5,756 reads
If new objects are created in the model database then these new objects only get created for new databases.Similarly, if objects are removed from user databases then getting them back into the database can be a pain.The following two stored procs copy objects from model to the current database if they do not already exist.
2003-01-10
38 reads
There are times when you have a limited range of ids and these have to be re-used as they become available.The script lists the first missing id in a table.Note that this script works best for a table with a limited number of rows, say sub 100,000I tested this on a PIII 500MHz 256Mb RAM […]
2002-12-09
257 reads
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
You can find all the session materials for the presentation “Indexing for Dummies” that...
Comments posted to this topic are about the item Technological Dinosaurs or Social Dinosaurs?
Comments posted to this topic are about the item DBCC CHECKIDENT
Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...
What is returned as a result set when I run this command without a new seed value?
See possible answers