Comments
Sort by recent activity
Vote! http://redgate.uservoice.com/forums/94413-sql-prompt-feature-suggestions/suggestions/3046735-support-tab-magic-in-ssms-2012-asap / comments
Vote!http://redgate.uservoice.com/forums/94413-sql-prompt-feature-suggestions/suggestions/3046735-support-tab-magic-in-ssms-2012-asap
Perhaps, Andy, Red Gate might consider this more of a priority due to Microsoft's abysmal decision to rid SSMS of the MDI mode.
As a user of SS2012 SSMS for months now, I absolutely loathe, hate and abhor the fact I only have 2 tabs viewable at one time and hunting the tabs with no status bar is a pain!
I'd start using Tab Magic immediately to ease the pain of a bum working environment!
And I have no votes left on Uservoice! Bummer, too... UPDATE:
Stole 3 votes from another good suggestion just to get this on the scoreboard. / comments
Perhaps, Andy, Red Gate might consider this more of a priority due to Microsoft's abysmal decision to rid SSMS of the MDI mode.
As a user of SS2012 SSMS for months now, I absolutely loathe, hate an...
It would actually be beneficial if we had the option to generate the insert WITH the IDENTITY column, and have the whole statement top-n-tailed by a pair of SET IDENTITY_INSERT <Table> ON/OFF statements.
I have several reference tables that include an IDENTITY PK and must explicitly set the IDENTITY when replicating manually from Production to all other servers, as transaction replication is way overkill for this.
Any chance consideration could be given to enabling the above option (dialog, perhaps) upon detection of an INSERT INTO ... fragment? / comments
It would actually be beneficial if we had the option to generate the insert WITH the IDENTITY column, and have the whole statement top-n-tailed by a pair of SET IDENTITY_INSERT <Table> ON/OFF state...
Thanks, Eddie, at least it's in the pile... Can't hurt to ask.
I've exhausted my voting capacity on Uservoice, or I'd gladly add another... The votes I've already spent are for what I consider important, too, so there's no scope for redistribution, sadly.
Cheers,
Stephen / comments
Thanks, Eddie, at least it's in the pile... Can't hurt to ask.
I've exhausted my voting capacity on Uservoice, or I'd gladly add another... The votes I've already spent are for what I consider im...
Thanks, emailed. / comments
Thanks, emailed.
Sorry, Manfred, your post doesn't make it clear to me just WHERE one should place what looks like (to me) an empty element.
Would you be so kind as to post a sample like mine, 2 posts above, that shows the suggestion in place, please? / comments
Sorry, Manfred, your post doesn't make it clear to me just WHERE one should place what looks like (to me) an empty element.
Would you be so kind as to post a sample like mine, 2 posts above, that s...
Logs emailed.
Thanks, Chris. / comments
Logs emailed.
Thanks, Chris.
Sadly, I already have that set to true:
reconnectAfterAuthorizationError
*********************
Whether SQL Monitor should try to reconnect and continue monitoring after an AuthorizationError is raised
-->
<repositorySettings slaveMode="false">
<!-- valid databaseEngines: "Mssql"-->
<dataStore databaseEngine="Mssql" autoUpgrade="true">
<!-- valid versions: "Auto", "SQL2005", "SQL2008" -->
<mssql version="Auto" connectionStringName="DataConnectionString"/>
</dataStore>
</repositorySettings>
<collectionSettings maxTraceFileAge="00:15:00" maxTraceFileDiskUsage="1024" reconnectAfterAuthorizationError="true">
<collectionSchedules>
Bug? / comments
Sadly, I already have that set to true:
reconnectAfterAuthorizationError
*********************
Whether SQL Monitor should try to reconnect and continue monitoring after an AuthorizationE...
Thanks for filling out my understanding of the components etc.
I'll know in future to only run the analyzer once I've secured a Production copy and restored it to as similar a server as I can find locally.
Cheers.
Stephen / comments
Thanks for filling out my understanding of the components etc.
I'll know in future to only run the analyzer once I've secured a Production copy and restored it to as similar a server as I can find ...
Hi Peter,
We have 16 logical CPUs on the server and only 7 allocated to SQL Backup in our attempt to throttle it back somewhat as we had 100% cpu issues from Dec 2010 for about 7 months at a time when we had replication and other stuff running, which have now been removed.
We haven't seen the Processor Utilization Alert, other than once a month for the Key Performance Indicator sweep at month end, so the sudden increase in utilization on an unchanged instance, apart from installing the 7.1 server components, was quite a surprise as you might imagine.
I'll keep an eye on it.
I read the Help section on the Compression Analyzer and the hoops one must jump through to get to "the optimum throughput". Any chance RG could do some further automation of this as it's rather a suck-it-and-see methodology at present...
I cancelled the Compression Analyzer after about 5 minutes as I could see that there is was a significant justification for using level-4. However, this raised a "Failed Database Backup" Alert at Rackspace, eventuating in a confusing ticket that took me and Rackspace several interchanges to finally deduce that "I" had caused the problem. Is there a way you could perhaps insulate a cancelled Compression Analyzer from barfing out an unnecessary "failure", please? / comments
Hi Peter,
We have 16 logical CPUs on the server and only 7 allocated to SQL Backup in our attempt to throttle it back somewhat as we had 100% cpu issues from Dec 2010 for about 7 months at a time w...