Viewing 15 posts - 16 through 30 (of 241 total)
In the meantime 123883 tables (yes 30 new tables got added) the total recordcount is
89,372,968,620
ChrisM@Work (11/3/2015)and how is this lot typically interrogated?
I wish I knew but I'm frequently being told...
November 3, 2015 at 7:26 am
ChrisM@Work (11/3/2015)
Resender (11/3/2015)
Those tables are the same
[MachineRegisterId] [int] NOT NULL,
[UtcTime] [datetime] NOT NULL,
[Value] [float] NOT NULL
With primary key on the combination...
November 3, 2015 at 6:16 am
Total number of machine tables (3/11/2015 13:44 CET) 123851
Those tables are the same
[MachineRegisterId] [int] NOT NULL,
[UtcTime] [datetime] NOT NULL,
[Value] [float] NOT NULL
With primary key on the combination of MachineRegisterId...
November 3, 2015 at 5:46 am
OK, not so good news then,the total size of the database currently is 1.9TB
November 3, 2015 at 4:59 am
Before proceeding any further,
ChrisM@Work (10/30/2015)how many rows are in the table?
The largest table contains above 1.5 million records,the smallest about 16, and their hundreds on hundreds that are currently empty.
ChrisM@Work...
November 3, 2015 at 3:52 am
OK,txn that resolved,strangly enough the account that works did not work 6 months ago & nothing changed about its permissions
November 3, 2015 at 3:17 am
That's the rowcount the query gave as for whether it's correct that will have to wait thill next week as I'm rather busy today again to check if they match.
October 23, 2015 at 6:40 am
ok ounce sorry for the late response busy,busy,busy
Latest version
07:16
#Records 45193
Attached the actual execution plan.
October 23, 2015 at 6:20 am
Microsoft SQL Server Management Studio10.50.1617.0
Microsoft Data Access Components (MDAC)6.1.7601.17514
Microsoft MSXML3.0 4.0 5.0 6.0
Microsoft Internet Explorer9.11.9600.18059
Microsoft .NET Framework2.0.50727.5485
Operating System6.1.7601
October 23, 2015 at 6:08 am
I'm currently doing a 7AM to 4PM shift.
I might be missing something
Msg 4104, Level 16, State 1, Line 16
The multi-part identifier "x.Server" could not be bound.
Msg 4104, Level 16, State...
October 22, 2015 at 2:00 am
Good morning,hope the trafic in the skies were not bad this morning
(for anyone reading this in the "future" the day I'm posting this is October 22th 2015, a day after...
October 22, 2015 at 1:01 am
Roads, where we are going we don't need roads.
October 21, 2015 at 8:15 am
no problem,making errors is in human nature,I'm however at the end of my workday and I carpool to work so I don't have time to start the new query I'll...
October 21, 2015 at 8:09 am
Execution results
--distinct
13:12
108054
--no distinct
17:19
4919706
Rapid glamps shows same data but a lot of duplicates which I suspected.
I've included the actual execution plans, so far I'm happy the time is more then halved...
October 21, 2015 at 7:48 am
Ok sorry for the late answer I did not have time yesterday to pursue this.
Here are the actual execution plans for both versions.
I have created 1 clustered index in the...
October 21, 2015 at 5:48 am
Viewing 15 posts - 16 through 30 (of 241 total)