Question : We receive real-time GPS data at a rate of around 5000 pr. minute (from 4 TCP servers). Each […]
Tag: vldb
Managing a SQL Server database with over one terabyte of data [closed]
Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]
Dividing DBCC CHECKDB over multiple days
Question : I’m working on implementing Paul Randal’s method of manually spreading DBCC CHECKDB over several days for very large […]
Database design for handling 1 billion rows and counting
Question : We receive real-time GPS data at a rate of around 5000 pr. minute (from 4 TCP servers). Each […]
Database design for handling 1 billion rows and counting
Question : We receive real-time GPS data at a rate of around 5000 pr. minute (from 4 TCP servers). Each […]
good strategy for big tables and archiving in sql server 2012
Question : I have a table with roughly ~500,000 rows a day getting added into it. The database supports an […]
How do you generate large OLTP and reporting workloads? [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]
Custom index maintenance percentages for a very large table
Question : I’m using Microsoft SQL Server 2016 (SP2-CU12) (KB4536648) – 13.0.5698.0 (X64) Feb 15 2020 01:47:30 Copyright (c) Microsoft […]
Integrity checks on large dbs (700GB)
Question : What’s the best strategy for integrity checks on large dbs? DBCC CHECKDB (DB Name) would probably take over […]