Question: How to Combine Time and Date in SQL SERVER?
Answer: A very simple and popular question. Let us learn together.
SQL SERVER – Computed Column and Compute Scalar Operators
One of my clients recently asked me a very interesting question about the computed column and Compute Scalar Operators. Let us learn about it today.
SQL Puzzle – Solution to Strange Results – IN and IS NOT NULL –
Earlier I had published a blog post about a puzzle SQL Puzzle – IN and IS NOT NULL – Strange Results. Today we will see a solution to strange results puzzle.
What does Verify Backup When Finished do in SQL Server? – Interview Question of the Week #283
Question: What does Verify Backup When Finished do in SQL Server? It looks like a very important step in the entire backup and restores.
SQL SERVER – Adding Default Value to Existing Table
While my primary focus is on SQL Server Performance Tuning, we will see questions related to adding default value to the existing table.Â
SQL SERVER – Creating System Admin (SA) Login With Empty Password – Bad Practice
I realized that their DBAs are logging into their server with a blank or empty password. This is an extremely Bad Practice. Let us discuss it today.Â
SQL SERVER – Disable Statistics Update on a Specific Table
Just earlier today when we were fixing the performance of a database during, we found a unique requirement to disable statistics update on a table.