His question was about their database Logs, which were Full and they Can’t Switch Recovery Models. Let us discuss this problem today.
I faced another issue that my Camera stopped working. Let us see what today’s video SQL Performance Troubles – Execution Plans – Live 2.
I got lots of feedback about my audio setup and the video configurations. I have planned another live session Performance Troubles – Execution Plans.
After the blog posts, lots of people asked me to build a video so here is the video discussing the topic of Tuning Query Cost 100%.
I was recently called an interesting scenario by my client. Let us learn today Correcting Space Allocation with DBCC UPDATEUSAGE.
It is not possible to use CASE Expression in Default Values when you add a new column. I hope this answers the question. However, there is a workaround.
The challenge I face is that often DBAs ask me to prove that indexes are really not used by queries. Let us learn about Queries Using Specific Index.