Scott Elkin

Category: Programming

  • Sql Server Reindex Tables

    During my attempt to shrink my database so that it would fit on my laptop (it was 20 gigs), I figured out that I needed to reindex all my tables.  Usually the format of your data and log files will follow this pattern – just replace the {DATABASE_NAME} with the name of your database. DBCC…

  • Unable to open Web Project Errors

    One thing is consistent for all of us starting out with ASP.NET.

  • Inserting Nulls Into Sql Table

    Countless times I have needed this information, and countless times I can't remember it and have to go searching the net for it. So here it is so Google can search it easily. It is a keyboard hot key to enter a null value in a Sql Enterprise Manager field. Tab to the column and…

  • Performance Counters and Security Exceptions

    If you try to create a Performance Counter in ASP.NET, you will get a happy reply when you run it:System.Security.SecurityException: Requested registry access is not allowed. Simply, the ASPNET account doesn’t have access to the Registry to create them. There are several solutions, but the one I hear most is changing the context the ASPNET…

  • .NET Reflector

    My hardrive crashed 2 days ago, and I lost about 2 weeks worth of source code.

  • Make a Hotkey Macro for Comments in .NET

    I like having comments in the code that shows who did it and when. You can obviously get more complex, but this is good for me. To make your own macro to look like “//SBE 06/04/2004: “, do this: Open Macro Explorer w/in VS.NET. (Tools –> Macros –> Macro Explorer) Create a function like the…

  • CSS vs Tables

    I just read a great article from a designer that actually says what (I feel) everyone thinks but is afraid to say.

  • Using NOLOCK with SELECT statements

    Holy cow! Where have I been living? You can use NOLOCK with SELECT statements to tell SQL to not lock the row/table/page/database.

  • Windows 2003 Search Doesn’t Work

    Ever since I installed Windows Server 2003, the ability to search inside files has sucked.

  • Programming Fonts

    For any code I show on my site, I can display it in several formats. I use ProFont, Proggy Clean and Proggy Square.