Next time you have a long running process and want to know the percent complete, utlize this handy T-SQL script. Be sure to check out theother MSSQLTips related to the SQL Server Dynamic Management Objects. Finding a SQL Server process percentage complete with DMVs No...
SQL -- Monitor active queriesSELECT*FROMsys.dm_pdw_exec_requestsWHEREstatusnotin('Completed','Failed','Cancelled')ANDsession_id <> session_id()ORDERBYsubmit_timeDESC;-- Find top 10 queries longest running queriesSELECTTOP10*FROMsys.dm_p...
Most database performance issues can be attributed to suboptimal query patterns, but in many cases running inefficient queries will put undue pressure on your hardware. For example, missing indexes could lead to CPU, storage, and memory pressure by retrieving more data than is required to p...
gaining valuable knowledge of database structures, practices, principles and theories. His experience also includes.NET development, working with database applications, scripting and creating SQL queries and views. His personal abilities include having very...
Faster WMI queries Fastest way to Delete millions and millions of files in spread throughout 10000 users File copy from network share to current server from for each area File copy operation from PowerShell that displays "Copy files" dialog File copy over network using a specific NIC File permi...
caused problematic execution plan patterns prior to SQL Server 2017. Many developers like to use multi-statement table valued functions because they can execute multiple queries within a single function and aggregate the results into a single table. However, anyone writing T-SQL code needs to...
Later, when you plan your Configuration Manager deployment, pay attention to the more detailed information of the logical structure, such as the organizational units, because these can help determine how you organize collections, distribute software, and perform queries in Configuration Manager. Use...
As you can see using these simple queries through myCentral Management ServerI was able to get everything up to current standards by fixing incorrect email addresses, identifying servers that are missing the operator, as well as obsolete operators that are not being used. Once I was finishe...
Prevent slow queries by avoiding distribution on these types of columns or filtering your query to eliminate NULLs when possible.If the query is running, you can use DBCC PDW_SHOWEXECUTIONPLAN to retrieve the SQL Server estimated plan f...
SQL -- Monitor active queriesSELECT*FROMsys.dm_pdw_exec_requestsWHEREstatusnotin('Completed','Failed','Cancelled')ANDsession_id <> session_id()ORDERBYsubmit_timeDESC;-- Find top 10 queries longest running queriesSELECTTOP10*FROMsys.d...