SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


What Do We Want?


What Do We Want?

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (145K reputation)SSC Guru (145K reputation)SSC Guru (145K reputation)SSC Guru (145K reputation)SSC Guru (145K reputation)SSC Guru (145K reputation)SSC Guru (145K reputation)SSC Guru (145K reputation)

Group: Administrators
Points: 145088 Visits: 19424
Comments posted to this topic are about the item What Do We Want?

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
crazyEmu
crazyEmu
SSC Journeyman
SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)

Group: General Forum Members
Points: 94 Visits: 686
How about better admin / monitoring tools. I know that 2008 R2 is a step in the right direction with the UCP… however it is only available for customers with Enterprise… what about those with Standard.

Something like the Oracle Enterprise Manager + Diagnostic pack would be great.

Blog: http://crazyemu.wordpress.com/
Twit: @crazySQL
kennethje
kennethje
SSC Journeyman
SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)

Group: General Forum Members
Points: 85 Visits: 95
at the risk of sounding not very important:

I'd very much like to see 3 changes in the sql language taken from Oracle (I know, I know, I said the O word)

1. CREATE and ALTER:
instead of CREATE view/table/whatever:
and ALTER view/table/whatever:
in 1 statement
CREATE OR ALTER... (as oracle's CREATE OR REPLACE)

2. cursor functionality:
instead of :
declare @var1 nvarchar(10)
declare cur cursor for select myColumn from myTable
open cur
fetch next from cur into @var1
etc, etc


this is much handier:
declare cur cursor for select myColumn from myTable
for rec in cur
print rec.myColumnName
loop

3. detecting the type from table definition
eg:
MyTable has a myColumn nvarchar(10)
a stupid insert procedure would have to declare the paramter as nvarchar(10)
eg: create myProc (@col1 nvarchar(10)) ...

--> create myProce (@col1 MyTable.MyColumn%TYPE)
when the type of myColumn changes there is no need to change the procedure!

anyway, minor changes but they could make my life a bit easier
george sibbald
george sibbald
SSC-Insane
SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)

Group: General Forum Members
Points: 24356 Visits: 13698
This one is very basic and simple but seems a complete no-brainer to me:

the ability to specify who the owner of the jobs will be when creating\amending maintenance plans.

Then you wouldn't have to go through and amend all the job owners afterwards (and every time you amend a plan). That is sooooooo irritating.

---------------------------------------------------------------------
blandry
blandry
SSC Eights!
SSC Eights! (971 reputation)SSC Eights! (971 reputation)SSC Eights! (971 reputation)SSC Eights! (971 reputation)SSC Eights! (971 reputation)SSC Eights! (971 reputation)SSC Eights! (971 reputation)SSC Eights! (971 reputation)

Group: General Forum Members
Points: 971 Visits: 723
For me? Simple...

SQL Prompt and SQL Search from Redgate.

I have never understood why these great interface-enhancing, functionality-expanding, and time-saving interface features have never become a base part of SQL Server.

There's no such thing as dumb questions, only poorly thought-out answers...
WI-DBA
WI-DBA
SSChasing Mays
SSChasing Mays (608 reputation)SSChasing Mays (608 reputation)SSChasing Mays (608 reputation)SSChasing Mays (608 reputation)SSChasing Mays (608 reputation)SSChasing Mays (608 reputation)SSChasing Mays (608 reputation)SSChasing Mays (608 reputation)

Group: General Forum Members
Points: 608 Visits: 605
I would like to see greater admin ability at the database level - and the ability to lock that down to the server level. Many app teams want lots of abilities in their specific databases, but even in 2008, you can't give someone bulk insert privs for a DB. Server Admins manage the disk space, etc and then each database can have an admin as well.

My second choice would be able to have SQL run on Linux or some other barebones OS so the server's sole mission is running SQL.

Cheers
http://twitter.com/widba
http://widba.blogspot.com/
BobAtDBS
BobAtDBS
SSC Eights!
SSC Eights! (914 reputation)SSC Eights! (914 reputation)SSC Eights! (914 reputation)SSC Eights! (914 reputation)SSC Eights! (914 reputation)SSC Eights! (914 reputation)SSC Eights! (914 reputation)SSC Eights! (914 reputation)

Group: General Forum Members
Points: 914 Visits: 365
I think each time someone types "architecting" in an article they should have to write on a blackboard 100 times "architecting something is the same thing as designing something but the word makes me sound cool".

Damn, I hate that unnecessary non-word.

P.S. Your built in spell check flags "architecting" as wrong. It's not just me.


Student of SQL and Golf, Master of Neither
chrisn-585491
chrisn-585491
Hall of Fame
Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)

Group: General Forum Members
Points: 3878 Visits: 2564
My second choice would be able to have SQL run on Linux or some other barebones OS so the server's sole mission is running SQL.


Rolleyes

That's a silly request... MS Server has improved over the years and you can tune it to support roles.
Tom Brown
Tom  Brown
Hall of Fame
Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)

Group: General Forum Members
Points: 3328 Visits: 1491
I'd like more features on SSMS

Formatting of t-sql - with the ability to alter the formatting rules
Improvements in intellisense - current version is a good start, but suggests too many wrong items
Code snippets
Something to outline/expand statements and transactions - so you can click a +/- next to a statement to select/hide find the end etc.
Search feature to find functions/procs/columns without having to query sys tables manually
Ability to get object defs/create/alter/drop code from t-sql - instead of having to navigate the object browser and right-click or, if thats too much to ask, just type the name of an object, select it and get the object browser to find that object.

And intellisense when connecting to older versions - I now have 2008 - but most of my work is connected to 2005 databases - no intellisense.
webrunner
webrunner
SSCertifiable
SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)

Group: General Forum Members
Points: 7826 Visits: 4000
I agree with the SSMS requests - especially built-in intellisense and SQL formatting options.

I would also add a request for some visual aids to see how healthy a database is. I know a lot of this depends on circumstances, but it would be neat to hover the cursor over a database server top-level node and see a bar graph or pie chart of used vs. free space on that server's data drive. And if you hover the cursor over a table, show the number of rows in the table. And if a table has an index with greater than a certain amount of fragmentation (or whatever other statistics would be useful), show that table in a different color - a shade of red or something like that. Similarly, it would be helpful to have a kind of top waits report node where you could see the wait types that were most experienced in a given database, possibly with a way to drill down to see what queries were involved.

I'm not saying I want SQL Server to do everything for me, and I know a lot of these things are available in third-party (and expensive) products, but it would be nice for it to tell me things it can already know on its own, to help narrow down possible issues as soon as the database GUI is brought up, if a DBA (say, for example, me :blushSmile has not yet gotten to the state of having a lot of these checks automated. SSMS seems like the best place to add these features.

Just my two cents.

Thanks,
webrunner

-------------------
"I love spending twice as long and working twice as hard to get half as much done!" – Nobody ever.
Ref.: http://www.adminarsenal.com/admin-arsenal-blog/powershell-how-to-write-your-first-powershell-script

"Operator! Give me the number for 911!" - Homer Simpson

"A SQL query walks into a bar and sees two tables. He walks up to them and says 'Can I join you?'"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search