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
432 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
12,288 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
7,760 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
15,800 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
581 reads
Blogs
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Forums
Why SQL Server Database Attach fails and how to repair it
Comments posted to this topic are about the item Why SQL Server Database Attach...
Fixing P1 Queries
Comments posted to this topic are about the item Fixing P1 Queries
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers