Viewing 15 posts - 151 through 165 (of 165 total)
I would suggest to check out the following (as it might also be helpful for future reference):
http://www.sql-server-performance.com/tips_performance.asp
December 19, 2006 at 8:02 am
Usually, it is not advisable to index a bit column, the reason being that you want to index a highly selective column so that when an index is used, most...
December 19, 2006 at 7:43 am
Mohammed is right. If you have nothing in the Query Analyzer window, Index Tuning Wizard will be greyed out. As soon as you type a single character in the window,...
December 19, 2006 at 7:39 am
I thought there should be a comprehensive collection in books on line ... I googled ... but got nothing ... very strange!
December 18, 2006 at 10:32 am
Your sentence is a bit confusing.
Could you clarify what exactly you are trying to do with the query analyzer and the index tuning advisor?
December 18, 2006 at 10:25 am
See the following for explanation of the script file generated:
http://www.mssqltips.com/tip.asp?tip=1035
December 18, 2006 at 10:24 am
"As usual with these things you never know until you give it a try"
Actually, it is known that you better create the indexes after. During INSERT, DELETE, UPDATE operations, indexes are...
December 18, 2006 at 10:21 am
Simple cursor example you can use as a guide:
http://www.databasejournal.com/features/mssql/article.php/3430251
December 18, 2006 at 10:16 am
Ah ...
- Replication Monitor - Agents - Distribution Agents - "double click on publication" opened up the dialog box to show the error number.
Thanks Bill ... the info is quite...
December 15, 2006 at 9:08 am
Bill,
Where can I find information about what error value corresponds to which error (i.e. I want to know what types of errors I will be skipping when I set a...
December 15, 2006 at 8:12 am
Check this out:
http://www.mssqltips.com/tip.asp?tip=1035
Once you understand what is going on, the rest should be trivial
You'll probably want to have a job with 2 steps (once you adjust the code to...
December 15, 2006 at 8:00 am
Guys,
To solve the problem stated above, I am currently considering to implement the following replication model:
No user, other than the replication user, will be allowed to perform any insert/delete/update to...
December 13, 2006 at 9:17 am
Antares,
I implemented "updatable subscriptions" solution.
However, when I delete something from the subscriber, I get the following error message:
Login failed for user 'sa'.
Would you know what could be causing...
December 13, 2006 at 8:06 am
This is a quite useful suggestion.
Thank you very much
December 13, 2006 at 7:40 am
Viewing 15 posts - 151 through 165 (of 165 total)