I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that Look Too Easy. I decided to give you a few thoughts from me on the SUM one. Another post for me that is simple and hopefully serves as an example for people trying to get…
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that Look Too Easy. I decided to give you a few thoughts from me on the SUM one. Another post for me that is simple and hopefully serves as an example for people trying to get…
I was creating a question on sp_readerrorlog and realized that this procedure is different from the one it wraps: xp_readerrorlog. This post digs into a few differences. Another post for me that is simple and hopefully serves…
I was creating a question on sp_readerrorlog and realized that this procedure is different from the one it wraps: xp_readerrorlog. This post digs into a few differences. Another post for me that is simple and hopefully serves…
I was trolling the docs and noticed the SIGN() function. I have never written this in production code, but it is an interesting function. This post looks at where I might use this and when the need arises. Another post for me that is simple and hopefully…
I was trolling the docs and noticed the SIGN() function. I have never written this in production code, but it is an interesting function. This post looks at where I might use this and when the need arises. Another post for me that is simple and hopefully…
Someone asked why I would use TRY_PARSE after I posted a question at SQL Server Central: Getting the Average. Isn’t is slower? A fair question. This quick post looks at why. Another post for me that is simple and hopefully serves as an example for people trying…
Someone asked why I would use TRY_PARSE after I posted a question at SQL Server Central: Getting the Average. Isn’t is slower? A fair question. This quick post looks at why. Another post for me that is simple and hopefully serves as an example for people trying…
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve never tried it, but the batch separator has to be separate, which I’ll show. Another post for me that is simple and hopefully serves as an example for people…
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve never tried it, but the batch separator has to be separate, which I’ll show. Another post for me that is simple and hopefully serves as an example for people…
While wandering around the documentation looking for some Question of the Day topics, I learned something new about the money data type. This post discusses what I learned. Another post for me that is simple and hopefully serves as an example for people trying to get…
While wandering around the documentation looking for some Question of the Day topics, I learned something new about the money data type. This post discusses what I learned. Another post for me that is simple and hopefully serves as an example for people trying to get…
While writing another post I realized my UNION query didn’t work as one might initiall expect, so I decided a short post was worth writing. This is based on a previous post on QUOTENME(). Another post for me that is simple and hopefully serves as an example for…
While writing another post I realized my UNION query didn’t work as one might initiall expect, so I decided a short post was worth writing. This is based on a previous post on QUOTENME(). Another post for me that is simple and hopefully serves as an example for…
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks at how the proc works. Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. The…
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks at how the proc works. Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. The…
I’m not sure I knew identity column values could not be updated. I ran into this while trying to solve a problem recently and had to check the error I was getting. This post shows what happened. Another post for me that is simple and hopefully…
I’m not sure I knew identity column values could not be updated. I ran into this while trying to solve a problem recently and had to check the error I was getting. This post shows what happened. Another post for me that is simple and hopefully…