Skip to content

Obscure Problems and Gotchas

If you couldn't find your answer to your weird problem, you might find it here.

  • About
  • Application Errors Hall of Shame
  • DyslexicApps
Development, SQL Server

Biases in naming database objects

by: admin2020-08-01

Introduction Over my whole software engineering career, I have watched and learned the right way and the wrong way to style and format code. Especially […]

Development, SQL Server

Pivoting data without an aggregation column

by: admin2019-10-18

Don’t use PIVOT for non-aggregate-able data I ran into a rather displeasurable experience where a separate team of people built some very important tools for […]

Development, Gotcha, SQL Server

Padding a string in tSQL

by: admin2019-02-04

Gotcha There isn’t a Pad Left or Pad Right function in tSQL. Solution There is a lengthy discussion about this topic already on Stack Overflow […]

Development, SQL Server

Incorrect syntax was encountered while parsing :SETVAR

by: admin2018-11-29

Gotcha When working with SQL CMD mode every now and then I will get this vague error and I can’t figure out what the problem […]

SQL Server

Avoiding the Red Gate Sql compare “Non-Schema statement was ignored” warning

by: admin2018-10-18

Gotcha I recently had to create some non-schema related objects for a database project I am working on. It caused an annoying problem with Red […]

Gotcha, SQL Server

Sql Server REPLACE function makes expression string NULL when replacement string is NULL

by: admin2018-02-05

Obscure problem This has happened to me before, but naturally I forgot because it has been a while. The scenario is that you have dynamic […]

SQL Server

How to find the current profile required to send an email in SQL Server

by: admin2016-12-25

Problem You are trying to send an email using “msdb..sp_send_dbmail” but you keep getting one of the following errors: Msg 14636, Level 16, State 1, […]

SQL Server

SQL Server rows appear to not be deleting

by: admin2016-11-23

The Stupid Problem You are working on a database that you are not very familiar with as a developer – meaning that you are not […]

Uncategorized

Sql Server tSql: DELETE statement executes but won’t delete

by: admin2016-07-17

Problem I ran into the most puzzling issue recently where I was executing a DELETE statement inside of a transaction among other statements inside of a stored procedure. […]

Uncategorized

I have no words for how bad this is

by: admin2015-02-26

I think this should win the “Most Horrible Sproc Parameters” contest if there were such a thing. And then people wonder why I get mad […]

Posts navigation

Older posts

Search posts

Happy find? Help me buy the coffee that fuels these articles!

Like what you are reading?

It takes time to write these quality blog posts and sometimes software. Maybe something I have written has benefited you? Blog posts can take anywhere from a few minutes, to a couple of hours, to several days to construct. Software is a constant work in progress. Want to help me buy my next bag of coffee?

Anything is appreciated

Categories

Recent Comments

  • Unable to connect to database with .NET Core 3.1 File System Publish to IIS on DotNet Core EF migration not working
  • Oceane on Offline installation of Microsoft Machine Learning server components SQL 2019 is stuck
  • admin on Offline installation of Microsoft Machine Learning server components SQL 2019 is stuck
  • Chris on Offline installation of Microsoft Machine Learning server components SQL 2019 is stuck
  • admin on Offline installation of Microsoft Machine Learning server components SQL 2019 is stuck

Archives

Search posts

Search posts

SSL Secure

Copyright © All rights reserved. Theme Creativ Mag by Creativ Themes