|
I'm wondering what the simplest way to list all indexes for all tables in a database is. Should I call sp_helpindex for each table and store the results in a temp table, or is there an easier way? Can anyone explain why constraints are stored in sysobjects...
Started by Lisa on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
SCHEMA.TABLE_CONSTRAINTS
which will list out unique, primary key and foreign key constraints - everything that gets turned into an index on SQL Server.
|
|
+6.8 - ship---this - 8/4/2011
+2.9 - stadler - 8/4/2011
+2.8 - Shoot59 - 8/4/2011
+2.7 - rianb - 8/4/2011
+2.5 - PRINCEofSTUD - 8/4/2011
+2.4 - Tehan55 - 8/4/2011
+2.0 - K-Slay - 8/4/2011
+1.9 - NxtWrldChamp - 8/4/2011
+1.9 -Jeyer - 9/24/2011
+1.9 - JTrout...
Started by Brocktoon on
, 9 posts
by 7 people.
Answer Snippets (Read the full thread at twoplustwo):
+6.8 - ship---this - 8/4/2011
+2.9 - stadler - 8/4/2011
+2.8 - Shoot59 - 8/4/2011
+2.7 - rianb - 8/4/2011
+2.5 - PRINCEofSTUD - 8/4/2011
+2.4 - Tehan55 - 8/4/2011
+2.0 - K-Slay - 8/4/2011
+1.9 - NxtWrldChamp - 8/4/2011
+1.9 -Jeyer - 9/24/2011
+1.9 - JTrout... .
|
|
I'm wanting to use .htaccess to prevent directory listing. I've got pages within /location/ but I don't have an index file. So Im wanting to redirect to /location/about.php for example.
Is there a way to do this, without creating a index.html and redirecting...
Answer Snippets (Read the full thread at stackoverflow):
Tricks/htaccess2.php
Prevent directory listing (or return an empty directory listing):
http.
|
Ask your Facebook Friends
|
I have a problem creating an index with Zend_Search_Lucene.
Now, everything works fine on my local machine so I guess there is just an issue with file permissions on the webserver.
Here is how I'm trying to create index in controller:
$index = Zend_Search...
Started by Richard Knop on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
So change it to something like
$index = Zend_Search_Lucene::create('/path/to/public_html/public/data/users_index');
Although....
Hi
$index = Zend_Search_Lucene::create('public/data/users_index');
??
Edit/Update : After further issue.
|
|
I've got the following routes:
// Submission/* routes.MapRoute( "Submission", "Submission/{form}", new { controller = "Submission", action = "Handle", form = "" }); // /<some-page> routes.MapRoute( "Pages", "{page}", new { controller = "Main", action...
Started by xanadont on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
On IIS neither of "localhost/" and "localhost/Index" should work unless you enabled wildcard.
|
|
Hello. I would like to know how you might achieve this look with Apache's Indexing?? Is there a module I can get? Thanks!
Apache Indexing screengrab...
Started by Scott on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
If you want, users reach you by http.
If you ask the directory listing wigh beautiful icons.
|
|
I have a large directory of individual names along with generic publicaly available and category specific information that I want indexed as much as possible in search engines. Listing these names on the site itself is not a concern to people but some...
Started by Peter on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
The bot would index the page it is redirected to and not the page you wish to visit.
A pure PHP solution.
|
|
I recently ran some penetration testing software on my web site and was surprised for it to report that one of my directory listings was publicly accessible.
It is the directory of the root user which is available.
http://www.example.com/~root/
Results...
Started by Jon Winstanley on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
There is....
You could create a .htaccess file in that directory, or have a <directory>...</directory> block in your Apache configuration that specifies:
Options -Indexes
See the Apache options directive documentation for more details.
|
|
I have several standalone applications in my "My Documents" folder such as "procexp.exe", "putty.exe", etc. I noticed that Windows Search does not index them even though "exe" is a file type that should be indexed (file properties filter) according to...
Started by JcMaco on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at superuser):
If you'll consider using a better search engine, the Everything search engine might be... .
Try going in to options and rebuilding your database.
It should do and whilst I have other problems with indexing on my machine, it does return .exe results.
|
|
What are the general rules in regards to using composite indexes? When should you use them, and when should you avoid them?
Started by Alex on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
For example, if you have an index on (OrderId) this query would require a table lookup:
select Status from Orders where....
Completely on an index.
Sure there are many more uses for a composite index, just listing a few examples.
|
