Rudy Rodarte . com

    • Thanks
    • About
Illustration of a bird flying.
  • Long TRANSACTION Identifier is Long

    Long TRANSACTION Identifier is Long

    If you’re like me, you like using descriptive variable, procedure and function names. Along with those, descriptive transaction names are great, so you know exactly what type of havoc you were throwing at SQL Server. But, if you’re too descriptive, you’ll get the following error: Msg 103, Level 15, State 2, Line 1 The identifier…

    April 26, 2011
  • Rudy: An MCITP Today. Rudy: An MCM Tomorrow?

    Rudy: An MCITP Today. Rudy: An MCM Tomorrow?

    Rudy Rodarte is thinking about taking an MCM immersion class given by the good folks over at http://www.sqlskills.com.

    January 24, 2011
  • Reset an Identity Column in SQL Server

    Reset an Identity Column in SQL Server

    Reset and verify IDENTITY values in SQL Server using DBCC.

    December 8, 2010
  • Determine Tables Sizes in SQL Server

    Everyone is worried about their database size. Even though storage is relatively cheap, if your database is growing linearly or exponentially, you’re going to run into issues down the road. One quick way to check things out is to look at your table sizes. I looked all over the web and found Mitch Sellers’ blog…

    December 1, 2010
  • Use SQL Server DMVs to find a table’s IDENTITY Column

    Use SQL Server DMVs to find a table’s IDENTITY Column. The SQL Server DMVs sys.objects and sys.columns contain valuable information that can identify IDENTITY Columns.

    November 30, 2010
  • Incorrect syntax near ‘GO’ when creating Dynamic SQL

    Incorrect syntax near ‘GO’ when creating Dynamic SQL

    Learn about line breaks when creating dynamic SQL.

    September 20, 2010
  • Remote Desktop won’t go back to Full Screen after Minimization in Windows 7

    Remote Desktop won’t go back to Full Screen after Minimization in Windows 7

    Learn how to get your remote desktop back to full screen after Minimization

    June 29, 2010
←Previous Page
1 … 3 4 5 6 7 … 9
Next Page→

Rudy Rodarte . com

Proudly powered by WordPress