Viewing 15 posts - 43,741 through 43,755 (of 49,552 total)
Could you perhaps explain a bit more what you're trying to do and why?
TempDB can't be restored or attached. For that matter, it can't be backed up or detached. It's...
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
October 15, 2008 at 2:18 pm
One other thought....
If you query sys.dm_os_wait_stats, what are the waits with the highest wait times (say the top 20)?
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
October 15, 2008 at 2:15 pm
Alan (10/15/2008)
Rebuild/Reorg IndexesUpdate Stats - I know this is somewhat redundant with auto stats on but I still do it
Not just that, but the rebuild of an index updates stats...
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
October 15, 2008 at 2:12 pm
If they want to change the owner of the system databases, ask them for the justification for that request.
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
October 15, 2008 at 2:07 pm
Andy Leffler (10/15/2008)
What's the best way to go about this?
The code I gave you will show which processes are involved in the blocking. Use the...
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
October 15, 2008 at 2:03 pm
You can rename sa safely. The database's owner references the login's SID, not the login's name . Even if you change the name of sa, the SID remains the same.
If...
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
October 15, 2008 at 10:01 am
Two questions first
Would you be allowed to make changes to the SQL code?
Would you be allowed to make changes to the indexing?
If not, would you be able to recommend/suggest to...
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
October 15, 2008 at 9:59 am
Grant Fritchey (10/15/2008)
OK. That's twice. It should stop now.
:hehe: 😀 Great minds think alike?
I'll go do something else for a while...
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
October 15, 2008 at 8:57 am
Grant Fritchey (10/15/2008)
Oops. There I am typing up the response and looking for your URL and there you are posting it. Ah well. Reinforces the point.
😀
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
October 15, 2008 at 8:52 am
If you're having problems with trace, you can try querying the procedure cache. It should pick up the most expensive queries.
select total_worker_time/execution_count/1000 as AverageCPUTime, total_elapsed_time/execution_count/1000 as AvgDuration, st.text
from...
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
October 15, 2008 at 8:48 am
Please don't cross post. It just wastes people's time and fragments replies.
Replies to the following thread please
http://www.sqlservercentral.com/Forums/Topic586071-360-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
October 15, 2008 at 8:38 am
hemakrmmc (10/13/2008)
Please help me out from this bug.
It's not a bug. It's a warning that your table's too wide. The max size of a row in SQL server is 8060...
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
October 15, 2008 at 8:37 am
An inline function only allows a single select statement as the function body. When run, the optimiser will treat it like a subquery.
multi-statement functions allow a number of statements...
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
October 15, 2008 at 8:34 am
Are you seeing queries running longer than they should? Are you seeing blocking? If the queries have high wait times, what are they waiting on?
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
October 15, 2008 at 8:29 am
My preference is to set the max memory and let SQL manage the rest.
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
October 15, 2008 at 8:28 am
Viewing 15 posts - 43,741 through 43,755 (of 49,552 total)