Geeks With Blogs
BizTalk Blog by Chris Han System Design for Enterprise Agility,
SQL Server
Text Editor that can edit special characters such as CR/LF (Notepad++)
Sometimes I just need to search and replace to add the CR/LF at the end of each line. Here's the solution I find from other's post. List here for quick reference: Notepad++. Open your text file in Notepad++. Then navigate to menu View > Show Symbols > Show all characters. Highlight one of those squares in your text, then copy it to clipboard. Press Ctrl+H. Inside "Find what:" textbox, paste (Ctrl+V). Inside "Replace with:", type \r\n In search options, choose "Extended (\r, \n, \t, \0, \x...)". ......

Posted On Monday, October 4, 2010 12:46 PM

A little after lunch game for T-SQL develoepr - how confident are you with your code?
Here is how you should play it: 1. Make sure your have both a SQL 2000 with latest sp and a SQL 2005 database 2. guess the result of the two 'print' command in the script below, write down the last character in the string on your mind 3. Run the script below in SQL 2000 4. Change the 3999 to 3998 and run it again on SQL 2000 5. Change the 3998 back to 3999 and run it on SQL 2005 ---------------------------... declare @n varchar(4000) set @n = replicate(N'z',3999)+N'i' print @n set @n=replace(@n, ......

Posted On Tuesday, October 23, 2007 11:55 AM

Error: System.Data.SqlClient.SqlException: Timeout expired
I got this error when testing my web service POC which is runing on .netFx 2.0: System.Data.SqlClient.SqlEx... Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. I find Angel's article gives the most accurate diagnosis. Check it out here: But the solution he gives out doesn't solve the problem: public void DoesNotLeakConnections() { Using (SqlConnection sqlconnection1 = ......

Posted On Thursday, June 28, 2007 9:49 AM

Is UPS tracking system creating another Y2K problem?
My friend told me this morning, he's little confused with his UPS shipment tracking result. We all know that UPS' using 18 bits tracking number to 'uniquely' identify a shipment. But after I just saw my friend's tracking result page, I'm not sure about the 'unique' part any more. On the 'Package Progress' pane, UPS lists all the history of the shipment associated with the number: Package Progress Location Date Local Time Description BROOKLYN, NY, US 06/25/2007 9:47 A.M. DELIVERY 06/25/2007 7:19 A.M. ......

Posted On Monday, June 25, 2007 11:51 AM

New 'Row-Overflow' feature and the impact to database design in SQL 2005
SQL 2K5 introduces a new behavior row-overflow, which enable the combined row size exceed 8,060 bytes per row limit for varchar, nvarchar, varbinary, sql_variant or CLR user-defined type columns. For more details, check out BOL: What's this mean to the database professionals? Good news for data modelers is you don't have to worry about the error message 'Cannot create a row of size xxxx which is greater than the allowable maximum of 8060' when ......

Posted On Tuesday, February 27, 2007 10:18 AM

Copyright © Chris Han | Powered by: