Locks & Latches
Databases, Programming, Operating System, Graphics, Fonts, etc
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 ...
‹
Home
View web version