I was working on a virtual test server with a very small (7Gb) C: drive, and the monitors were throwing…
Category: SQL Server
Things I learned or discovered with SQL, including useful scripts
SQL Server, Integrated Authentication, and “To Tell the Truth”
Moderator: “Login number one, what is your identity?” Number one: “I am known as jsmith” Moderator: “Login number two, what…
The lost art of break and continue
Warning: WP_Syntax::substituteToken(): Argument #1 ($match) must be passed by reference, value given in /home/nzzqfted/public_html/blog/wp-content/plugins/wp-syntax/wp-syntax.php on line 380
Warning: WP_Syntax::substituteToken(): Argument #1 ($match) must be passed by reference, value given in /home/nzzqfted/public_html/blog/wp-content/plugins/wp-syntax/wp-syntax.php on line 380
BREAK and CONTINUE are two forms of loop control, which I have seen under-used lately. I think it is time…
Anti-Collision Work Queue Retrieval: an approach using GUIDs
Warning: WP_Syntax::substituteToken(): Argument #1 ($match) must be passed by reference, value given in /home/nzzqfted/public_html/blog/wp-content/plugins/wp-syntax/wp-syntax.php on line 380
Warning: WP_Syntax::substituteToken(): Argument #1 ($match) must be passed by reference, value given in /home/nzzqfted/public_html/blog/wp-content/plugins/wp-syntax/wp-syntax.php on line 380
I recently wrote a high-volume, fast paced application which supports many threads reaching into a work queue (SQL table) and…
Triggers in SQL Server: how often are they called
Warning: WP_Syntax::substituteToken(): Argument #1 ($match) must be passed by reference, value given in /home/nzzqfted/public_html/blog/wp-content/plugins/wp-syntax/wp-syntax.php on line 380
Warning: WP_Syntax::substituteToken(): Argument #1 ($match) must be passed by reference, value given in /home/nzzqfted/public_html/blog/wp-content/plugins/wp-syntax/wp-syntax.php on line 380
Warning: WP_Syntax::substituteToken(): Argument #1 ($match) must be passed by reference, value given in /home/nzzqfted/public_html/blog/wp-content/plugins/wp-syntax/wp-syntax.php on line 380
Warning: WP_Syntax::substituteToken(): Argument #1 ($match) must be passed by reference, value given in /home/nzzqfted/public_html/blog/wp-content/plugins/wp-syntax/wp-syntax.php on line 380
Warning: WP_Syntax::substituteToken(): Argument #1 ($match) must be passed by reference, value given in /home/nzzqfted/public_html/blog/wp-content/plugins/wp-syntax/wp-syntax.php on line 380
Our dba and I had a short discussion on triggers, because I could not locate an answer to this question:…