|
Hi,
Is it wise to make use of indexing?? What are the downfalls of it, won't it slow down my database?
Also, are primary keys indexed automatically? Should foreign keys also be indexed? What else do I need to do to speed up searches?
Please can some advise?
Regards
Brendan
|
|
|
|
|
Indexes speed searches, joins and ordering while they slow down insertions and some updates.
You need to make a balance based on how you access your database.
Stress testing and Database Engine Tuning Advisor[^] can help you make a decision.
Speeding searches does not depend only on good indexes (which are essential) but also depends on using best practices, for example not using a lot of casts and using joins instead of sub queries, joining only needed tables and returning only required columns...etc.
|
|
|
|
|
Brendan - indexes are necessary if you want to speed up your searches. There is a fine balance to strike between having enough indexes to search on and too many - thus slowing down Update/Delete/Inserts.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Hi,
I am going to offer my clients different services. But they need only 1 id and password. What is the best way to go about this, should I have my member tables in a seperate database and each service in a seperate database? I just want to reduce the database if I seperate the databases?
Thanks
Brendan
|
|
|
|
|
I am going to guess that when you say database, you mean table. And if so, then yes, you should have separate tables for both. Maybe something like the following based on what information I digested from your post.
Users -
ID
Username
Password
Services -
ID
Name
User Services -
User ID
Service ID
Where Users houses the usernames and passwords, Services houses the service names, and the User Services simply links which services the user can use.
The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo
|
|
|
|
|
We have sql server replication snapshot index script file (db.idx and db.dat). We want to read data from idx file using c# or vb. Any help will be highly appreciate.
-----
|
|
|
|
|
You are cross posting this in here now!!! 
|
|
|
|
|
I posted here because you said it has nothing to do with ASP.net, what do you want me to do now? do you want me to delete from the other forum? All I want is some tip/guideline? I don't know if your are trying to help or tease?
-----
|
|
|
|
|
I've run across other forums that are not so dominated by "rules tyrants" like here. I'd suggest asking in those forums. I've gotten polite responses from folks at www.dbforums.com
Sorry I can't help you myself. I don't know anything about the subject.
David
---------
Empirical studies indicate that 20% of the people drink 80% of the beer. With C++ developers, the rule is that 80% of the developers understand at most 20% of the language. It is not the same 20% for different people, so don't count on them to understand each other's code.
http://yosefk.com/c++fqa/picture.html#fqa-6.6
---------
|
|
|
|
|
The heading says it all.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
  ;P
-----
|
|
|
|
|
So SQL really isn't my cup of tea and I was poking through the System stored procedures generated by Enterprise Manager at creation-time of a database. While I was looking I noticed a stored proc called dt_validateloginparams. Now, I'm curious if one can use this stored proc to log users into an app or web-app that uses sql login criteria.
I scoured google as much as possible, and only found discussions on how to remove the procedure. Apparently it's not a very popular sp.
Any enlightenment would be much appreciated.
|
|
|
|
|
Will the SQL 2005 client tools allow me to connect to a 6.5 database? I want to run profiler and query analyser. Enterprise Manager for 6.5 is a joke.
Or any other ideas for seeing what is happening, realtime, on a 6.5 SQL database.
"More functions should disregard input values and just return 12. It would make life easier." - comment posted on WTF
"This time yesterday, I still had 24 hours to meet the deadline I've just missed today."
|
|
|
|
|
Dunno avout 6.5, but it works ok on Sql Server 2000....
Regards,
Rob Philpott.
|
|
|
|
|
Try it and see what happens.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Great Idea! Why didn't I think of that?
Because I don't have it installed? Because I am on a clients site and have to jump through many hoops to get anything installed?
I will try it when back in my own office, but was hoping somebody out there might help, not treat me as being one of the many lazy slackers on here who wants everybody to do their work for them.
-- modified at 10:59 Wednesday 14th November, 2007
Apology to Paul issued for this below. I won't delete this post as a) I hate it when people do that and b) Colin copied the whole lot in his reply so there'd be no point!:-O<br />
<br />
The flak jacket is buttoned up tight to try and deflect all those deserved '1' votes.
"More functions should disregard input values and just return 12. It would make life easier." - comment posted on WTF
"This time yesterday, I still had 24 hours to meet the deadline I've just missed today."
|
|
|
|
|
Malcolm Smart wrote: Great Idea! Why didn't I think of that?
Because I don't have it installed? Because I am on a clients site and have to jump through many hoops to get anything installed?
I will try it when back in my own office, but was hoping somebody out there might help, not treat me as being one of the many lazy slackers on here who wants everybody to do their work for them.
You could have said that up front so that people would know.
|
|
|
|
|
And how were we supposed to know that??
Everyone I know is using a minimum of 7.0 (mostly 2000), so 6.5 is a little hard to come by.
|
|
|
|
|
Dave Kreskowiak wrote: 6.5 is a little hard to come by.
It is still available to MSDN Subscribers. 
|
|
|
|
|
It is!  That thing should have died a long time ago!
|
|
|
|
|
Malcolm Smart wrote: The flak jacket is buttoned up tight to try and deflect all those deserved '1' votes.
I don't see any 1 votes.  You don't deserve them because you have made a correction and quite graceously too. So many people don't do that and just jump in and argue back (which just irritates everybody). Sorry, I can't help in this instance. I hope you get your problem solved.
|
|
|
|
|
My last response to you was out of order. Sorry.  A bad day, turning into a bad week. Doesn't bode well for the month.
I know most people on here post a question as their first port of call, hoping for somebody to do their job for them. I have STFW for this, asked around and got nothing. Posting is generally my last resort, and I got the same answer given to a lot of other posters and it narked.
I should have been clearer in my question, but I generally assume that the OP has tried, or is unable to do, what he is asking about. Unless they are from NIIT.
Thanks to Colin for picking me up on this.
"More functions should disregard input values and just return 12. It would make life easier." - comment posted on WTF
"This time yesterday, I still had 24 hours to meet the deadline I've just missed today."
|
|
|
|
|
I've been having a bad few weeks like this too.
Though the bottom line is you're going to have to try it anyway to see what works and what doesn't if you're going to support it, even if someone does say "Yeah, it works!". Personally, I trust what my testing tells me, not what other people think works.
|
|
|
|
|
That's OK. I see lots of posts where the obvious advice to give is 'Try it yourself and see what happens'. For some reason this doesn't occur to many people, especially those posting from the Indian subcontinent.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
Yes, you are now on the third stage of self-help: