Generating multi-part names (four-part, three-part or two-part) for database objects and interpreting them can be labour intensive at times. This post provides scripts that can be used to reduce the manual effort required for these activities...

Generating multi-part names (four-part, three-part or two-part) for database objects and interpreting them can be labour intensive at times. This post provides scripts that can be used to reduce the manual effort required for these activities...

Generating multi-part names (four-part, three-part or two-part) for database objects and interpreting them can be labour intensive at times. This post provides scripts that can be used to reduce the manual effort required for these activities...

Most database documentation and code fail to address name resolution errors – i.e. the ability to ensure that a name uniquely identifies a database object. This post provides an introduction to four-part, three-part and two-part database object naming c...

Most database documentation and code fail to address name resolution errors – i.e. the ability to ensure that a name uniquely identifies a database object. This post provides an introduction to four-part, three-part and two-part database object naming c...

...

...

Most database documentation and code fail to address name resolution errors – i.e. the ability to ensure that a name uniquely identifies a database object. This post provides an introduction to four-part, three-part and two-part database object naming c...

Recently, I was working with a developer colleague of mine to troubleshoot an issue he had with one of his queries. A stored procedure he wrote was consuming data from another procedure and was not functioning as expected. I suspected the issue to be a ...

Recently, I was working with a developer colleague of mine to troubleshoot an issue he had with one of his queries. A stored procedure he wrote was consuming data from another procedure and was not functioning as expected. I suspected the issue to be a ...