Viewing 15 posts - 35,701 through 35,715 (of 49,552 total)
Firstly, statistics as controlled by Create/update/drop/ DBCC SHOW_STATISTICS are completely unrelated to SET STATISTICS XX. The first are column statistics used by the optimiser, the second shows query execution statistics.
Some...
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
November 21, 2009 at 2:29 am
syedkamranfaisal (11/20/2009)
will db performance be improved if we delete the log file and create new one?
No, but you could very likely end up with a suspect and unusable database. 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
November 21, 2009 at 2:21 am
Gianluca Sartori (11/20/2009)
...Uhmmm... I'm getting hungry.:-)
Likewise, and I had supper a couple hours ago.
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
November 20, 2009 at 12:26 pm
gregory.anderson (11/20/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
November 20, 2009 at 12:23 pm
Double (triple) check that you're looking at the same server from the Quest tool and management studio. Double (triple) check that it's the same database. Double (triple) check that 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
November 20, 2009 at 9:32 am
How do you know it's not executing?
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
November 20, 2009 at 9:22 am
select <column list>
from sys.dm_exec_cached_plans cp
Cross Apply sys.dm_exec_query_plan(cp.plan_handle) qp
Inner Join sys.objects o On o.objectid = qp.object_id
Run this in the DB that the object is in rather than master, otherwise you'll get...
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
November 20, 2009 at 9:15 am
Double check the code of the procedure to make sure somehow the old version didn't get re-applied over your changes. When you change a proc, the very next call will...
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
November 20, 2009 at 9:13 am
Gianluca Sartori (11/20/2009)
It's not pork chops, but I think it could be time for the friday recipe. 🙂
Interested in a 3-hour pork goulash recipe? Or maybe a 6 hour beef...
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
November 20, 2009 at 9:08 am
AhTu_SQL2k+ (11/20/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
November 20, 2009 at 6:19 am
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
November 20, 2009 at 5:58 am
Why do you want a sample resume?
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
November 20, 2009 at 5:56 am
My guess is that you have parameter sniffing problems. Post the proc?
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
November 20, 2009 at 5:56 am
Why are you asking?
SAP's not dedicated to Oracle. It runs on SQL Server too.
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
November 20, 2009 at 5:53 am
Unrelated, other than they are both NTFS features.
Alternate streams: http://msdn.microsoft.com/en-us/library/ms810604.aspx (long document)
Sparse files: http://msdn.microsoft.com/en-us/library/aa365564%28VS.85%29.aspx (there's also info on sparse columns in the previous doc)
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
November 20, 2009 at 5:53 am
Viewing 15 posts - 35,701 through 35,715 (of 49,552 total)