Settings and activity
31 results found
-
8 votes
ben b
supported this idea
·
-
101 votesben b
supported this idea
·
-
23 votesben b
supported this idea
·
-
11 votesben b
supported this idea
·
-
13 votes
An error occurred while saving the comment ben b
shared this idea
·
-
16 votes
An error occurred while saving the comment ben b
commented
I was going to suggest being able to filter databases as it would be so helpful.
On our dev servers there are usually around 50 databases but i will only ever be interested in 5 or 6 at any one time. This extra noise is really distracting and makes navigation really inefficient.
Just looking in the comments for this idea, SQLTreeo looks like it will be really useful and is very cheap so i'll give that a try - it would be good for redgate to put their own stamp on this idea though and add some functionality into SQL Prompt.
ben b
supported this idea
·
-
31 votesben b
supported this idea
·
-
13 votes
An error occurred while saving the comment ben b
commented
it would be great if you could highlight a load of column names in a SELECT statement and encapuslate them all with sum() as OriginalColumnName
i.e.
select Transaction_Date,
TransactionAmountA,
TransactionAmountB
from
Transactionswould become
select Transaction_Date,
sum(TransactionAmountA) as TransactionAmountA,
sum(TransactionAmountB) as TransactionAmountB
from
Transactionsyou could then add the group by yourself using your 'all non aggregated' feature.
i regularly deal with fact tables with 20+ measures, real chore :)
ben b
supported this idea
·
-
22 votesben b
supported this idea
·
-
34 votesben b
supported this idea
·
-
112 votesben b
supported this idea
·
It would also be good if there was an option, "export to excel: transposed".
If I am exploring data with a user or doing a gap analysis between two datasets, I will do a SELECT TOP 1 * FROM X, then export to excel and transpose the data (and add headers). This gives me a list of all the columns in the table/results-set and an example value.
I especially do this on really wide tables. It's like a first step in a manual data-profiling exercise.
it could be launched from the results-grid or the object-explorer.