Viewing 15 posts - 241 through 255 (of 1,132 total)
http://www.tpc.org has various database benchmarks for OLTP and Data warehousing.
TPC-C simulates a complete computing environment where a population of users executes transactions against a database. The benchmark is centered around...
May 18, 2009 at 8:56 am
Andrew Hatfield has described very well what needs to be done when running multiple SQL Server instances on a cluster.
.. you are already using dns aliases to...
May 17, 2009 at 8:01 am
Not sure if this solution meets all of the requirements but it sjhould be close.
SELECTOutage.TransactionAmount
,Outage.TransactionID
,Reversal.TransactionID
FROM(selectTransactionAmount
,ROW_NUMBER ( ) OVER
( PARTITION BY TransactionAmount
ORDER BY TransactionTime )as OutageSequence
,TransactionID
,TransactionTeller ...
May 14, 2009 at 7:12 pm
The Oracle ODBC driver turns off the retrieval of longs by default.
Turn "Force Retrieval of Longs" to on.
May 14, 2009 at 6:34 pm
If the vendor can guarantee a consistent format, then the built-in function REPLACE could be used.
This field will hold a list of Quality Clauses (1, 2, 3, 86, 210, etc...)...
May 14, 2009 at 4:07 pm
Regarding the post referenced at http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/5853c544-42d1-415e-9f65-29b5286fc21e ,can someone post this alternative solution ?
The posed solution specified uses 3,346 ms of CPU time but this solution uses 375 ms.
DECLARE @ChannelIdtinyint
,@Valuefloat
,@BeforeTsdatetime
set@ChannelId =...
May 14, 2009 at 2:08 pm
Please see "Description of support for network database files in SQL Server" at http://support.microsoft.com/kb/304261
Of special interest are:
If you use a non-WHQL qualified storage device that does not support the I/O...
May 14, 2009 at 11:53 am
To add to the list, inappropriate domains and inappropriate physical representation of domains is a common design flaw. A case in point is the msdb jobhistory table.
Inappropriate domain is...
May 8, 2009 at 1:37 pm
Listing the databases only to those accessable by a login is not supported but has been requested.
Title Need VIEW DEFINITION permissions...
May 7, 2009 at 12:23 pm
I wrote a UDF to do Least Squares Linear Regression back in 2001 but the performance was so bad compared to simple SQL that I threw it away. The...
May 5, 2009 at 2:47 pm
Any other reason i could be getting this error?
At least one of the columns in an aggregate has a null in some row. For example, if for any row,...
May 5, 2009 at 6:00 am
Linchi Shea has a recent blog post titled "A Race Condition in the Simple Recovery Mode: Why is my log autogrowing? "
In summary, Linchi conclusion is that the transaction log...
May 5, 2009 at 5:44 am
SQL Server Books Online (BOL) (in its January 2004 version) states that
Values with the DATETIME data type are stored internally by Microsoft SQL Server as two 4-byte integers.
One integer...
May 5, 2009 at 5:35 am
SQL Serve 2005 supports ANSI standard recursive common table element SQL that will explode the hierarchy. Below is the CTE solution and a solution if the RDBMS does not support...
May 3, 2009 at 7:17 pm
It is not possible to be connected to one SQL Server and create an index on a different SQL Server.
It is not possible to be connected to one...
May 2, 2009 at 8:43 am
Viewing 15 posts - 241 through 255 (of 1,132 total)