September 14, 2019 at 12:00 am
Comments posted to this topic are about the item Fantasy SQL Server
September 14, 2019 at 12:12 pm
What would I like to see in SQL Server in the future?
1. Assertions (in the SQL standard since SQL-92. Until now no one has implement them - I hear Oracle are currently working on it).
2. Set based results from constraints. When a primary or foreign key is violated and multiple rows are effected then all rows that violate the constraint should be returned and not just the "first" one.
September 14, 2019 at 3:00 pm
Yes definetely "restore only ONE table" ( or objects) is really the most outstanding lacking features. And dear Steve, software like LightSpeed for SqlServer have bene done It, and very well, since many years. Haven't you Heard about?
September 14, 2019 at 3:36 pm
mmm,set based results. I like it.
Frederico, Redgate has also had this with SQL Backup Pro and our Object Recovery tool. We could do it because we tracked where objects were in the backup. We found almost no one used it because of data issues, but it's a nice idea in some cases.
September 14, 2019 at 7:06 pm
I'd love to see bulk inserts permissions be assignable to regular users without the need for server roles to be assigned.
Just saying.. Would be pretty awesome.
September 15, 2019 at 1:38 pm
Call me crazy, but I've always wanted deferrable constraints, and the ability to use intervals (ranges) as keys.
September 16, 2019 at 12:47 am
I'd like to see the ability to create a filtered index on a computed column, even if limited to PERSISTED computed columns
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply