Inside SQL Server 2005: Query Tuning and Optimization , any new …
Dec 4, 2014 · All replies 1 Sign in to vote hi, i have not read this book Inside SQL Server 2005: Query Tuning and Optimization,
Inserts are slow because of many nonclustered Indexs, tips?
Jun 13, 2011 · No, running performance monitor does not affect performance. Please note that I am not talking about SQL Profiler here, because that can indeed affect performance. I am only …
BizTalk Traking DB Jobs update - social.msdn.microsoft.com
Apr 2, 2012 · HTH, Naushad Alam When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer alamnaushad.wordpress.com | My new …
Performance : Merge Interval - social.msdn.microsoft.com
Sep 11, 2017 · Actual performance is what matters. I ran the 2 different versions capturing sql_batch_completed with an xe trace and the duration (200 microseconds) of the UNION ALL …
DTA not working - social.msdn.microsoft.com
Nov 30, 2015 · If the sp_DTA_add_session object is missing from the server, you can copy the sp_DTA_add_session stored procedure script from a same SQL Server version that DTA is …
Want to collect performance data for analysis through out the …
Aug 5, 2013 · i am working on a VB.NET and making a performance ,monitoring,analysis and alerting tool for my client. Can you guys provide a complete script to fetch counter data using …
Database transaction log is full due to 'CHECKPOINT'
Aug 7, 2018 · Do you have any start-up procedure or perhaps something starts immediately after server restart and thus tempdb shows up as "Active_Transaction"? tempdb is not recovered …
Include the schema name to the query - social.msdn.microsoft.com
Dec 4, 2018 · All replies 1 Sign in to vote like this SELECT f.name AS ForeignKey, SCHEMA_NAME (f.schema_id) AS SchemaName, OBJECT_NAME (f.parent_object_id) AS …
Index and table must user an equivalent partition function Errror
Feb 9, 2017 · I’m using SQL Server 2016 and I’m trying to solve an issue with a delete for a given date key value that takes forever, so I partitioned a table and tested it out with TRUNCATE …
stored procedure for rebuild indexes - social.msdn.microsoft.com
Oct 11, 2012 · Question 0 Sign in to vote hi all this is my rebuild index query, i schedule it in sql server agent (jobs),but it getting failed my stored procedure here :