Monthly Archives: June 2008

SQL Server and blocking investigations: SPID

sp_who and sp_who2 give spids   http://www.devx.com/tips/Tip/13711 http://www.sqlservercentral.com/articles/Administration/63144/       Advertisements

Posted in Uncategorized | Leave a comment

“A Professional Ribbon [control] you will use”

This looks interesting:   http://www.codeproject.com/KB/toolbars/WinFormsRibbon.aspx     also Genetic Algorithm Library (C++) http://www.codeproject.com/KB/recipes/geneticlibrary.aspx  

Posted in Uncategorized | Leave a comment

14 free internet tools to explore

http://www.computerworld.com/action/article.do?command=printArticleBasic&articleId=9101678   although I might suggest Free Download Manager instead of FlashGet

Posted in Uncategorized | Leave a comment

SQL Server Temp Tables (#, ##)

The magic is in the # prefix for local temps, and ## for global temps. CREATE TABLE #Yaks ( YakID int, YakName char(30) ) select name from tempdb..sysobjects where name like ‘#yak%’ drop table #yaks http://www.sqlteam.com/article/temporary-tables

Posted in Uncategorized | Leave a comment

T-SQL: PatIndex is a good thing

http://sqltips.wordpress.com/category/tsql/   Following are the TSQL scripts which you can use to solve these type of problems. You can convert them to user defined functions as per your requirements: —Checks that input only contains numbers if PatIndex(‘%[^0-9]%’,‘11′) > 0BeginPrint ‘Not … Continue reading

Posted in Uncategorized | Leave a comment

Getting a history/list of checkins from VSTS/VSTF

example: tf history /user:timc .\*.sql /recursive

Posted in Uncategorized | Leave a comment

Triggers: make sure to handle multiple rows

http://msdn.microsoft.com/en-us/library/ms190752.aspx   When you write the code for a DML trigger, consider that the statement that causes the trigger to fire can be a single statement that affects multiple rows of data, instead of a single row. This behavior is … Continue reading

Posted in Uncategorized | Leave a comment