As someone with a long history in database optimization and who even did their Master’s project on Database normalization,...

In many case, you might want to get the date only out of table with time, here is the simple way to achieve it:   ...

You might have a situation that you need to remove all leading zeros from one column in table, from now on, we call this...

Here is a simple to create and drop temp tables: to think that ALL temp tables reside in tempdb database, not releated to...

Execution of the BizTalk Server SQL Agent jobs are crucial for managing the BizTalk Server databases and for maintaining...

As BizTalk Server processes more and more data on your system, the BizTalk Tracking (BizTalkDTADb) database continues to...