I see no SQL Server 2008 Counters in Perfmon?
This problem is a real pain and I’m yet to determine why this issue occurs because my understanding is SQL...
2012-02-21
4,629 reads
This problem is a real pain and I’m yet to determine why this issue occurs because my understanding is SQL...
2012-02-21
4,629 reads
The following trace flags are essential for a variety of recovery scenarios. The use of trace flags allow the DBA...
2012-02-20
1,767 reads
Run the SQL Server Configuration Manager, expand SQL Server Network Configuration and select the protocols for appropriate instance. Double click...
2012-02-18
10,194 reads
To gather statistical information on how a server is performing requires, you need to use operating system tools to gather...
2012-02-16
3,210 reads
Check out my article on SQLServerCentral.com in which I discussed SQL Server 2008 R2 installation setup which you can use to install...
2012-02-14
1,119 reads
Replication often plays an important part in your database management strategy. An organization may use database replication for load balancing,...
2011-12-17
2,272 reads
Microsoft introduced database snapshots with SQL Server 2005. A database snapshot is a static, read-only copy of a source database...
2011-12-17
8,261 reads
As we know xp_fixeddrives can only be use to retrieve normal fixed drives space information. It cannot be used to retrieve information...
2011-12-16
2,049 reads
I’ve started my own SQL blog. Hopefully I’ll write some interesting SQL blog posts here soon.
2011-12-16
535 reads
Hello Hello, We. Are. Back! The schedule for EightKB 2026 Edition has been announced!...
You paste a slow Redshift query plan into PlanTrace and one of the tuning...
By Steve Jones
As part of my running the SQL Saturday charitable foundation, I get sponsorship money...
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