Question: Which is Faster – INSERT INTO SELECT or SELECT INTO?
What is Lock Pages In Memory? – Interview Question of the Week #186
Question: What is Lock Pages In Memory?
How to Identify Process ID for SQL Server Services? – Interview Question of the Week #185
Question: How to Identify Process ID for SQL Server Services?
How to Check Status of Instant File Initialization? – Interview Question of the Week #184
Question:Â How to Check Status of Instant File Initialization?
Answer: This is a follow-up question of the previous blog post which I shared earlier. Please read this blog post before reading this blog for complete information: How to Check If Instant File Initialization Enabled or Not?
How Old Version of SQL Server Running on Server? – Interview Question of the Week #183
Question:Â How Old Version of SQL Server Running on Server?
How to Convert Hex Windows Error Codes to the Meaningful Error Message – 0x80040002 and 0x80040005 and others? – Interview Question of the Week #182
This blog is not specific to SQL Server, but I have recently seen hex error codes in SQL Server ERRORLOG and it took me little time to get the meaning of it. In this blog, we would learn about how to convert a hex windows error codes to meaningful error messages.
How to Generate Random Password in SQL Server? – Interview Question of the Week #181
Question:Â How to Generate Random Password in SQL Server?
Answer: This is a fantastic question and here is the script to generate a random password in SQL Server