Viewing 15 posts - 166 through 180 (of 213 total)
Date is one of the most requested data types and finally MS implemented it in SQL Server 2008 and i love it. The new datatypes are just one of the...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
July 1, 2009 at 12:56 am
I have not tried this tool yet, but if it works as mentioned, then this is what I am looking for. 🙂
I will try this as soon as possible...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
June 30, 2009 at 12:26 am
steve.saunders (6/26/2009)
real is actually a synonym for float(24) which has a precision of only 7 digits.
You are right! Real and float(24) only has a precision of 7 seven digits. The...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
June 28, 2009 at 11:25 pm
SanjayAttray (6/24/2009)
Found answer after some googling. But, this is not related to SQL Server right?
I think it is more related to science then SQL server. When i need to...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
June 25, 2009 at 4:42 am
nice every option is
:-D
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
June 23, 2009 at 6:03 am
Toreador (6/17/2009)
hakan.winther (6/17/2009)
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
June 17, 2009 at 6:51 am
I think this QoD has been discussed enough, dont you agree! We all have different views on this case and let us leave it this way. The poor author of...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
June 17, 2009 at 6:23 am
Hi!
My recommendation is to never use default values because of maintainability. What would happen if MS (I really hope they dont) changes the default value for decimal in this case?...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
June 17, 2009 at 2:27 am
beezell (5/28/2009)
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
June 9, 2009 at 2:01 am
Cliff Jones (6/5/2009)
I don't think any of the answers that include varchar or nvarchar can be correct.But the question provoked an interesting discussion.
I agree, there is an overhead...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
June 9, 2009 at 1:23 am
MarkusB (6/5/2009)
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
June 9, 2009 at 1:19 am
Noel McKinney (5/18/2009)
http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx
I had seen the comparison above and got the question right. However,...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
May 25, 2009 at 1:33 am
I agree that you cannot be 100% sure of what method will be chosen by the SQL optimizer, but in this case the index scan would be much more expensive...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
April 23, 2009 at 2:20 am
Carlo Romagnano (4/23/2009)
I disagree! See the question of yesterday.
I do not understand why you disagree? Do you want to be more specific?
/Håkan Winther
Senior SQL Server DBA
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
April 23, 2009 at 1:10 am
Viewing 15 posts - 166 through 180 (of 213 total)