It must be something like that. Maybe memory as well.
The faster system delivered a better result.
CPU time 297ms, Execution time 4489ms.
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...
Here it is:
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...
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.
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.