Code, Strings, and Keys

Updates from March, 2008 Toggle Comment Threads | Keyboard Shortcuts

• 

  tech0x20 4:03 pm on March 27, 2008 Permalink | Reply  

  Getting size estimates for tables in SQL SERVER 2000 

  
  -- SQL Server tables and row counts
  
  declare tables_cursor cursor for 
  select name from sysobjects where xtype='U'
  declare @table_name sysname
  
  open tables_cursor
  fetch next from tables_cursor INTO @table_name
  
  while @@fetch_status = 0
  begin
      exec sp_spaceused @table_name
      fetch next from tables_cursor INTO @table_name
  end
  close tables_cursor
  deallocate tables_cursor
  

  Share this:

  • Print
  • Facebook
  • Tumblr
  • Pocket
  • Pinterest
  • LinkedIn
  • Reddit
  • Twitter

  Like this:

  Like Loading...
   

  Leave a Reply Cancel reply
• 

  tech0x20 9:56 am on March 25, 2008 Permalink | Reply  

  Restoredb.bat 

  Using osql and trusted connection for SQL Server 2000.

  @echo off if {%2}=={} ( call :Usage goto :EOF ) net stop mssqlserver net start mssqlserver osql -E -d master -Q "restore database %1 from disk='%2' with replace" goto :EOF ::Subroutine area :Usage @echo Syntax: call restoredb.bat DatabaseName FullDatabaseBackupPath goto :EOF

  Share this:

  • Print
  • Facebook
  • Tumblr
  • Pocket
  • Pinterest
  • LinkedIn
  • Reddit
  • Twitter

  Like this:

  Like Loading...
   
• 

  tech0x20 8:41 pm on March 7, 2008 Permalink | Reply  

  “Playtime” project: Porting Didiwiki to C#.NET 

  I’m hoping to find time to throw at least a quick port of DidiWiki to C#.NET together.

  Reference 1: Creating your own Web Server using C# – This article is from 2001, so there might be a significantly better way of doing things.

  Update: This CodeGuru page looks like a more original version of the same page.

  Reference 2: Didiwiki Source Code that I’ve saved off. Original maintainer is no longer maintaining.

  Share this:

  • Print
  • Facebook
  • Tumblr
  • Pocket
  • Pinterest
  • LinkedIn
  • Reddit
  • Twitter

  Like this:

  Like Loading...