Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options questions only user 83962

Splitting a database table into multiple segments for performance or manageability.

2
votes
1answer
(weekly or daily) might solve the problem. To try this I have a gerneral questions abount partitions. Are there some negative effects of having around 3,000 partitions on a single table? Are there other tips/tricks about partitioning table of this size? …
asked Mar 6 '18 by Steffen Mangold
4
votes
2answers
I have a partitioned table and problems with partition elimination. Setup My table if quite simple and looks like this: CREATE TABLE [data].[OperationData]( [DataLoggerID] [bigint] NOT NULL, …
asked Jun 3 '18 by Steffen Mangold
8
votes
1answer
Setup I have a huge table of ~115,382,254 rows. The table is relatively simple and logs application process operations. CREATE TABLE [data].[OperationData]( [SourceDeciveID] [bigint] NOT NULL, …
asked Nov 28 '18 by Steffen Mangold