Distributed SQL Databases
There are new platforms out there that promise a distributed SQL relational database. Steve talks about a few today.
2021-03-09
397 reads
There are new platforms out there that promise a distributed SQL relational database. Steve talks about a few today.
2021-03-09
397 reads
2020-11-20
124 reads
To scale your SQL Server properly means to make it bigger and better. But what is the best method for 2008?
2009-05-07
2,973 reads
This paper discusses how to use SQL Server 2008 to get great performance as your data warehouse scales up. We present lessons learned during extensive internal data warehouse testing on a 64-core HP Integrity Superdome during the development of the SQL Server 2008 release, and via production experience with large-scale SQL Server customers.
2008-11-14
2,699 reads
Often developers are tasked with not only developing functional code, but also with ensuring that the code they develop scales well and performs in the application environment.
2008-05-09
2,508 reads
By John
AI and ChatGPT are all the rage these days. Seems like around every corner...
By Steve Jones
Next week is the 2024 PASS Data Community Summit in Seattle. I’ll be traveling...
By Steve Jones
bye-over – n. the sheepish casual vibe between two people who’ve shred an emotional...
Comments posted to this topic are about the item PASS Summit Time
I have a backup of full, differential and transaction log setup for our database....
Hello everyone, I hope you can help me. I have a table with measurement...
I have run this on SQL Server 2022 for the Sales database:
ALTER DATABASE Sales SET AUTO_CREATE_STATISTICS ON (INCREMENTAL = ON)I then run this in the Sales database:
USE Sales GO CREATE STATISTICS CustomerStats1 ON dbo.Customer (CustomerKey, EmailAddress) WITH INCREMENTAL = OFFThe dbo.Customer table is partitioned. How are statistics created? See possible answers