Simple Script to Report Tables Sizes in a SQL2K Database
Last week we had an issue with a database growing unexpectedly. The
database in question supported an infrastructure type 3rd party
application...
2006-01-04
1,344 reads
Blog Posts
Philosophy on Soldiering
This is taken from the book About Face:The Odyssey of an American Warrior.
The author is Col. David "Hack" Hackworth, one...
2006-01-01
1,414 reads
The Perils of Java Schools
This is great, another rant from Joel, this time on the state of CS Degrees.
I didn't grow up in the...
2005-12-30
1,602 reads
Unpatched Microsoft Windows WMF Vulnerability
If you haven't heard by now, there is an unpatched exploit in how
Windows handles WMF files. Since this handling is...
2005-12-28
1,435 reads
Last Minute Testing
I've had a new web server for a couple months and I've been slowly testing things as I can in...
2005-12-28
1,369 reads
Cute comic
My son ran across this comic and was sure I would enjoy it: http://www.qwantz.com/index.pl?comic=153
2005-12-23
1,567 reads
Aggregate queries
Be sure to read my article on SQLServerCentral on building aggregate queries: http://www.sqlservercentral.com/columnists/kKellenberger/aggregatequeries.asp
2005-12-21
1,577 reads
SQL Server Connections
I found out today that I will get to attend the SQL Server Magazine Connections conference (part of the DevConnections...
2005-12-21
1,405 reads
SQL Server 2005 Administrator's Pocket Consultant available
Saw this at the book store this evening and picked it up.
SQL Server 2005 Administrator's Pocket Consultant
I'll spend the...
2005-12-18
1,495 reads
Salary Survey
SQL Server Magazine has just published its annual salary survey. I don’t really recall how they did it in past...
2005-12-17
1,548 reads
Blogs
Finally Cleaning Up Dropbox: Moving Almost a TB to Google Drive with rclone
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
KDA: Echoes of Deception - Case 4
By Zikato
Someone hacked Digitown's municipality and stole classified documents. 45 million rows of router traffic,...
EightKB 2026 – Schedule and Registration
Hello Hello, We. Are. Back! The schedule for EightKB 2026 Edition has been announced!...
Forums
identity increments by 10,000 when it was supposed to be 1
hi a peer of mine who ive never known to be wrong says a...
Displaying Money
Comments posted to this topic are about the item Displaying Money
The Slow Growing Problems
Comments posted to this topic are about the item The Slow Growing Problems
Question of the Day
Displaying Money
I want to get the currency sign displayed with my amount stored in a money type. Does this work?
DECLARE @Amount MONEY; SET @Amount = '?1500'; SELECT CAST( @Amount AS VARCHAR(30)) AS EurosSee possible answers