Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 145949

SQL Server 2012 (major build version 11.00.xxxx). Please also tag sql-server.

3
votes
Add some alias: insert into mytable (columns) select t.* from ( select columns from tableA UNION ALL select columns from tableB UNION ALL select columns from tableC ) t
answered Oct 19 '18 by Denis Rubashkin
1
vote
You could create a SQL Server Agent Job which will be run daily and check the free space by using a query like below: USE [YourDatabaseName] /* Size in MB */ DECLARE @Info TABLE ( [Size] …
answered Jun 18 '18 by Denis Rubashkin
3
votes
I have had a similar task recently. My solution: Create a temporary stored procedure #sp_helplogins which is a copy of sp_helplogins but returns only the second rowset. Get logins to delete (in my c …
answered Sep 4 '18 by Denis Rubashkin