Posts in "Database"

01

May

2013

Why too much Database Normalization can be a Bad Thing

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

07

Jan

2011

Date only in SQL

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

30

Dec

2010

Remove Leading Zeros from SQL Table

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

11

Jun

2009

Local Temporary Table

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

10

Feb

2009

BizTalk SQL Agent Jobs

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

09

Feb

2009

Archiving and Purging the BizTalk Tracking Database

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

  • Page 1 of 2
  • 1
  • 2
  • >