Posts matching the query string:
My ratings (R) are from 1 to 9. My Dates are also permalinks. Click on the column headers to sort Jots. Feel free to use the address bar like a command line interface by setting the optional query string parameters: Dtm1 (10, 20, 30, YYYYMMDDhhmmss), Dtm2 (YYYYMMDDhhmmss), IsJot (Jot or Not), Tag (zero+ times), NotTag (zero+ times), OrderBy (PostForDate, PostTitle, PostLink, PostText, PostSource, PostRating, PostSize) & Desc(Desc), and Limit(integer).
|20080820 141405 Z||Using XML to Enhance the Performance of String Manipulations||www.sqlserve … icles/XML/63633/||Databases, Microsoft, SQL, TECH, XML||Nice article by Wayne Sheffield on using the XML functionality built into SQL Server to not only create XML, but also to non-XML related large string maniuplations like creating comma separated values (CSV) or parsing CSV. One of the tests improved from a 37.75 minute runtime to a 260 ms runtime!|
|20090309 143121 Z||Blocking Users by IP||www.sqlserve … /Security/66151/||Security, SQL, TECH||Nice little article for SQL Server about using a logon trigger to check the IP address of the login attempt and block it if needed. It's a simple additional security layer.|
|20090410 125648 Z||Changing a Non-IDENTITY column to IDENTITY and vice versa||www.sqlserve … les/T-SQL/61979/||Databases, Microsoft, Programming, SQL, TECH||Maybe useful later.|
|20091116 162049 Z||REPLACE Multiple Spaces with One||www.sqlserve … les/T-SQL/68378/||Beauty, Programming, SQL, TECH||A beautiful elegant solution for a problem that most other folks solve with loops or tables or some ugly row by agonizing row (RBAR) solution.
|20100205 165411 Z||Laying out SQL Code||www.simple-t … utm_campaign=SQL||Programming, SQL, TECH, Writing||Some good points, but it seems like he's having too much fun!|
Page Modified: (Hand noted: 2007-07-19 21:41:10Z) (Auto noted: 2010-12-24 22:08:01Z)