Microsoft SQL Server Developer Edition is now free | SQL Server Blog

Official News from Microsoft’s Information Platform Source: Microsoft SQL Server Developer Edition is now free | SQL Server Blog Post Views: 1,186

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,380

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

Script Search for a string in “all tables” of SQL Server Database

Good & Fast Script to search for a string in “all tables” of SQL Server Database, very useful with NAV Databases too (to find data FAST in each database\company, no C/AL Code or powershell commands required ) link Script Search for a string in all tables of SQL Server Database  (from MSDN Script Center) by Sorna Kumar … Read more

SQL Server MAXDOP configuration option for Microsoft Dynamics NAV

SQL Server MAXDOP configuration option for Microsoft Dynamics NAV My question to NAV Team about suggested configuration  : ‘SET MAXDOP =  ????’  with NAV 2009, 2013, 2015 ???? http://blogs.msdn.com/b/nav/archive/2015/06/03/sql-server-worker-threads-and-microsoft-dynamics-nav.aspx Configure the max degree of parallelism Server Configuration Option https://msdn.microsoft.com/en-us/library/ms189094.aspx?f=255&MSPPError=-2147217396 sp_configure ‘show advanced options’, 1; GO RECONFIGURE WITH OVERRIDE; GO sp_configure ‘max degree of parallelism’, 1; … Read more

SQL Server Worker Threads and Microsoft Dynamics NAV – Microsoft Dynamics NAV Team Blog – Site Home – MSDN Blogs

SQL Server Worker Threads and Microsoft Dynamics NAV – Microsoft Dynamics NAV Team Blog – Site Home – MSDN Blogs. by NAV Team Blog  Source NAV Team Blog   http://blogs.msdn.com/b/nav/archive/2015/06/03/sql-server-worker-threads-and-microsoft-dynamics-nav.aspx   Post Views: 1,003

%d bloggers like this: