Viewing 15 posts - 5,746 through 5,760 (of 7,429 total)
What did you change? Sorry but I got busy and lost the post, but had looked and did not see anything right off.
"Don't roll your eyes at me. I will...
May 23, 2002 at 5:12 am
Actually there is are several excuses but none are any good. This should be the first thing you learn. Also audit your passwords for things like 'God', 'dog', 'cat', '1234',...
May 23, 2002 at 4:57 am
Profiler will probably be your best bet, you can limit to audit connections login and filter for a specifc database in addition to collecting appilcation (if it supplies it's name),...
May 23, 2002 at 4:52 am
Sorry Steve meant SQL SP, run SELECT @@VERSION and post the output if you are not sure, we can figure out from that. However I would try a reinstall of...
May 23, 2002 at 4:48 am
The cache is your primary speed augementor as it stores execution plans of queries and some datasets that are called often or have been recently called. If you adjust the...
May 23, 2002 at 4:39 am
Yes EM recognizes reserved words for the version of EM is installed from and automatically generates the [] to qualify. They do not actually exist if you look at in...
May 22, 2002 at 11:37 am
Also I had one instance on a test database that corrected itself when I dropped and recreated the indexes. Also, open the DTS package and resave, don't think so but...
May 22, 2002 at 8:59 am
This list which cam efrom http://www.sql-server-performance.com is the mot complete but some beta numbers and possible hotfixes are missing but for the most part is accurate. Also run SELECT @@VERSION...
May 22, 2002 at 5:56 am
The biggest issue with doing this is it breaks the ownership chains and you will most likely have to give direct access to the tables where a stored procedure or...
May 22, 2002 at 5:50 am
You are better off running without AutoShrink anyway. Problem with Auto Shrink is it seems to always do this when it is most inconvenient.
"Don't roll your eyes at me. I...
May 22, 2002 at 5:07 am
Please do not crosspost. See responses in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=4370&FORUM_ID=5&CAT_ID=1&Topic_Title=DBCC+%28urgent%21%21%29&Forum_Title=Administration
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 22, 2002 at 5:02 am
Looks like the client tools were not updated. Try reinstalling SP3 and check the version afterwards. Should change, then try the same on the other machine.
"Don't roll your eyes at...
May 22, 2002 at 5:00 am
1) Backups DB and Log fitting your time constraints and data recoverability needs.
2) Reindex on 7 or DefragIndex on 2000, properly maintained indexes keep speed up.
3) Update statistics.
4) Reorganize data...
May 22, 2002 at 4:52 am
Ok here is a thought as seems to be something I cannot think of off hand. Launch Profiler and do a trace of TSQL Stmt:Completed items for this database. At...
May 21, 2002 at 8:55 pm
Yes this has long been an issue in SQL 7 and had not yet checked in 2000 but I figured something was up. Personally I aim for COUNT from actual...
May 21, 2002 at 7:26 pm
Viewing 15 posts - 5,746 through 5,760 (of 7,429 total)