SQL Server 2014 – New DMV sys.dm_exec_query_profiles
Hi Friends, A new DMV that is provided by Microsoft to check the progress of any long running time taking query i.e. sys.dm_exec_query_profiles. We all know that when we submit a …
Read MoreTag: Cardinality Estimator
SQL Server 2014 Trace Flags 9481
Hi Friends, In my previous blogs we have seen how we can use new cardinality estimator. Link for those blogs are mention here : Link1 and Link2. Now I am using …
Read MoreSQL Server 2014 Cardinality Estimator for databases created in lower version
Hi Friends, In our previous blog we have seen how we can use new SQL Server 2014 cardinality Estimator for newly created databases under SQL Server 2014.Link for that blog is …
Read MoreSQL Server 2014 Cardinality Estimation : Using New Cardinality Estimator
Hi Friends, Are you facing any issue on SQL Server 2014 while running the same query which is running fine on previous version of SQL Server? If answer is yes then …
Read More