Question: How to Combine Time and Date in SQL SERVER?
Answer: A very simple and popular question. Let us learn together.
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 – Creating System Admin (SA) Login With Empty Password – Bad Practice
An empty password on sa is a serious security failure. I stopped an e-commerce consultation after noticing passwordless administrator sign-ins.
Does BIT Datatype Equal to 1 or TRUE in SQL Server? – Interview Question of the Week #282
Question: Does BIT Datatype Equal to 1 or TRUE in SQL Server?
Answer: Very interesting question. Let us learn about it today.
SQL SERVER – Queries Waiting for Memory Grant – Performance Tuning
Queries Waiting for memory grants give me evidence to investigate. A customer CTO requested that evidence before approving more RAM.
SQL Puzzle – IN and IS NOT NULL – Strange Results
Today, let us see a very simple puzzle where we are getting strange results when using NOT IN and IS NULL in a T-SQL query.