Browse by Tags
All Tags »
Database (RSS)
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
Read More...
[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
Read More...
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
Read More...
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
Read More...
