September 22, 2010 at 8:57 am
Paul Hunter (9/22/2010)
david_wendelken (9/22/2010)
Products get better by improving on their strengths and adding better ideas from whatever source. That other source is often competing products. So don't get your knickers in a wad about my references to Oracle features. Oracle should copy some SQL Server features, too!Create or Replace syntax for views, procedures, functions, etc. That way, I don't have to write bozo code to handle whether the object already exists, and don't have to worry about losing undocumented grants when I drop and create.
Packages that contain related procedures and functions, like Oracle does.
...
Yes to Packages but no to the Package as interface Package Body as implementation. Those features can be handled by public/private keywords.
I can live with that. 🙂
September 22, 2010 at 9:11 am
chrisn-585491 (9/22/2010)
blandry,I believe there is a space between Access/FoxPro and SQL Server that isn't being filled well.
I believe SQL Server Express can fill that hole, for certain uses.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
September 22, 2010 at 10:30 am
Alvin,
I just noticed your photo and that you're in Memphis.
You didn't go to college in Memphis circa 1975-82 did you?
Because there was some guy that drove a nice car back then that looked enough like me to confuse my friends and fool my own mother at 10 feet away.
From your photo, I'm seriously thinking it might have been you!
September 22, 2010 at 10:41 am
david_wendelken (9/22/2010)
Alvin,I just noticed your photo and that you're in Memphis.
You didn't go to college in Memphis circa 1975-82 did you?
Because there was some guy that drove a nice car back then that looked enough like me to confuse my friends and fool my own mother at 10 feet away.
From your photo, I'm seriously thinking it might have been you!
That wasn't me. I wasn't anywhere near Memphis until late 1999.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
September 22, 2010 at 10:43 am
Bummer!
I thought I had solved a 30 year old mystery. 🙁
September 22, 2010 at 10:44 am
david_wendelken (9/22/2010)
Bummer!I thought I had solved a 30 year old mystery. 🙁
Alvin's a much older mystery than that....:w00t::hehe:
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
September 22, 2010 at 11:31 am
Configurable authentication for reporting services based around proper X.500 compliant LDAP (as used in eDirectory, OpenLDAP etc), without the need to get deep into .Net code development for a custom forms based system.
September 22, 2010 at 11:47 am
While we are at it, how about a DMV that allows you to get not only file size for DB files, but also total space and free space on the disk itself? And make it smart enough to use mount points? You CAN get that though WMI, IF you have local admin to the server. However, not all DBAs are allowed local admin access (though of course the service account is). A DMV would be a nice way around that.
September 22, 2010 at 1:47 pm
It surprises me that there aren't more comments on this topic.
I think it should be easier to do some common tasks such as importing an Excel file into SSMS. Simple as in "File, Open" then point to the file and just open it :satisfied: (with options to format it and name the columns). Think of how Excel opens a CSV for example.
The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking
September 22, 2010 at 3:29 pm
Temporal support for periods and for explicit intervals, with sufficient index capability so as to be able to include periods (start date, end date) in a table, put an index on (Key, Period) and then know (and let the engine know) for certain that for any given key and Instant (single point in time), at most one record will be returned.
Variable page size - this is a critical feature to really take advantage of page compression.
Significantly better fuzzy comparison operators - double metaphone (phonetic similarity) and Jaro-Winkler (typo detection).
SSMS should show, in the tooltip text, the columns an index is on, and those it includes.
Reasonable date formatting; VB6 had Format(); start with that easy-to-use and remember interface.
A more comprehensive exact numeric datatype set - 1 byte signed, 2 byte unsigned, 4 byte unsigned, and 8 byte unsigned integers are missing.
Functional indexes that you can create without changing the columns of the table (which then breaks certain [Microsoft] interface methods).
Restore database option that automatically A) creates data and log files only as big as is necessary for the data itself, and B) automatically applies (PAGE | ROW) compression to every single clustered index, nonclustered index, and heap, so we can have a chance of restoring oversized databases to undersized development servers.
For the accidental DBA's: Warnings in the event log for full or bulk-logged recovery mode databases over a month old which have never had a transaction log backup. Put an option in sp_configure to disable those warnings, but have them on by default at installation.
Mount a Full backup (at minimum, optionally including DIFF and LOG backups for point in time) as a Read Only database without actually restoring it.
September 23, 2010 at 7:15 am
We logged something at SQL Connect recently but no ones (only 4 votes) seems to be interested in this enhancement.
See the following URL:
It is about a better way to manage error messages: Msg vs Message vs ...
Best regards.
Carl
September 23, 2010 at 8:04 am
I can’t believe that no one has mentioned having Microsoft implement true clustering for SQL Server. In other words, have a database active and processing requests on multiple active nodes.
DEC RDB implemented this in 1984, so it is not exactly a new idea. It would let SQL Server play in the arena where applications really have to be as near to 100% uptime as possible.
Note: I see this was mentioned twice in Brad's blog post, so I guess I'm not alone in this.
September 23, 2010 at 2:29 pm
mtillman-921105 (9/22/2010)
It surprises me that there aren't more comments on this topic.I think it should be easier to do some common tasks such as importing an Excel file into SSMS. Simple as in "File, Open" then point to the file and just open it :satisfied: (with options to format it and name the columns). Think of how Excel opens a CSV for example.
Open the file in excel and arrange the columns to be in the same order as they are in the table.
copy the rows into memory.
Paste them into the open for edit table display in SSMS.
September 23, 2010 at 2:36 pm
And a Bulk Export to match Bulk Import from straight SQL, using a format file.
More flexible format files would be nice, too.
September 23, 2010 at 2:42 pm
david_wendelken (9/23/2010)
mtillman-921105 (9/22/2010)
It surprises me that there aren't more comments on this topic.I think it should be easier to do some common tasks such as importing an Excel file into SSMS. Simple as in "File, Open" then point to the file and just open it :satisfied: (with options to format it and name the columns). Think of how Excel opens a CSV for example.
Open the file in excel and arrange the columns to be in the same order as they are in the table.
copy the rows into memory.
Paste them into the open for edit table display in SSMS.
Ha! I didn't know that you could do that. Very helpful - thank you! :smooooth:
But I think my request is still important since, all too often, it is a one-off process and if you don't have the table structure set up for the file, you might as well open up the Import and Export Wizard to pull the file in.
The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking
Viewing 15 posts - 16 through 30 (of 33 total)
You must be logged in to reply to this topic. Login to reply