To Index or not to Index (that is the question...)
I'd like to clear up an assumption I have.
If I have a Primary Key Constraint on a Table I assume that I will not need
to create an Index on the field(s) of the constraint as the action of
creating the primary key constraint produces what is the equivalent of an
Index (be the constraint clustered or not).
Is this the case?
Also I'm looking to Pivot some data, are there any SQL tricks etc. I should
be aware of to be able to do this (I've searched the Newsgroups for 'Pivot'
but don't understand any of the answers posted - some SQL examples would be
gr...Basic Index question :- nonclusted indexes which are a subset of a clustered index
Can anyone suggest why I would have the following set of indices upon a
index1 clustered, unique field1,field,field3,fiel4
index2 nonclustered field2,field3, field4
index3 nonclustered field,field2,field4
The table is one into which a lot of inserts are done, so I would have
thought that index2 & 3 would be unncessary since they're
(1) already in the clustered index and
(2) any inserts would triple the amount of index updates that are
Are these assumptions correct ?
Thanks in advance,
if you have a...To Index or Not To Index or How To Index
I was wondering if someone knows a better way to explain how different indexes
work. Such as, is it better to have an index with int type or char or varchar
etc? Is it better to have composite indexes or indexes with individual columns?
How does optimizer handle different indexes and what can we do help it? Indexes
are very efficient most of the time but they can be quite detrimental to
server's performance, if abused. Perhaps you know of a good article about
indexing that you could share with us. Or, perhaps Mr. Rob Verschoor would like
to issue an article in his very usefu...MS Index Server, Web Page Searches
I have the service set up and running and I'm able to do searches on my website and return the results to a search page. The basics are fine and up and running.
Question: I find when I publish the website if the '[x] Make site updateable' checkbox isn't checked the .aspx pages do not show up in a search. Is it true that the site must be published as updateable in order to make the MS Indexer work? Am I sacrificing security in order to get the pages indexed? Is there a way to publish the site as not updateable and still have the indexer work?
I...Questions about Indexing and Using an Indexing POA
Although I have only about 50 users, at least 15 of them have in excess
of 100,000 messages in their accounts and the POA (version 7.0.2) is
regularly slowing to a crawl. (I just know that plans for revolution
are fomenting!) I have embarked on a campaign to reduce these accounts
by archiving everything off to get mail accounts down to 3000 or fewer
pieces. I have achieved user buy-in, but have worked on only a few
users so far.
In another closely related thread, it was suggested to me that the PO
speed issues relate to broken indexes. And I suspect that given so many
messages...automate form question and general http questions
There are lots questions. I appologize at first.
I am trying to automate a form submission. in html the
<select name=p2 size=1 onChange="showimage()"><option
<input type="radio" value="" checked name="show">001
<input type="radio" value="0" name="show">001
i am wondering can i do it as
corresponds to choose option '123' and radio '001'? or...anim_parrot_logo.imc: .include question + general imcc questions
While looking at Chromatic's anim_parrot_logo.imc (in examples/sdl), I
was wondering why the includes weren't at the same place. Indeed, the
..pcc_sub _init prototyped
error:imcc:parse error, unexpec...windows ME questions, questions, questions.......
my next PC will be running Windows ME. The PC will be supplied via my work,
so there's no choice here for me (ME?) (I think I would have preferred 98
SE). The harddisk (40GB matrox) will have ME installed, and both the Windows
ME set-up files and an image of the initial Harddisk 'on a hidden
partition'. Word has it that this partition is not seen by Format nor FDisk.
Is this really possible?
No Windows CD will be supplied. Seems a new way of MS to encourage working
with licensed software only.
Anyone familiar with this way of distributing an OS?
Will I be able to ...general question
Hello everyone, I wonder, how many people can access a simple order webform simultaneously without causing a server crash?? And another question for the pro's. How many users can you manage using the membership and profiles using ASP.NET?? regards Cheers
>I wonder, how many people can access a simple order webform simultaneously without causing a server crash??Effectively unlimited in theory if all session state state is handled in viewstate. If handled in memory then memory will constrain. In in SQL State, the capacity of the database. There is also a lim...Index question
If I have a table with a foreign key into another table, will the
optimizer use that as an index for other purposes as well, such as joins
to other tables (not the one the foreignkey is referring to) or 'where'
clauses. Or do I need to put in an explicit index for those purposes?
The reason I'm asking is that a query which uses a join into this table
was giving me a sequential scan of this table even though there was an
index available in the form of the foreign key. I can't tell if that's
just because the optimizer thought this would be faster (since it's ...Some general questions....
I am at the end of my dev cycle, and to be honest my knowlegde about
database's is kinda limited.
I am using Sybase Sql Anywhere 5.5.04 build 1867. Suppose i get my first
customer that buys the product (PB app).
1. Do i just make a copy of our db and place at customer's site ? Or can i
extract some creating scripts from the existing db, that will create the db
(tables) at their site ? How do i do this ?
2. All our data is company dependant, so a client can have multiple
companies, maybe i can write a small pb application that reads in txt files
I am having trouble finding answer for the following questions
if anyone knows any answers from these questions please do reply as soon as
1. What is the PFC Application Manager and how is used in PFC applications?
And, describe the details of the relationship of the PowerBuilder Application
Object to the PFC Application Manager.
2. Describe the steps required to create a MDI application using PFC from
scratch in sequence and where appropriate indicate why the sequence is
necessary. (At least, one complete sentence per step.) Where and how c...general question
In my window i have 4 dw which have a master/detail - relation top down.
All dw have tabular style and are not editable.
On doubleclicking a row I open a window which shows this dw in freeform
I'm not sure if it is better to pass a reference of the dw to the window and
to change the values (I think that doesn't meet the criteria of data
or to copy the rows of the dw into another dw, pass it into the window,
there copy it to the freeform dw and do the same at returning from the
window (=much more to code).
thanks for ideas
Hi i am allitle bit confused.
is the asp.net SDK differenet from the .Net framework sdk...or is it part of the .Netframe work sdk......
Another question, i am using the MS VS.net family member (VB.net) which says version 2002 on the package, is there a new VS.net family member (VB.net) out.
Hello, there is now the VS.NET 2003, a more updated version of VS.nET 2002.
you have the .NET framework sdk, where you can run asp.net scripts.
regards.Bilal Hadiar, MCP, MCTS, MCPD, MCTMicrosoft MVP - Telerik MVP
hello, sorry i forgot to tell you about this website, it helps you unders...