Tag Info

Hot answers tagged

3

Its not too difficult to build a query that does it. First create a query that joins on a table using LIKE with wildcards. Then exclude everything from this query. To see what I mean, see this simple example: http://sqlfiddle.com/#!6/619fb/2 Or alternately I have reproduced an example here: --Create tables for comparing data CREATE TABLE Invoice ( ...


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


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.


1

Use: A foreign data wrapper like odbc_fdw or tds_fdw (see foreign data wrappers list, foreign data wrapper documentation); or dbi-link - see github repo


1

In the folder %APPDATA%\Microsoft\Microsoft SQL Server\110\Tools\Shell you should find a file named RegSrvr.xml. That's the file where Management Studio stores local registered servers. If the file is missing or corrupt, SSMS won't display anything. In this case, you can create a new file and paste this: <?xml version="1.0"?> <model ...


1

try something like this.. DECLARE @MyTable AS TABLE ( [Month] INT, Salary INT ); INSERT INTO @MyTable VALUES (1,2000), (1,3100); SELECT [Month], STUFF(( SELECT ',' + CONVERT(NVARCHAR(30),Salary) from @MyTable WHERE Month = out.Month FOR XML Path('')) ,1,1,'') csv FROM @MyTable out GROUP BY Month;


1

Full text search is a richer way of indexing complex strings. I know your case does not contain prose but FTS may still work for you. As an alternative to wildcard search you could split your concatenated values into their separeate parts. There are many ways to achieve this; reading this link will lead you to one that suits. Then you can treat your data ...



Only top voted, non community-wiki answers of a minimum length are eligible