IE7 enable tabbed browsing

›
You can enable tabbed browsing in Internet Explorer 7 by using a menu command: Tools -> Internet Options -> Tab: settings -> select...
1 comment:

Dynamic transparent color

›
The default value of most color properties is "Transparent". If you want to dynamically set a color property, you can use the IIF-...
1 comment:

Truncate staging tables

›
Before creating a backup of the database, you could clean out all staging tables to safe some space in the backup and to reduce the time it ...

Windows Update fix

›
Sometimes Windows Update gets corrupted. Some of its components or previously downloaded updates get mangled during the download or installa...

Cannot decrypt the symmetric key...

›
Yesterday I got a Windows update of my .Net framework 2.0. After the update the system needed to be rebooted, so I did that. After that, my ...
3 comments:

Return the size of pre-selected tables

›
A stored procedure I use a lot to get a resultset containing the size of a selection of tables in the database: CREATE procedure sp_TableSiz...

Backup to network share

›
You can use the following TSQL statement to backup a database to a network share in SQL Server 2000: BACKUP DATABASE TO DISK = '\\unc\fo...

Concatenating text files

›
Jamie Thomson has a post on concatenating multiple text files (using the ForEach Loop) and subsequently loading this concatenated file in on...
2 comments:

Strange HAVING-clause behaviour

›
Say you want to return a resultset containing the last two days per week. First, construct the demo table: CREATE TABLE TEST_TIME (WEEKCODE ...