This is the first part of the series Incremental Statistics. Here is the index of the complete series. Let us learn it together in the blog.
SQL SERVER – Tools for Proactive DBAs – Central Management Server – Notes from the Field #024
[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…
Read More
SQL SERVER – Calculating XIRR in SQL Server – Internal Rate of Return Available
Note: Download the XLeratorDB to play along this blog post. XIRR is a widely-used used financial calculation that lends itself to evaluating the rate of return on either historic cash flows or anticipated future cash flows. Thus it is a tool that can be used to measure investment performance or…
Read MoreSQL SERVER – Drop All the Foreign Key Constraint in Database – Create All the Foreign Key Constraint in Database
Earlier I wrote a blog post about how to Disable and Enable all the Foreign Key Constraint in the Database. It is a very popular article. However, there are some scenarios when user needs to drop and recreate the foreign constraints. Here is a fantastic blog comment by SQL Expert…
Read More
SQL SERVER – Finding Last Backup Time for All Database – Last Full, Differential and Log Backup
About four years ago, I wrote a blog post where I posted a script about finding backup time for all the databases. You can see the blog post over here SQL SERVER – Finding Last Backup Time for All Database. It has been a very popular script. However, this script was just giving details about last full backup time. SQL Expert Sravani has posted a fantastic script which also displays last full, differential and log backup for the database.
SQL SERVER – Say No to DB Data Roles – SQL Security – Notes from the Field #022
[Note from Pinal]: This is a 22nd episode of Notes from the Field series. Security is very important and we all realize that. However, when it is about implementing the security, we all are not sure what is the right path to take. If we do not have enough knowledge, we can damage ourself only. DB Data Roles are very similar concept, when implemented poorly it can compromise your server security.
MySQL – List User Defined Tables – Two Methods
There are different methods to list out user defined tables in MySQL. We will see two methods in this post.
Let us create the following tables in the database named Test