Skip to main content

Denis Gobo's Library tagged database →  View Popular

18 Aug 08

Only In A Database Can You Get 1000% + Improvement By Changing A Few Lines Of Code

Only In A Database Can You Get 1000% + Improvement By Changing A Few Lines Of Code. In this case the query run time went from 24 hours+ to 36 seconds!!!

blogs.lessthandot.com/...database-can-you-get-1000-impr - Preview

programming SQL sqlserver database mssqlserver performance tuning performancetuning

05 Aug 08

Getting The Percentage Of NULLS And Values In A SQL Server Table

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

blogs.lessthandot.com/...title-1 - Preview

sql database sqlserver sql server code programming

28 Jul 08

nHibernate performance against Stored procedures

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.

blogs.lessthandot.com/...-performance-against-stored-pr - Preview

nhibernate ORM SQL database SQLServer

03 Jun 08

SQL Server Programming Hacks

This is a collection of SQL hacks, right now we there are 8 sections and between 70 and 80 hacks.

forum.lessthandot.com/viewtopic.php - Preview

sql programming lessthandot sqlserver hacks wiki microsoft database

1 - 20 of 42 Next › Last »
Showing 20▼ items per page

Selected Tags

Related Tags

Sponsored Links

Ads by Google

Diigo is about better ways to research, share and collaborate on information. Learn more »

Join Diigo