Viewing 15 posts - 2,011 through 2,025 (of 3,011 total)
Sometimes there's just no good substitute for one-on-one, boot-to-butt communication.
I had an exchange like this with a developer recently.
Dev: I need a login created.
Me: Send me an email with Server...
February 17, 2009 at 9:08 pm
*= is a syntax that is obsolete and should not be used. It is not allowed in SQL Server 2005. *= and =* should be replaced with left...
February 16, 2009 at 3:37 pm
Derek Dongray (2/16/2009)
David Webb (2/13/2009)
February 16, 2009 at 3:33 pm
Forget the planes and bonuses. Why exactly should there be any subsidy of companies that are failing at all? Isn’t the whole theory of a market economy that...
February 13, 2009 at 9:29 pm
Roy Ernest (2/13/2009)
Michael Valentine Jones (2/13/2009)
Ninja's_RGR'us (2/13/2009)
... and in the "you're screwed category", the award goes to : http://www.sqlservercentral.com/Forums/Topic656268-357-1.aspx
I don't know about that. Here's a thread with links to...
February 13, 2009 at 3:40 pm
Ninja's_RGR'us (2/13/2009)
... and in the "you're screwed category", the award goes to : http://www.sqlservercentral.com/Forums/Topic656268-357-1.aspx
I don't know about that. Here's a thread with links to about a 100 examples that...
February 13, 2009 at 12:39 pm
venki (2/13/2009)
Greg Charles (2/13/2009)
February 13, 2009 at 12:31 pm
There is no MOD function in SQL Server; % is the modulus operator
select Mod_Test = 100 % 60, VER = left(@@version,60)
Results:
Mod_Test VER
----------- ------------------------------------------------------------
40 ...
February 13, 2009 at 12:28 pm
Vivien Xing (2/13/2009)
My test shows 50% : 50% execution plan cost for these 2 codes...
Execution plan cost is not much of indication of actual performance.
Typically, you would need to test...
February 13, 2009 at 10:32 am
Of course, this SQL 2008 version is probably closer to what you really want.
select
TM,
[Integer...
February 13, 2009 at 7:33 am
Restore from the "just in case" backup of the database that you made just before you ran this restore.
February 12, 2009 at 8:41 pm
select
TM,
[Integer Time To Datetime] =
dateadd(ss,(tm%100)+(((tm/100)%100)*60)+((tm/10000)*3600),0)
from
( -- Test Times
select tm = 91700union all
select tm = 212000union all
select tm = 90200union all
select tm = 1
) a
Results:
TM ...
February 12, 2009 at 3:07 pm
Vivien Xing (2/11/2009)
a bigger one from last year: 100TB+ Scientific VLDBs with SQL Server 2008http://www.softconference.com/pass/sessionDetail.asp?SID=136207
The Pan-STARRS project web site indicates that this database has not yet been implemented, and that...
February 11, 2009 at 10:00 pm
Sakthivel Chidambaram (2/9/2009)
Michael,
260 new users/day is current registration scenario. Any site will have bulk registrations only...
February 9, 2009 at 9:46 am
The 260 new users/day number seems way too low. It would take over 1,300 years to get to 130 million users at that rate.
February 9, 2009 at 8:42 am
Viewing 15 posts - 2,011 through 2,025 (of 3,011 total)