Viewing 15 posts - 151 through 165 (of 213 total)
vicers (8/31/2005)
While the syntax for Replicate should be Replicate(character_expression, integer_expression), it shows Replicate(10,' ') in the question, but the expression seems to work too.
Replicate works due...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
August 18, 2009 at 7:40 am
I found it usefull in a large database on a server with many CPU:s and I/0 bottleneck, but now we have replaced it with table compression in SQL server...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
August 16, 2009 at 8:24 am
It is really nice to have a developer edition with all the features that exists in Enterprice, but it is too easy to build a database solution that is not...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
August 8, 2009 at 9:28 am
I was soo sure sql2005 and sql2008 used the same, and i was so wrong
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
August 8, 2009 at 9:16 am
I encountered this issue a couple of month ago and i solved it with the following udf from ASPFAQ.com
CREATE FUNCTION dbo.isReallyNumeric
(
@num...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
August 8, 2009 at 9:12 am
GilaMonster (8/6/2009)
Chris Harshman (8/6/2009)
DUMP is a desupported feature, and Microsoft plans on removing itDump is gone in SQL 2008.
Yes, and have already forgotten the statement, since it has been desuported,...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
August 6, 2009 at 4:20 pm
I just wonder, 77% correct answers but only 24% have answered 8. The result and the question does not make any sense.
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
July 15, 2009 at 7:10 am
Kal Penn (7/9/2007)
Question has the answer.
"You want to deploy SQL Server Compact Edition"
Yes, it is obvious, maybe to obvious to some people who really think you can deploy a...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
July 15, 2009 at 12:48 am
What does BOL say about fragmentation level? My experience is that you should reorganize when you have a fragmentation between >10% and <=30% (rebuild when it is above 30%) as...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
July 13, 2009 at 3:52 pm
sknox (7/10/2009)
"In this case, the number of characters that are returned is the largest value of either the sum...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
July 10, 2009 at 12:16 pm
vitesh.bhana (7/3/2009)
The only thing I know about Independence Day is this huge alien ship hanging over the White House and blowing everything up 😀
Me too!
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
July 7, 2009 at 5:10 am
There are at least two drivers on the market, DataDirect or OpenLink. Remember that you need OLE for ODBC and the ODBC driver from OpenLink, and it is not cheap....
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
July 2, 2009 at 9:05 am
skjoldtc (7/1/2009)
hakan.winther (7/1/2009)
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
July 2, 2009 at 6:29 am
calgeorge (7/1/2009)
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
July 2, 2009 at 5:16 am
Elliott (6/30/2009)
Otherwise you are stuck using...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
July 1, 2009 at 3:29 am
Viewing 15 posts - 151 through 165 (of 213 total)