New answers tagged ssms
As already shown in the comments, I've seen/used the same feature in SSMS 2005 as shown here. But I didn't manage to see what ever editor window setting would be different than in SSMS 2012/2014 where the behavior has changed.
there is a lot of options but choosing the right one is up to you, this is some of the options : 1) Adminer: http://www.adminer.org/ 2) DBeaver: http://dbeaver.jkiss.org/about/ 3)DBVisualizer Free: http://www.dbvis.com/ 4) sql developer (but you need to install the plugins first) : ...
You can use a query like this to calculate read/write rates and latency (though due to my laziness these figures are not in units that match Activity Monitor). SELECT d.name, f.name, f.type_desc, f.physical_name, [read b/ms] = num_of_bytes_read * 1.0/sample_ms, [avg read latency] = (1.0*s.io_stall_read_ms / (COALESCE(NULLIF(s.num_of_reads,0),1))), ...
Is it possible that you create a configuration file and then you auto create the necessary registered servers in SSMS? Just as mentioned in this article: http://www.mssqltips.com/sqlservertip/3252/automate-registering-and-maintaining-servers-in-sql-server-management-studio-ssms/
One thing to note is that RESTORE is a command, not really a permission that can be granted. Which is why your GRANT failed. In the SQL Server Books Online at https://msdn.microsoft.com/en-us/library/ms186858.aspx has pretty much said the same thing from SQL Server 2000 until now, namely: RESTORE permissions default to members of the sysadmin and ...
IntelliSense Refresh local Cache should fix it
I would suggest NOT to use Designer in creating key constraints or doing any DDL / DML operations. Best is to use T-SQL - much flexible, more options, more powerful and you can automate many things with it. There is a learning curve, but its worth learning TSQL rather than keep using GUI. Also, make sure you are using the latest version of SSMS - sql ...
Red Gate's SQL Prompt is what I use and has several dozen different settings. It also has a better auto suggestion and code snippet engine than many others I've tried. Well worth the money in terms of time saved.
Differential backups are backups of any changes to the DB since the last full backup. So in theory, yes, you could have it do a diff backup since some date (if you did a full backup on that date). Otherwise, no. It'll always be since the last full backup.
SQL Server 2012 SP1 CU15 (http://support.microsoft.com/en-us/kb/3038001) resolves the issue (no deadlock occurs as the result of issuing a command during a database restore).
SQL Server is kind of a memory hog. You could try clearing the cache, BUT I would highly recommend doing some reading on these commands first before you using them. From what I hear, their can be negative side effects when using these especially in a production environment. DBCC FREESYSTEMCACHE ('ALL') DBCC FREEPROCCACHE Here are some links I found ...
I could be wrong, (especially since I don't know German) but looking at the options on the second screen (Media Options), did you try doing "back up to a new media set", instead of an existing one? In 2014 there are additional options. Since it is a 2012 database you are trying to back up, there are probably defaults set in those options which are ...
Top 50 recent answers are included