August 2008 - Keith Rull

Keith Rull

Syndication

News

Badges

Archives

Sort by: Most Recent | Most Viewed | Most Commented

Refreshing views with sp_refreshview

One of the common problems that you would encounter when you are building applications that utilize views is that sometimes there are cases wherein a view gets out of date. This happens when you add a new column to a table a view is refrencing. To fix...

Published 08-19-2008 12:00 PM by keithrull

Filed under: SQL, SQL Tricks, SQL Helpers, SQL Tips, sp_refreshview
sp_recompile is your friend

I've been doing a lot of code deployments lately and I've come across several occasions wherein my stored procedures wouldn't run as fast as expected compared to it's previously known execution time. The problem lies on the statistics...

Published 08-19-2008 11:47 AM by keithrull

Filed under: SQL, sp_recompile, SQL utilities, SQL Tricks, SQL Helpers
How To: Capitalize the first letter of every word in a string

Ever thought of how to capitalize the first letter of every word in a string? Here's how: [C#] using System; using System.Globalization; namespace KeithRull.CapitalizingLetters { internal class Program { static void Main( string [] args) { string...

Published 08-19-2008 10:59 AM by keithrull

Filed under: C#, Tutorial, VB.NET, TextInfo, Tips and Tricks, CultureInfo, Globalization, Localization
Visual Studio 2008 SP1 and .NET 3.5 SP1 out now!!!

Wooohooo!! Get 'em here! Combined Visual Studio 2008 Service Pack 1 and .NET Framework 3.5 Service Pack 1 The update for Visual Studio 2008 SP1 and .NET Framework 3.5 Service Pack 1 in a single install. .NET Framework 3.5 Service Pack 1 The update...

Published 08-11-2008 10:39 AM by keithrull

Filed under: .NET 3.5, Service Pack

August 2008 - Keith Rull

Syndication

Recent Posts

Tags

News

Badges

Archives

Refreshing views with sp_refreshview

sp_recompile is your friend

How To: Capitalize the first letter of every word in a string

Visual Studio 2008 SP1 and .NET 3.5 SP1 out now!!!