Restore fails with tail of log error
For sql server 2005 and above, When you take a full backup of the FULL recovered database and try to...
2012-03-22
684 reads
For sql server 2005 and above, When you take a full backup of the FULL recovered database and try to...
2012-03-22
684 reads
Sometimes on a heavy loaded server(many databases/connection). You may get an error log when your backup maintenance plan job gets...
2012-03-14
7,288 reads
When you try to connect to sql server using isql/osql or sqlcmd there are two authentication you can use windows...
2012-03-13
533 reads
This is very important to understand what is high availability 9's, This is a measurement of high availability where you can tell...
2012-02-27
719 reads
for sql server 2000 (I know its old) desktop edition does not includes any GUI. so installation of desktop edition...
2012-02-21
2,460 reads
Yesterday we were having discussion on high availability feature Mirroring and Log shipping with my colleagues (Amol & Alankar) on whether...
2012-02-15
486 reads
Find Login in AD
Many times we require to know if particular login is a part of ad user group. Or...
2012-01-29
861 reads
*This is related to physical file size of a MDF or LDF file not internal allocation.
One of our user asked...
2012-01-18
5,245 reads
Good Bye 2011
Hey there, this year is going to an end and just want to recall what all happened this...
2011-12-31
1,291 reads
Basics QA on Extended Event
I am learning Extended Event so this is my first blog on extended event, There is...
2011-12-23
1,788 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