Viewing 15 posts - 151 through 165 (of 212 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...
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...
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...
August 8, 2009 at 9:28 am
I was soo sure sql2005 and sql2008 used the same, and i was so wrong
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...
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,...
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.
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...
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...
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...
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!
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....
July 2, 2009 at 9:05 am
skjoldtc (7/1/2009)
hakan.winther (7/1/2009)
July 2, 2009 at 6:29 am
calgeorge (7/1/2009)
July 2, 2009 at 5:16 am
Elliott (6/30/2009)
Otherwise you are stuck using...
July 1, 2009 at 3:29 am
Viewing 15 posts - 151 through 165 (of 212 total)