Tag Info

New answers tagged

3

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.


1

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) : ...


12

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))), ...


0

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/


2

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 ...


2

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 ...


1

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.


2

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.


2

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).


0

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 ...


0

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