SQL Server Education (by the geeks, for the geeks)
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 …
SQL Server 2014 – New DMV sys.dm_exec_query_profiles Read MoreHi 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 …
SQL Server 2014 Trace Flags 9481 Read MoreHi 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 …
SQL Server 2014 Cardinality Estimator for databases created in lower version Read MoreHi 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 …
SQL Server 2014 Cardinality Estimation : Using New Cardinality Estimator Read More