Let us learn, ISNUMERIC Function and Interesting Result. An interesting observation from my client of the Comprehensive Database Performance Health Check.
After a lot of testing, I figured out that the newly introduced function is not always efficient. A newly-introduced function APPROX_COUNT_DISTINCT.
The first key column as uniqueidentifier datatype. In this blog post, we will discuss Using NEWID vs NEWSEQUENTIALID for Performance.
we took a 5 minutes coffee break and during that short time, one of the DBA asked me a question about PRINT Statement and DataType.
Question: How to skip top N Rows in SQL Server and retrieve the rest of the rows? Answer: I had asked the above question in one of the interviews last week.
Today, we will see the solution to very interesting question received by Martha about Retrieving N Rows After Ordering Query With OFFSET.