After troubleshooting they found that when they run vssadmin list writers command from the command prompt, they are not seeing SqlServerWriter.
SQL SERVER – ISNUMERIC Function and Interesting Result
Let us learn, ISNUMERIC Function and Interesting Result. An interesting observation from my client of the Comprehensive Database Performance Health Check.
SQL SERVER – APPROX_COUNT_DISTINCT – Not Always Efficient
After a lot of testing, I figured out that the newly introduced function is not always efficient. A newly-introduced function APPROX_COUNT_DISTINCT.
SQL SERVER – Using NEWID vs NEWSEQUENTIALID for Performance
The first key column as uniqueidentifier datatype. In this blog post, we will discuss Using NEWID vs NEWSEQUENTIALID for Performance.
SQL SERVER – Getting Second Row from Table
The other day during one of my old clients sent me an email about if I know any trick to get the second row from the resultset.
SQL SERVER – PRINT Statement and Format of Date Datatype
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.
How to Skip Top N Rows in SQL Server? – Interview Question of the Week #237
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.