• SQL 2008 "Features"
While making minor modifications to a table, I would get an error when I tried to save.  To fix, go to Tools->Options->Designers->Table and Database Designers and uncheck the Prevent saving chages that require table re-creation in the Tabel Options Group Box.

IntelliSense cache needs to be manually updated after modifying tables. I discovered this "feature" after adding a rowguid column to a table.  I then tried to run an automated "Select All Rows" query, and intellisense errors apppeared in the query.  I was able to run the query successfully however.  The problem was that the IntelliSense cache needed to be updated.  It did not have the information about the new rowguid column.  To update Intellisense Cache, go to Edit->IntelliSense->Refresh Local Cache (Ctnl+Shift+R).  For more information, check out this link: http://blog.sqlauthority.com/2009/03/31/sql-server-2008-intellisense-does-not-work-enable-intellisense/


  • Here is a link to a to a three part series of articles from Bill Ramos on degugging T-SQL in Microsoft SQL Server 2008.

  • From tip number 56 Tips & Tricks for ASP.NET, IIS, and Visual Web Developer:

    1) From the keyboard: Ctrl+Shift+J will do it.  Wait for "Updating Intellisense..." message on status bar, then try invoking Intellisense again.
    2) From the menu: Select Edit menu, then Intellisense->Update Java Script Intelllisense.  Again, wait for "Updating Intellisense..." message on status bar, then invoke Intellisense. 

  • Want to Learn about PowerShell?  Here is a link to Idera's Practical PowerShell Video Series.

  • From Scott Mitchell's blog, a series of tutorials on ASP.Net Hosting.  http://www.asp.net/learn/hosting/

  • Here is a query to get a row count from each table in your database:

--Get all table names

BEGIN

Select Name into #tableNames from sysobjects where xtype = 'U' order by 1

Create Table #TableCount (TableName Varchar(100), NoOfRowCount bigint)

declare @name varchar(100)

--declare a cursor to loop through all tables

declare cur cursor for select * from #tableNames

open cur

fetch next from cur into @name while @@fetch_status=0

begin

Insert #TableCount

exec ('select ''' + @name + ''' , count(1) from ' + @name)

print 'Fetching count of table : ' + @name

fetch next from cur into @name

end

close cur

deallocate cur

--show the data

Select * from #TableCount drop table #tableNames

drop table #TableCount

END