Profiler trace with filter on multiple table objects
Jun 27, 2018 · How do you filter on mutiple table object names in Profiler? I set up a Profiler trace to capture lock activity. I want to filter on a specific database name and on a few specific …
SQL 2008 Log Shipping Restore Fails after working for some time
Jul 1, 2010 · I recently set up log shipping in SQL 2008 SP1 (Primary, Secondary, Monitor all have SP1). For several days the .trn files are copied and restored to my secondary server's …
Identifying the label/name of user defined fields in the BCM …
Jan 1, 2020 · If you only have SQL Server Express, you can do a Server-Side trace, or for about $50.00, you can purchase SQL Server Developer Edition and use SQL Profiler for the trace. …
How to configure security using script - social.msdn.microsoft.com
Mar 6, 2008 · I want to write some SQL Script to configure my report server's security. I got the following the scripts from profiler: Code Snippet declare @p7 uniqueidentifier set …
An error occurred during local report processing
Nov 15, 2010 · The expression for the SQL is part of the GetSQL function: (simplified) Public Function GenSQL (SSN as String) as String Dim SQL as String SQL="select * from members …
on live server js take too much time to load
Oct 7, 2021 · Paging in a GridView Data Control Effective Paging within a GridView Control Paging Examples using an ASP.NET GridView You may want to consider using a SQL Profiler …
Checkpoint blocking Backup log or vice-versa
Sep 10, 2008 · You can also save the Profiler data to a SQL Server table (on the File menu, point to Save As and then click Table) and run SQL queries against it. Be careful that you perform …
CURSOR Performance and Alternatives - social.msdn.microsoft.com
May 21, 2008 · Wall-clock time is in my opinion the best measurement of performance. But if you want to measure reads and writes, but you could package the script in a stored procedure, and …
UPDATE STATISTICS statement and MAXDOP hint
Oct 7, 2013 · This last statement is what I am having difficulty proving. I have access to 3 different SQL Server environments (SQL Server versions 2005, 2008, and 2012). The databases on …
How to identify the real blocking lock - social.msdn.microsoft.com
Oct 2, 2012 · Now seesion 1 and blocking session 2. However, in profiler blocking report, it showed that SELECT * from employee is blocking SELECT * from Employee, but the real …