Monthly Archives: April 2010

Implementing a custom enumerator for SQL Server TVP

Helpful article by Lenni Lobel. Advertisements

Posted in SQL Server, Table Value Parameter | Leave a comment

How to Size Fill Factor on an Index

Great start and process for determining fill factor by anuchaw.

Posted in SQL Server | Leave a comment

How to Avoid Some Common Developer and DBA Mistakes

Great article by Brad M. McGehee, Director of DBA Education, Red Gate Software Read more:

Posted in SQL Server | Tagged | Leave a comment

VSTS 2008, Assembly Versions and Deployment

Microsoft changed the deployment of  assemblies with Visual Studio 2008. When you created a set up package in VS2005 or lower, the assemblies could have “any” version you wanted. When a user executed the setup package, all previous versions of the … Continue reading

Posted in Visual Studio | Tagged | Leave a comment

Installing Custom Windows Service on Win Server 2008R2

To avoid odd “event log” creation errors or window service installs that seem to go nowhere on a window server 2008 R2 machine (prolly others too), always remember to “run as administrator” with a right mouse click. Spent a good part … Continue reading

Posted in Windows Server 2008, Windows Service | Tagged | Leave a comment

Using SQL Server Timestamp

Well, I googled using timestamp and sql server and while there was some good advice out there, I never saw an example of how to send that value back to sql and compare it.  All the examples showed how to pull … Continue reading

Posted in SQL Server, Timestamp | Tagged , , | 3 Comments