Viewing 15 posts - 40,261 through 40,275 (of 49,571 total)
achleshsoni (3/20/2009)
no but this happened suddenly while sql is fully working , it looks bcas of overload of memory ...
High memory usage will not cause a complete cache flush.
Check...
March 20, 2009 at 8:34 am
plavec (3/20/2009)
I know that FORCESEEK is available in 2008, but I need it in 2005 😉
Perhaps you could tweak query and indexes so that hints are not necessary. Post query,...
March 20, 2009 at 8:22 am
achleshsoni (3/20/2009)
second option see some logs.. since whn problem got started ....
Sorry, I don't understand.
There's nothing interesting in that piece of log, it's a standard set of SQL startup events.
March 20, 2009 at 8:17 am
So there's no blocking? Don't use sp_who2, query the session and requests DMVs directly. Lots more information.
SELECT * from sys.dm_exec_requests where session_id > 50;
What are the wait_types and wait_resources that...
March 20, 2009 at 8:11 am
Please post SQL 2000 questions in the SQL 2000 forums in the future.
It is not possible to restrict users from using openquery. As Books Online notes
Permissions
Any user can execute OPENQUERY....
March 20, 2009 at 8:07 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic680206-146-1.aspx
March 20, 2009 at 8:03 am
You need to identify what's causing the cache store flush. Is it happening regularly?
It could be someone running DBCC FREEPROCCACHE
It could be a database that's set to autoclose
It could be...
March 20, 2009 at 7:58 am
David (3/20/2009)
However1. The results could return data from transactions which haven't yet commitment and so could be rolled-back.
Correct
2. The results could be inconsistent if the other connection is mid-write. ...
March 20, 2009 at 7:44 am
ddorfman (3/20/2009)
Sorry i know im in the 2005 forum , but in have a sql 2008 server and there is only sp 1 for the server.
And SP1 for 2008 is...
March 20, 2009 at 7:37 am
gyessql (3/20/2009)
Is it possible to use group by this way?
Why don't you try it and see if SQL likes it or not? Probably faster than waiting for one of use...
March 20, 2009 at 7:29 am
EventData is used in DDL and logon triggers, not DML triggers.
March 20, 2009 at 1:14 am
Take a look al SSIS's copy database objects task. I've used that before to 'downgrade' a database.
March 20, 2009 at 1:12 am
Look up SUBSTRING in Books Online. Lookup CHARINDEX as well.
March 19, 2009 at 2:52 pm
Table definition and index definitions please. Also the execution plan, saved as a .sqlplan file, zipped and attached.
March 19, 2009 at 2:51 pm
Continued here - http://www.sqlservercentral.com/Forums/Topic679935-9-1.aspx
No more replies to this thread please.
March 19, 2009 at 2:50 pm
Viewing 15 posts - 40,261 through 40,275 (of 49,571 total)