One of the most popular questions I received during my SQL Server Performance Tuning Practical Workshop is how users can run sets of procedure when their SQL Server starts automatically. Today, let us see a simple tutorial to run stored procedure at server startup.
Can You DROP Offline Database? – Interview Question of the Week #144
Question:Â Can You DROP Offline Database?
SQL SERVER – Empty Startup Parameters in SQL Server Configuration Manager
While testing a scenario for my client, I ran into a behavior which I was not aware of. Let us learn about the error which is related to Empty Startup Parameters in SQL Server Configuration Manager.
SQL SERVER – Msg 1038 – An Object or Column Name is Missing or Empty. For SELECT INTO Statements, Verify Each Column Has a Name
Along with my freelance work as an independent consultant, I do keep an eye on various forums and look at issue reported with solutions so that I can blog about them to help the community. One of the Facebook group where I am active is SQLBangalore and recently once of the member posted an issue. He was trying to create a login using SQL Server Management Studio and getting error for SELECT INTO statement as below.
SQL SERVER – RETAINDAYS Does Not Delete Backup After x Days
Just the other day one of my customers asked me that they are facing a situation where they have specified in their backup script RETAINDAYS option but it is actually not deleting their older database backups.Â
SQL SERVER – 5 Don’ts When Database Corruption is Detected
Here is an email I received about database corruption and that has lead me to write this quick blog post about database corruption.Â
Data Starvation – Balance Your SQL Server – Part 1
With the new Intel Skylake CPUs coming out recently it seemed like a good time to discuss CPU resources and how to know if they’re running optimally. After all, there’s little sense in upgrading your server if your current one is already data starved. Let us learn about how to balance your SQL Server facing data starvation.Â
SQL SERVER – Unable to Start SQL Server – TDSSNIClient Initialization Failed with Error 0x2, Status Code 0x38
I just love my On Demand offering because it gives me more pleasure of assisting clients who are in urgent need of an SQL expert. Most of the time I am called for help when clients are not able to start SQL Service due to some reason. Today we will see how to fix an error which is about unable to start SQL Server.
How to Create Primary Key Without ANY Index? – Interview Question of the Week #143
Question: How to Create Primary Key Without ANY Index?
SQL Authority News – SQL Server 2012 Service Pack 4 Released
It has been a while since I stopped writing about Service Packs announcements, I believe those who needs to always keep track of this and do not need to know via a separate blog post. With that said, I personally do not believe in any such kind of restrictions at all. I believe we should do what we believe will help others. For the same reason, we are reading a blog post about SQL Server 2012 Service Pack 4 Released.Â