T-SQL Developer Interview Questions with Answers
What SQL command do you use to pull and filter data from a table ?
SELECT [Column List] FROM [Table Name]...
2018-04-20
415 reads
Generate SQL script to extract user permissions from a SQL database
When you restore a database, it will also restore all permissions along with it. But what if you are restoring...
2018-04-19
11,046 reads
How to check whether and when sql index statistics were updated last time?
I was working for a client on their very critical and heavily used database. The application was an E-commerce website...
2018-04-19
4,645 reads
How to start SQL Server job using TSQL and wait for it to complete?
If you ever had a need to start a SQL job using sp_start_job stored procedure in msdb then you know...
2018-04-19
14,508 reads
SQL server database size, location and volume info
For one of my clients, I needed to know and document not only database names, size and locations but also...
2018-04-19
563 reads
Blogs
The trade-offs associated with low-code solutions
Low-code solutions often accelerate development and make tasks accessible to people who can’t or...
Monday Monitor Tips: Looking Back in Time
By Steve Jones
Often we find out about a problem reported by a customer after the incident...
Can You Tell Why a Plan Didn’t Go Parallel?
Let’s face it, most of the time, you probably don’t want your SQL Server...
Forums
Improving the Performance of UPDATE Statements in SQL Server
Comments posted to this topic are about the item Improving the Performance of UPDATE...
Replacing a Null
Comments posted to this topic are about the item Replacing a Null
The End of SQL Server 2019
Comments posted to this topic are about the item The End of SQL Server...
Question of the Day
Replacing a Null
What is returned from this code in SQL Server 2022?
DECLARE @value INT = NULL; SELECT ISNULL(@value, 100.5) AS Result;See possible answers