You're right :)
opening management studio takes around 20 seconds. besides the most remarkable slowness is when no one is connected to the server...
no the sqlserver is generally slow even if no application is run on it
sqlserver.exe takes around 4GB of memory. the sqlserver only serves for our web application so I need a way to see why this application takes so...
We have performanceproblem in our SQL server2005. Indexes are rebuilt, statistics are updated and slow queries are tuned however the sql server is...
Thanks for the reply
When I define cascade or set null on update/delete of their FK references, a cyclic problem occurs:
User(id, name), I define...
I'm having Users, Tasks, and Categories:each user has many taskseach task may be in any or one categoryeach user has many categoriesI want it when a...
Thank you mahmoud I found that :)
I was just curious about it
I came to that path in registry and couldn't find the default backup path[:$]
could you help me find that?
see if it can help http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=168425&SiteID=1
You can download and install performance dashboard tool from Microsof site;it provides you with more reports I haven't tried truncate one but it...
hi Mohammad, Could u please explain what 'Dynamic DBCC DBREINDEX' exactly do? I didn't get the explanation.[:$]
well... it's said that creating foreign keys between two different DBs leads to low performance and is risky so it's better to have all relationships...
visio is not bad choice [:)] having such foreign key between two databases is bad
DO you know, by any chance, that which version supports such functionality? I'm having visio Architect but couldn't find that
Actually, it is possible Frank but it's not a good choice though I'm involved with a situation that makes me do that. [:^)]
Thanks all for your useful comments [:)]
As I've made conclusion from your replies, I'm going to learn more about index tunning adviser to be able...
Is there any diagramming tool, like Enterprise Architect, ER win, etc., in which Cross database integrity constraint can be shown.
it's for SQL 2005[H]
Your comments helps more than just saying thank you, Johnson
All the best
Hey, do not monitor me Luis [:D]
Thanks for the comment anyway[:)]
Separate names with a comma.