What enhancements have been to the 2012 GUI that facilitates faster coding, etc.

Question

What enhancements have been to the 2012 GUI that facilitates faster coding, etc.

Welsh Corgi

SSC Guru

Points: 116520
More actions
June 25, 2014 at 1:12 pm

#287158

What enhancements have been to the 2012 GUI (Client only) that facilitates faster coding, etc.?
I appreciate you feedback.:-)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 12 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

Sean Lange SSC Guru Points: 286609 More actions · Answer 1

Welsh Corgi (6/25/2014)
What enhancements have been to the 2012 GUI (Client only) that facilitates faster coding, etc.?
I appreciate you feedback.:-)

Faster coding would be achieved by not using the GUI for anything resembling writing code. The quickest way to write code is in a query window. The GUI is useful for some things but coding is not one of those. Learn to write the t-sql yourself and you will be shocked at how fast you can get.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

Sean Lange (6/25/2014)
Welsh Corgi (6/25/2014)
What enhancements have been to the 2012 GUI (Client only) that facilitates faster coding, etc.?
I appreciate you feedback.:-)
Faster coding would be achieved by not using the GUI for anything resembling writing code. The quickest way to write code is in a query window. The GUI is useful for some things but coding is not one of those. Learn to write the t-sql yourself and you will be shocked at how fast you can get.

Thank you. That is the way I do it. I do not use the GUI.

I write everything in T-SQL Code and I have found that I learn more and I do not find the GUI as being faster. I wanted to make sure I was right before my response. Thank you!

I was challenged by some BA that wanted me to reinstall SQL Server 2012 Evaluation Edition. I refused. That is illegal.

She only needs the Client but we have no licenses for 2012. She has SQL Server 2008R2. I don't think that I will hurt her performance by telling her that she has to use SQL Server 2012. I hope to upgrade soon but she should be able to get by in the meantime.

I'm not a proponent of using the GUI. You have to grant them the db_owner role to create objects in design mode.

You just validated my thoughts on this.

Any more thoughts on this would be greatly appreciated.

Thanks again.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 3

How much easier would it be for someone that uses the GUI to generate code using 2012 over 2008R2?

They tell me know that they do not use the query designer that much. :hehe:

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Sean Lange SSC Guru Points: 286609 More actions · Answer 4

Welsh Corgi (6/25/2014)
How much easier would it be for someone that uses the GUI to generate code using 2012 over 2008R2?
They tell me know that they do not use the query designer that much. :hehe:

I have no idea because I don't use the GUI to create code. Using the query designer at all is too much imho. 🙂

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 5

Sean Lange (6/25/2014)
Welsh Corgi (6/25/2014)
How much easier would it be for someone that uses the GUI to generate code using 2012 over 2008R2?
They tell me know that they do not use the query designer that much. :hehe:
I have no idea because I don't use the GUI to create code. Using the query designer at all is too much imho. 🙂

Thank you. I agree with you totally.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Grant Fritchey SSC Guru Points: 399278 More actions · Answer 6

There are some minor improvements to code completion in the query window if that's the kind of thing you're looking for. They've also added some typing functionality that's useful. You can use "Surround with" on a highlighted piece of code to set up a BEGIN/IF/WHILE statement. Insert snippet also works a little better. Those are the only coding enhancements I'm aware of in 2012, talking about aids to writing code.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 7

Grant Fritchey (6/25/2014)
There are some minor improvements to code completion in the query window if that's the kind of thing you're looking for. They've also added some typing functionality that's useful. You can use "Surround with" on a highlighted piece of code to set up a BEGIN/IF/WHILE statement. Insert snippet also works a little better. Those are the only coding enhancements I'm aware of in 2012, talking about aids to writing code.

I'm not looking for it. Some BA challenged me why she needed 2012.

I'm eager to go to 2012 but I do not believe there will be a significant difference going from the Client 2008RS to 2012.

Perhaps I'm wrong.

Thank you.:-)

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Eirikur Eiriksson SSC Guru Points: 182948 More actions · Answer 8

My 2 cents on this, GUI generated code is not always forward compatible, I.e. the semicolon termination is missing.

😎

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 9

Eirikur Eiriksson (6/25/2014)
My 2 cents on this, GUI generated code is not always forward compatible, I.e. the semicolon termination is missing.
😎

I do not like GUI generated code.

I do not use it.

Developers use it and my awesome boss uses it.

Thank you.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 10

Thanks for the feedback from everyone.:-)

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Robert Klimes SSCoach Points: 17865 More actions · Answer 11

If the BA only needs SSMS why not install SSMS 2012 express. I don't believe there is any missing functionality.

You can download the file ENU\x64\SQLManagementStudio_x64_ENU.exe from http://www.microsoft.com/en-ca/download/details.aspx?id=29062

There is also SSDT http://msdn.microsoft.com/en-ca/data/tools.aspx

Bob
-----------------------------------------------------------------------------
How to post to get the best help[/url]