Quick tip: sp_configure and sys.configurations
In order to query the configuration settings of a server you can run this sproc:
exec sp_configureOn a default install of...
2012-05-16
1,116 reads
In order to query the configuration settings of a server you can run this sproc:
exec sp_configureOn a default install of...
2012-05-16
1,116 reads
Replication is one of the more complex of the SQL native “HA/DR” technologies. There are a lot of moving parts....
2012-05-15
2,142 reads
I was working with a group of students on a design brief. The brief was to partially implement a database...
2012-05-10
1,043 reads
This is a very cool and useful tip if you find yourself locked out of the sysadmin role in sql...
2012-04-30
2,657 reads
I came across an issue today where a backup process was in a blocked state with a wait type of...
2012-04-24
613 reads
While researching the steps required to service pack SQL Server on an active active cluster I came across a lot...
2012-04-16
919 reads
A while ago I blogged about instant file initialization. A colleague of mine pointed out that there is a small...
2012-04-16
949 reads
The other day I was asked to restore a production database into a development environment and then check the database...
2012-03-21
890 reads
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
By Zikato
Someone hacked Digitown's municipality and stole classified documents. 45 million rows of router traffic,...
Hello Hello, We. Are. Back! The schedule for EightKB 2026 Edition has been announced!...
Comments posted to this topic are about the item Displaying Money
Comments posted to this topic are about the item The Slow Growing Problems
Comments posted to this topic are about the item Calculating the Harmonic Mean in...
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