Thanks Adriaan. It must be something like that. Maybe memory as well.
The faster system delivered a better result. No index: CPU time 297ms, Execution time 4489ms. Clustered index: CPU time 47ms, Execution time...
No primary key existed. I tried this to see the effect of clustered vs unclustered and the theory failed in this regard. The only conclusion that I...
I couldn't agree more. The problem is that the pc has only one cpu. Can parallellism be executed with only one processor? Maybe different...
Sorry... Here it is: s57507 f49189 e34001 m31242 d29884 i27880 b21521 c19304 a12411 p11834 l7107 v6631 n5943 o5909 g5276 k5025 r4786 t2469 w748...
Hi Adriaan I used: select distinct substring(userid,1,1) from internet and got 21 entries so that pretty much covers the alfabet.
Unclustered index on userid and without clustered index on datetime: CPU time = 541 ms, elapsed time = 12270 ms. which is slower than without the...
I've tried creating a clustered index on say the datetime column (which is probably a better place to use a clustered index) The result is that the...
Hi Adriaan. I'm a bit slow today. Is this the correct formula? 33586 / 338859 * 100 = 9.9% How did you get 24%?
Running the query SELECT T.UserId, COUNT(*) FROM dbo.Internet T GROUP BY T.UserId ORDER BY 2 DESC delivers a result of 905 userid's with the id i'm...
Here is the create command of table: CREATE TABLE [Internet] ( [DateTime] [datetime] NULL , [SourceIP] [varchar] (15) COLLATE...
No, only varchar, int, bigint and datetime. The biggest varchar is 255.
Hi. I have a table with 338859 records. The table has a userid column of type varchar(20) (null enabled). I use the following query: select * from...
Separate names with a comma.
