I should have been more explicit.  The main advantage is people can communicate using (and short-term memorize) the trigesimal geocode much easier than the Lat/Lon DD Coordinates. The trigesimal geocode...

• This reply was modified 2 years, 1 month ago by  Todd M. Owens.
• This reply was modified 2 years ago by  Todd M. Owens.
• This reply was modified 2 years ago by  Todd M. Owens.

Death to char(9) in SQL code:

1. Indented code characters will move one space, more than one space (depending on what user preference was) or not at all when inserting/deleting...

We share a peeve.

My...

To suppress Min, Max and Modal Values, a CASE statement or an OUTER JOIN on data_types is needed in the SQL string area. If I had time I would...

sqlpanther (2/19/2013)

---

1. Will cloud computing consume DBA jobs.

2. Is there a way I can do some cloud computing courses which will be related to DBA, I heard about hadoop, and...

Thanks!

Uhoh..

SteveBell (2/20/2013)

---

1. Can it be modified to loop through all tables in a...

Thanks Steve

I am not guaranteeing anything because I never allow use of varchar(max) and have no way to test it, BUT

for Varchar(max) types to work, change this statement:

CREATE TABLE...

Thanks forgot about bit. This should work on bit (other data types?) as well...

DECLARE @Cat_Sch_TableName varchar(128) = 'HRIS.dbo.E20130201'

-- Initialize fully qualified object name; script can be used like a...

Glad someone found it helpful. Here is an update that includes (Distinct) Value Counts:

DECLARE @Cat_Sch_TableName varchar(128) = 'HRIS.NTC.D20130201'

-- Initialize fully qualified object name; script can be used like a...

archived link.

http://web.archive.org/web/20050723022626/http://www.dbazine.com/db2/db2-disarticles/gulutzan5

Jim -

What does the tool cost? Is there maintenance? How much time did it save on the first use and how much is it likely to save in...

But a fixed-width column (numeric types, date/time types, and char/nchar/binary types) will always take up the same amount of space regardless if it is set to NULL or...

Oh another thing that chews up space is thoughtlessly adding or misusing a set of audit columns to every single table regardless of how the table is used. For...

I know I am a few months late to this game, but I wanted to give you a compliment and issue a small caveat.

Compliment: great article. It is reassuring,...