Capture attention events for canceled requests, read event-file XML, compare Query Store aborts, and inspect transaction cleanup.
How to Combine Time and Date in SQL SERVER? – Interview Question of the Week #285
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.