-
SQL Server Precision And Scale Problems view story
1 vote- Submitted by denis.gobo
- 9 days ago
- (http://blogs.lessthandot.com/inde...)
- Became popular 9 days ago
Many people are confused about SQL Server’s precision and scale. This is unfortunate because choosing the correct values for precision and scale is critically important when you perform math operations using the decimal/numeric data type
-
Less Than Dot - Blog - The Manga Guide to Databases view story
1 vote- Submitted by denis.gobo
- about 1 month ago
- (http://blogs.lessthandot.com/inde...)
- Became popular about 1 month ago
Who comes up with this? Is this a dummies for dummies book? In The Manga Guide to Databases, Tico the fairy teaches the Princess how to simplify her data management. We follow along as they design a relational database, understand the entity-relationship
-
Less Than Dot - Blog - Getting The Percentage Of NULLS And Values In A SQL Server Table view story
1 vote- Submitted by denis.gobo
- 4 months ago
- (http://blogs.lessthandot.com/inde...)
- Became popular 4 months ago
Sometimes you want to know what the percentage is of null values in a table for a Column Or you might want to know what the percentage of all values in a Column is grouped by value You can get these answers by running the code below
-
nHibernate performance against Stored procedures view story
1 vote- Submitted by denis.gobo
- 4 months ago
- (http://blogs.lessthandot.com/inde...)
- Became popular 4 months ago
A 5 part blogpost about the performance of a select statement done with ADO.Net using inline sql, and stored procedures (even some dynamic sql) and then nHibernate to get the same results. But this one has an alternate ending.
-
SQL Server Programming Hacks view story
1 vote- Submitted by denis.gobo
- 5 months ago
- (http://wiki.lessthandot.com/index...)
- Became popular 5 months ago
List of SQL Server programming hacks, tips and tricks
