Viewing 15 posts - 40,246 through 40,260 (of 49,552 total)
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....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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. ...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 20, 2009 at 7:29 am
EventData is used in DDL and logon triggers, not DML triggers.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 20, 2009 at 1:12 am
Look up SUBSTRING in Books Online. Lookup CHARINDEX as well.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 19, 2009 at 2:50 pm
umar iqbal (3/19/2009)
if you want to clean up tempdb u can schedule this script. it will remove temp tables that are older than 12 hrs.
Did you test out that...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 19, 2009 at 2:47 pm
All monitoring tools have some impact. You can't check a server's behaviour without using some resources on it.
For what it's worth, I've never had a noticeable performance degradation from using...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 19, 2009 at 1:57 pm
SQL Trace. Much lighter weight than the Profiler GUI. There's a recent article at Simple Talk that talks about using SQL Trace to find badly-performing queries.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 19, 2009 at 12:59 pm
kevin77 (3/19/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 19, 2009 at 12:53 pm
Viewing 15 posts - 40,246 through 40,260 (of 49,552 total)