Tagged Questions
1
vote
1answer
22 views
How un-clustered is a CLUSTER USING table
I have some tables which benefit greatly from CLUSTER ON/CLUSTER USING in Postgres. Data accessed at the same time is "defragmented" into a small number of disk blocks:
# CLUSTER table USING ...
3
votes
4answers
318 views
SQL Server - Separating data, log, and TempDB files on a SAN
I have a SQL Server connected to a SAN. Our new storage vendor recommends that all LUNs span the entire disk array, which is RAID5. I would normally request 3 separate LUNs (data, log, and TempDB) ...
2
votes
1answer
44 views
What will happen when a forum uses 24 char length as an URL ID?
I found a forum using self made/custom engine still in beta version, previously using vBulletin.
Now, their new engine uses very long URL id, 24 char length.
...
5
votes
1answer
292 views
MySQL and Solid State Disks on EMC
Since all writes and sequential reads are cached by the EMC storage system, the best use for solid state disk is to store data that has a random READ pattern. On Oracle, that is the temp tablespace ...
3
votes
1answer
124 views
SQL Filegroup degrading performance
On our dev boxes, our database resides entirely in the PRIMARY filegroup, and everything works fine.
On one of our production servers, recently upgraded from 2005 to 2008, we noticed it was ...
