Viewing 15 posts - 16 through 30 (of 38 total)
For the clearest possible confirmation of this answer, see http://support.microsoft.com/kb/967576 which states:
SQL Server maintains the Atomicity, Consistency, Isolation and Durability (ACID) property by using the Write-Ahead Logging (WAL) protocol.
Thank...
September 4, 2013 at 2:29 am
JAZZ Master (7/2/2013)
martin.whitton (7/2/2013)
Danny Ocean (7/1/2013)
July 2, 2013 at 9:28 am
Danny Ocean (7/1/2013)
Good question. But i never feel to use "Bitwise AND" (&) in real working scenario. It will good, if anyone come with some real working example. 🙂
It provides...
July 2, 2013 at 2:47 am
psingla (6/26/2013)
martin.whitton (6/7/2013)
palotaiarpad (6/7/2013)
Whitout running the code it is only a guess.Not strictly true.
"Float" uses binary representations of numbers. Therefore, in this example:
......
It works well when length is 24 or...
June 27, 2013 at 1:47 am
Thank you for your question. I admit I got it wrong, but I've learnt something new.
Incidentally, you state that
[Note: This is for SQL Server 2008 R2 Onwards]
According to msdn,...
June 20, 2013 at 1:46 am
palotaiarpad (6/7/2013)
Whitout running the code it is only a guess.
Not strictly true.
"Float" uses binary representations of numbers. Therefore, in this example:
0.115 translates to 0.000111010111000 in binary
0.075 translates to 0.000100110011001
0.04 translates...
June 7, 2013 at 1:55 am
Quoting from the link Jeff cited:
Because the binary representation of a floating-point number may use one of many legal rounding schemes, it is...
November 19, 2012 at 2:21 am
Just out of interest, I tested the rounding of every float value in the sequence 0.65, 1.65, 2.65, etc up to 99.65 using the following code:
declare
@a float
,@x tinyint;
declare
@tbl...
November 19, 2012 at 1:32 am
I work for a medium-sized company (around 600 employees) where we have never had any formal Change Management.
We have, however, put in a system for automatically recording code changes after...
February 3, 2012 at 2:41 am
Just out of interest, does anyone know what would happen if you did try to create the 32768th database?
Is there an error message for just this occurrence?
And, no, Philip, please...
December 8, 2011 at 2:35 am
I came across this interesting and helpful blog post by one Hugo Kornelis :-).
Hence a double thank you to Hugo for an excellent QotD on MERGE following the ANSI standard,...
November 25, 2011 at 2:41 am
Given the MERGE statement below, which is completely correct for SQL Server 2005 and later
The MERGE statement is only available in SQL Server 2008 and later.
I don't think this has...
November 25, 2011 at 1:39 am
L' Eomot Inversé (11/14/2011)
martin.whitton (11/14/2011)
paul s-306273 (11/14/2011)
......
I don't for a moment imagine that knowing that Chris Date suggested that Heath Normal Form night be a more suitable name than Boyce-Codd...
November 14, 2011 at 3:46 am
paul s-306273 (11/14/2011)
I'd like to say I don't like these questions - but looking at the posts I appear to be in the minority!Anybody else out there with me?
I have...
November 14, 2011 at 3:24 am
Viewing 15 posts - 16 through 30 (of 38 total)