Rexiology@MSDN

Nothing but Microsoft Technologies...

Browse by Tags

Tagged Content List
  • Blog Post: SQL Server 2008 RTMed!!

    for the long waiting, at 8/6 PST time, SQL Server 2008 finally RTMed! checkout press release here: http://www.microsoft.com/presspass/press/2008/aug08/08-06SQLServer2008PR.mspx download place here: http://msdn.microsoft.com/en-us/sqlserver/default.aspx product samples available at CodePlex (via reedme...
  • Blog Post: Forcefully detach mdf file in SQL Express...

    [via http://www.mssqlonline.com/?p=14 ] when you want to force a detach of sqlexpress mdf file, while there are still other processes currently using it (or normally when there were still connections remain in the connection pool), you can use the following sqlcmd script to force a process kill and then...
  • Blog Post: asp.net: checking session size in SQL Server ASPState DB...

    by setting asp.net application to save session state into SQL Server database, not only can scale application out with multiple web servers, but also provided a way to investigate session usage. Saving session state in SQL Server database will be slower than InProc session state, since it requires Serialization...
  • Blog Post: T-SQL: Convert Hex String to VarBinary...

    Here is some conversion functions in SQL Server... To convert between int and hex values, by referring to this post : SELECT 'Int -> Hex' SELECT CONVERT(VARBINARY(8), 16777215) SELECT 'Hex -> Int' SELECT CONVERT(INT, 0xFFFFFF) To convert a VarBinary to a HexString, by referring to Peter DeBetta...
Page 1 of 1 (4 items)