This is significantly faster than the EXISTS way: SELECT [EmailAddress], [CustomerName] FROM [Customers] WHERE [EmailAddress] IN (SELECT [EmailAddress] FROM [Customers] GROUP BY [EmailAddress] HAVING COUNT(*) > 1)
Try this alter table TableName add constraint df_ConstraintNAme default getutcdate() for [Date] example create table bla (id int) alter table bla add constraint dt_bla default 1 for id insert bla default values select * from bla also make sure you name the default constraint..it will be a pain in the neck to drop it later … Read more
In researching Matt’s comment, I have revised my original statement. He is correct, there will be a difference in performance between an inline table valued function (ITVF) and a multi-statement table valued function (MSTVF) even if they both simply execute a SELECT statement. SQL Server will treat an ITVF somewhat like a VIEW in that … Read more
Tools > Options > Query Results > SQL Server > Results to Text (or Grid if you want) > Include columns headers in the result set You might need to close and reopen SSMS after changing this option. On the SQL Editor Toolbar you can select save to file without having to restart SSMS
There are times that using OPTION(RECOMPILE) makes sense. In my experience the only time this is a viable option is when you are using dynamic SQL. Before you explore whether this makes sense in your situation I would recommend rebuilding your statistics. This can be done by running the following: EXEC sp_updatestats And then recreating … Read more
SELECT name, create_date, modify_date FROM sys.objects WHERE type=”P” ORDER BY modify_date DESC The type for a function is FN rather than P for procedure. Or you can filter on the name column.
finally done with GROUP BY DATEPART(YEAR, DT.[Date]), DATEPART(MONTH, DT.[Date]), DATEPART(DAY, DT.[Date]), DATEPART(HOUR, DT.[Date]), (DATEPART(MINUTE, DT.[Date]) / 10)
A unique constraint can’t be over 8000 bytes per row and will only use the first 900 bytes even then so the safest maximum size for your keys would be: create table [misc_info] ( [id] INTEGER PRIMARY KEY IDENTITY NOT NULL, [key] nvarchar(450) UNIQUE NOT NULL, [value] nvarchar(max) NOT NULL ) i.e. the key can’t … Read more
If you right click on any result of “Edit Top 200 Rows” query in SSMS you will see the option “Pane -> SQL”. It then shows the SQL Query that was run, which you can edit as you wish. In SMSS 2012 and 2008, you can use Ctrl+3 to quickly get there.
— replace NVARCHAR(42) with the actual type of your column ALTER TABLE your_table ALTER COLUMN your_column NVARCHAR(42) NULL