When we have to move a database from one server to another server or when we have to move a database from one file to another file, we commonly use Database Attach or Detach process. I have been doing this for quite a while as well. Recently, when I was visiting an organization I found that in this organization lots of developers are still using an older version of the code to attach the database. I quickly pointed that out to them the new method to attach the database, however it was really interesting to find out that they really did not know that sp_attach_db is now a deprecated method to attach the database. This really made me to do today’s SQL in Sixty Seconds. I demonstrate in this SQL in Sixty Seconds how to attach or detach the database using a new method of attaching database. Let us learn about Attach or Detach Database.
SQL SERVER – Planned and Unplanned Availablity Group Failovers – Notes from the Field #031
[Note from Pinal]: This is a new episode of Notes from the Fields series. AlwaysOn is a very complex subject and not everyone knows many things about this. The matter of the fact is there is very little information available on this subject online and not everyone knows everything about this. This is why when a very common question related to AlwaysOn comes, people get confused. Let us learn about Planned and Unplanned Availablity Group Failovers.
SQL SERVER – Parsing SSIS Catalog Messages – Notes from the Field #030
SQL SERVER – Fix – Agent Starting Error 15281 – SQL Server blocked access to procedure ‘dbo.sp_get_sqlagent_properties’ of component ‘Agent XPs’ because this component is turned off as part of the security configuration for this server
SQL SERVER – CTE can be Updated
SQL SERVER – DMV to Identify Incremental Statistics – Performance improvements in SQL Server 2014 – Part 3
This is the third part of the series Incremental Statistics. Here is the index of the complete series.
What are Incremental Statistics? – Performance improvements in SQL Server 2014 – Part 1
Simple Example of Incremental Statistics – Performance improvements in SQL Server 2014 – Part 2
DMV to Identify Incremental Statistics – Performance improvements in SQL Server 2014 – Part 3
SQL SERVER – Simple Example of Incremental Statistics – Performance improvements in SQL Server 2014 – Part 2
This is the second part of the series Incremental Statistics. Here is the index of the complete series.