Tags
Author Archives: Clint
Recover database in “Restoring…” mode
Here is the sql to run when your database is in restoring mode. restore database Budgets with recovery You should know why your database is in restoring mode to begin with before running. For me, it’s typically because I left … Continue reading
Posted in SQL
Leave a comment
Approximate total rows in SQL Server database
Here is a script that approximates the total rows in your SQL Server 2005+ database. It’s approximate because it comes off sys tables which are not updated constantly. SELECT [TableName] = so.name, [RowCount] = MAX(si.rows) FROM sysobjects so, sysindexes si … Continue reading
Measure bandwidth between two computers on network
I found this tool called PCATTCP that will measure the speed between two computers on a network. It’s kinda like Iperf but for windows. On the recieving computer you use this: C:> pcattcp -r And on the transmitting computer you … Continue reading
Shout Out: Build Version Increment Add-In Visual Studio
Awesome plugin for Visual Studio. I wanted to automatically increment my version info in YYYY.MM.DD format and this makes it easy. You can find it on the CodePlex site. Just make sure that after you configure it you save your … Continue reading
Alias names in LINQ
Finally figured out how to set alias names in LINQ, and it’s easy. Dim orgs = From p In db.Departments Select p.deporg, Name = p.deporg & " – " & p.depname Order By deporg Name being the name of the … Continue reading