The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
1answer
90 views

Slow MSSQL on DB (~2TB) - Index / fragmentation?

I have a fairly large MS SQL database (~2TB). Most of the data is in one table (~6 billion rows). Two weeks ago I dropped two non-clustered indexes on the large table and migrated the data onto a ...
2
votes
2answers
212 views

Find MySQL indexes without cardinality

I've recently found a few queries in my slow query log that should have been using indexes. When investigating the indexes in phpmyadmin it shows a null or empty cardinality. I'm unsure what causes ...
-2
votes
1answer
23 views

suppress viewing indexes - apache [closed]

Does this syntax prevent indexes to be visable in var/www? <Directory "/var/www"> Options FollowSymLinks AllowOverride All Order allow,deny Allow from all </Directory> or ...
2
votes
1answer
182 views

Why is “Options Includes Indexes” Enabled by Default in Apache?

I was curious as to why Options Includes Indexes is generally enabled by default in Apache configurations. Anyone know why this is, as it's generally frowned upon for security reasons?
0
votes
1answer
5k views

How to create non-clustered indexes on a SQL Server 2008 database? Preferably without code?

I would appreciate help on how to create non-clustered indexes on a SQL Server 2008 database without using code--or rather, 'statically' once and for all prior to running any SQL queries (that ...
0
votes
2answers
368 views

Apache Options -Indexes give me 404 instead of 403, why?

I have an Apache/2.2.21 (Debian) webserver, which I disabled directory listing with Options -Indexes but now I got 404 error for a directory, but I think I should get a 403. I have no idea why I get ...
0
votes
1answer
2k views

Rails program is not being run on apache + passenger - only directory listing

I have successfully installed Phusion passenger + Apache 2 + Rails 3.1 program + git on a linux Debian 6. I ran passenger-install-apache2-module and followed the configuration instructions. I followed ...
0
votes
1answer
267 views

Apache (with Nginx) redirects on directory listing

I have setup Nginx as a reverse proxy in front of Apache. Everything seems to be working fine, although: When i try to access an index-file (say index.php) but without specifying the file itself, and ...
1
vote
2answers
130 views

sys.dm_db_missing_index_stats reports existing index

I'm confused by the results that I'm getting from sys.dm_db_missing_index_stats ... The following query returns missing indexes that are actually created on the tables. select * from ...
1
vote
2answers
248 views

Should I implement all “missing index” suggestions?

Running the SQL Server Performance Dashboard Reports (nice name) gives lots of suggestions for missing indexes in my DB. Should I implement all of these uncritically? Or should I "sort" them somehow ...
0
votes
1answer
46 views

Why did my newly added index show up as a 'statistic'?

We are attempting to tune our SQL Server 2005 database as we frankly have no indexing on our tables and our CPU usage is starting to max out at 100%. We have ran SQL Server profiler for a 3 hour ...
0
votes
1answer
262 views

Creating indexes on tables filled from transactional replication - SQL 2005

I've got two SQL 2005 servers, one OLTP [let's call it SQLA] and one used for reporting [SQLB] to reduce load on SQLA when people run crazy queries. Our main database is replicated from SQLA to SQLB ...
1
vote
3answers
321 views

Duplicate primary keys in MySQL table due to DoS attack

We have a MySQL database with duplicate primary key index entries as a result of a DoS attack. The duplicates cannot be found by selects on the ID (it will only show one row, not two), but if you ...
0
votes
2answers
520 views

How to list all indexes/constraints/FKs in a MySQL Database from commandline

Is it possible, from the MySQL command line, to list in a single query all the indexes/constraints/FKs etc that are in the database in question? Thanks in advance Rich
1
vote
2answers
279 views

Will deleting old MySQL data improve performance?

Would deleting old data from my tables improve MySQL query performance? When my queries use indexes? When my queries don't use indexes? When I use InnoDB? When I use MyISAM?
2
votes
1answer
1k views

Listing MySQL JOINS with no index

Is there a way to generate a list of JOINS being performed without indexes in MySQL?
1
vote
2answers
47 views

Remove server and system name from apache auto indexes

I've configured apache2 to display folder content with option Indexes in one of my locations, but I really dislike how apache brags about its version and system's version. How do I remove this ...
1
vote
3answers
1k views

Apache directory listing only for specific IPs?

How can I enable Indexes only for specific IP addresses? Generally, I want directory listing to be disabled but only be enabled for a specific IP
4
votes
4answers
382 views

If I drop my clustered PK and add a new one, what order will my rows be in?

In SQL Server, I'm looking at TableA, which currently has a uniqueidentifier clustered primary key. The GUID has no meaning in any context. (I'll give you a second to clean up your keyboard and ...
0
votes
2answers
477 views

Table has no clustered index so what happens if i rebuild indexes?

We have a vendor app that has a SQL Server 2005 database. During data entry, app writes data to a table that has no clustered indexes on it. It has a number of indexes on the table, though. I used ...
0
votes
2answers
1k views

SQL Server: Index utilization statistics?

Is there a way in SQL Server to get a report of index usage? i know starting with SQL Server 2005, you can get reports of top resource-using queries, based on what's in the Plan Cache: i'm curious ...
2
votes
2answers
4k views

Why is Apache ignoring the “Options Indexes” directive?

I have the following block in my .conf file but when I load the appropriate URL (which points to a directory with just a dummy .txt file in it) I get the Apache 2 Test Page instead of a directory ...
1
vote
1answer
199 views

Modify Apache directory listings?

When I use Options +indexes ...in an .htaccess file, Apache (1.3) displays a formatted list of files in that directory. Yay! However, the actual layout of that formatting kind of sucks; the ...
5
votes
2answers
6k views

Clustered indexes versus non-clustered indexes?

I am in charge of a smaller DB 300+ hundred megs 100'ish tables about 45 users hit it throughout the work day. Mostly reads, but a fair number of updates and inserts. I have been slowing learning the ...
8
votes
2answers
2k views

Correct value for fill factor for clustered indexes with surrogate identity keys

I have a large table which has a clustered index with an identity primary key. I'm deciding on the correct value for the fill factor for this table to minimise page splits. We maintain indexes using a ...
3
votes
6answers
2k views

Method for finding unnecessary indexes of an operational SQL Server database?

Besides wasting space on the database, unnecessary indexes on SQL Server can slow down insert and update operations. Developers who lack experience in database principles sometimes tend to create ...
1
vote
3answers
3k views

Update Statistics actually decreases performance?

I have a nightly sp_updatestats on a production database, which seems to work fine, except for one particular stored proc that experience performance issues after the update. The dev team is ...
15
votes
3answers
2k views

How to exclude indexes from backups in SQL Server 2008

Our nightly full (and periodic differential) backups are becoming quite large, due mostly to the amount of indexes on our tables; roughly half the backup size is comprised of indexes. We're using the ...