Another round of tips is now complete. I have listed all of the tips ( numbers 21 – 40 ) below. You can view a list of the tips from round one which were posted in November 2008. The tips are categorized making it easy to filter on ARC, SQL or server tips.
- Shrink a Column with a Right-Click
- Exporting SQL Results
- Parsing the Query Execution Plan
- Resizing the SQL Execution Plan Display
- Creating Additional Connections to the Same Data Dictionary
- Input Variable in SQL Stored Procedures
- Get a List of Available System Procedures
- Create Users With SQL Statements
- Modifying Users and Groups with SQL Statements
- Modifying Permissions with SQL Statements
- Assigning Permissions for Multiple Database Objects
- ARC Opens Off Screen
- Generate SQL Scripts for Database Objects
- Using the Data Dictionary Differentiator
- Generating SQL Scripts for Free Tables
- Pack and Zap Tables Using SQL
- Using ApplicationID
- Getting Index Information via SQL
- Full Text Search Indexes via SQL
- Using sp_CreateIndex
I am working on gathering another set of tips to be run in the future. I hope you got something useful from this group of tips and as always feel free to add your comments and suggestions.
No comments:
Post a Comment