Viewing 15 posts - 4,636 through 4,650 (of 49,552 total)
Check the default trace, DDL changes are logged in there.
The system tables won't help you, sys.indexes does not have a create_date column
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 1, 2015 at 1:10 pm
No way to answer such a general question. Procedures calling procedures however doesn't cause bad performance. Badly written code and poor indexing causes poor performance. You either need to do...
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 1, 2015 at 10:29 am
1) Don't use Task Manager to check SQL Server's memory, it can be wrong
2) SSMS is not the SQL Server engine. It's SQL Server Management Studio. It shouldn't be getting...
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 1, 2015 at 10:27 am
You've either got a filter in the trace definition or the deadlock didn't occur.
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 1, 2015 at 10:23 am
andy 61637 (10/1/2015)
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 1, 2015 at 10:22 am
BWFC (10/1/2015)
Hopefully next month there'll be a butty with homemade bacon, homemade sausage and eggs from the allotment on homemade bread. I can taste it already...
So, um, whereabouts in...
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 1, 2015 at 2:55 am
Please post the table and index definitions and the actual execution plan, saved as a .sqlplan file. A picture of the query plan is not very useful.
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 1, 2015 at 1:06 am
Lock resource hash value. SQL uses a hash function on the index keys for locking purposes.
It's not all that useful, unless you want to use the %%lockres%% function 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 1, 2015 at 12:58 am
GO is not a T-SQL command. It's an indicator for Management Studio as to where the batches of commands end. Hence it'll cause errors in anything other than Management Studio
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
September 30, 2015 at 1:22 pm
SELECT * FROM sys.procedures
It's not going to tell you what was changed, or by who, just when the procedure was created and modified. The what and the who you 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
September 30, 2015 at 10:57 am
http://sqlinthewild.co.za/index.php/2010/09/14/one-wide-index-or-multiple-narrow-indexes/
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
September 30, 2015 at 10:52 am
>1.
The cardinality estimates don't imply whether or not you need an index. They just tell you about estimation errors. What tells you that you probably need an index here 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
September 30, 2015 at 10:15 am
It's a correlated subquery. The fact that the outer query is an update doesn't change that, it's a subquery which references a table in the outer query, that's a correlated...
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
September 29, 2015 at 2:44 pm
I understood you just fine. The only restore which a snapshot can be used for is to revert (restore) the source database to the time which the snapshot was created.
A...
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
September 29, 2015 at 2:41 pm
No.
That command removes all clean data pages from the cache immediately. If your slowdown was caused by the overhead of loading data from disk, then the next execution 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
September 29, 2015 at 11:05 am
Viewing 15 posts - 4,636 through 4,650 (of 49,552 total)