A Visual SQL Query Designer – Code project (SQL From NAV Part III)

A Visual SQL Query Designer – Code Project (SQL From NAV Part III) If some of your customers asks you to gain access to SQL data directly from NAV (as other systems with integrated query editors..) can use this nice tool to run SQL queries (or others T-SQL statements…). This tools recalls some typical features of SQL Studio … Read more

NAV 2013 SQL Query Codeunit Tool (SQL From NAV Part II)

NAV 2013 SQL Query Codeunit tool i found this nice demo tool by Dynamic Manufacturing Solutions on Mibuso. Source http://mibuso.com/downloads/nav-2013-sql-query-codeunit nice tool, based on .NET integration (AD), usefull if you don’t like Powershell. Purpose of this tool “Simple codeunit allows you to execute an SQL query to populate any NAV (temporary) table using one call.  … Read more

sp_whopro™ – SQL Server Activity Monitoring and Logging Stored Procedure

sp_whopro™ – SQL Server Activity Monitoring and Logging Stored Procedure Great SQL Script ! Source: SQLDownload Download Post Views: 1,369

Top 10 SQL Server Counters for Monitoring SQL Server Performance — DatabaseJournal.com

Greg Larsen lists his top 10 SQL Server counters for maintaining database performance. Sorgente: Top 10 SQL Server Counters for Monitoring SQL Server Performance — DatabaseJournal.com Great post by Greg Larsen. Post Views: 1,159

BOOST NAV – How to show most 50 heavy queries on SQL SERVER

BOOST NAV – How to show most 50 heavy queries on SQL SERVER … very nice SQL Script to discover slow Sessions !! SQL SCRIPT SELECT TOP 50 SUBSTRING(qt.TEXT, (qs.statement_start_offset/2)+1, ((CASE qs.statement_end_offset WHEN –1 THEN DATALENGTH(qt.TEXT) ELSE qs.statement_end_offset END – qs.statement_start_offset)/2)+1), qs.execution_count, qs.total_logical_reads, qs.last_logical_reads, qs.total_logical_writes, qs.last_logical_writes, qs.total_worker_time, qs.last_worker_time, qs.total_elapsed_time/1000000 total_elapsed_time_in_S, qs.last_elapsed_time/1000000 last_elapsed_time_in_S, qs.last_execution_time, qp.query_plan FROM … Read more

%d bloggers like this: