Member since 1 year ago
8 ideas posted
15 comments 25 votes
3 votes
On Table Alters where the DBA is adding a new column and putting it into a specific ordinal position (not just the end) it would BEST to avoid lengthy insert (76million rows) by moving the INDEX creation to after the insert statement. Doing so could have hours on the insert if the table is wide as well as deep regardless of the hardware.
2 votes
To all: I recently was asked to come up with a simple script to describe a table/view column and is most useful ddl attributes. The below uses the INFORMATION_SCHEMA.COLUMNS which I happen to like for this purpose. It is very fast and very useful, I have submitted this to the Toad-SS idea pond so as to share the code. TDA and SQL Server user should give it a try. select table_name, Table_Schema,column_name, Ordinal_Position ...more »
To all:
I recently was asked to come up with a simple script to describe a table/view column and is most useful ddl attributes. The below uses the INFORMATION_SCHEMA.COLUMNS which I happen to like for this purpose.
It is very fast and very useful, I have submitted this to the Toad-SS idea pond so as to share the code. TDA and SQL Server user should give it a try.
select table_name, Table_Schema,column_name, Ordinal_Position
,DATA_TYPE
, isnull(cast(character_maximum_length as varchar(15)) ,'NA') as 'Char_Length' --- So as not to return nulls values.
, isnull(cast(NUMERIC_PRECISION as varchar(15)) ,'NA') as 'NUMERIC_PRECISION' --- So as not to return nulls values.
, isnull(cast(NUMERIC_SCALE as varchar(15)) ,'NA') as 'NUMERIC_SCALE' --- So as not to return nulls values.
, IS_NULLABLE
, isnull(cast(Column_Default as varchar(15)) ,'NA') as 'Column_Default'
from INFORMATION_SCHEMA.COLUMNS a
where table_name = 'MeterInventory' -- order by 3
« less full details »
3 votes
DMV are becoming quite popular and have a tab or groups or snippit section of DMV (Dynamic Management Views) would elevate Toad-SS into the next level already being explored by othe vendors such as RedGate and Ideara
2 votes
Please consider the optional column (Last_User_Update) to add to the object explorer table tab. Attached is a spreadsheet show how I use the information and the script I use and support to get this information. There are additional columns in my script I find useful and they could also be possible candidates for inclusion. See Table imformation utility on my skydrive.. https://skydrive.live.com/?cid=41688356FB6246ED&id=41688356FB6246ED%21212&sc=documents#cid=41688356FB6246ED&id=41688356FB6246ED%21212&sc=documents ...more »
Please consider the optional column (Last_User_Update) to add to the object explorer table tab.
Attached is a spreadsheet show how I use the information and the script I use and support to get this information.
There are additional columns in my script I find useful and they could also be possible candidates for inclusion.
See Table imformation utility on my skydrive..
« less full details »
4 votes
The Import wizard allow for the addition of a new field, but it doen't allow the new field to placed in a different column location. Therefore this is either a bug or a new feature.
2 votes
Please consider adding the Identity declaration value to the Data type column in Object Explorer or making an optional column for same. It is just as important information as default value.
3 votes
Allow the ability to process sequential batch section in a script file in asynchronous as well as sequentially. This is like a ETL process where you have the horse power to process alot, but you don't want to segregate the batches into seperate editor sessions.
4 votes
The XML file (.tim) should allowed to edited on the Toad editor, so that minute changes can be made. Currently I do this outside of toad and it is time to allow for easity edits of these file types.
To Toad for SQL Server community
Social Web