Viewing 15 posts - 2,011 through 2,025 (of 3,008 total)
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
Windows Server 2003 supports deframentation of open files, so utilities like DiskKeeper can defragment them while SQL Server is running.
I'm not sure if you would see much improvement in performance.
February 5, 2009 at 9:58 pm
Do you have a question, or is this a trip down memory lane?
February 5, 2009 at 4:51 pm
...Michael Valentine Jones, do you mean account for Agent service, right?...
I mean both accounts. Backup and restore commands run under the SQL Server Service account.
February 4, 2009 at 4:28 pm
Viewing 15 posts - 2,011 through 2,025 (of 3,008 total)