Search Results
| 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 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| 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 sql-server
Search options not deleted
user 210120
All versions of Microsoft SQL Server (not MySQL). Please also add a version-specific tag, like sql-server-2016, since it is often relevant to the question.
2
votes
How to create an user with permission to do everything but drop databases?
I prefer to use db_owner Not using Sysadmin.
And use Server Trigger to prevent delete database accidentally Like this :
To create a DDL trigger with server scope (ON ALL SERVER) or a logon trigger, r …
- 60
2
votes
Accepted
Vastly different query run-times on different servers
Many reasons are affected to your result i try to explain some important of :
Note
At First it's important to know how config your VMs many options are important like : reserved CPU ? Or rese …
- 60
0
votes
Link Server Error - From SQL2008r2 to SQL2014
If you check the connection and use SA, It seems you don't use correct syntax (Linkserver.Database. Schema.TableName) or the part of syntax like table name don't exist or mismatch table name...
- 60
1
vote
Running queries/jobs via SMSS - SQL service and SQL agent service accounts (SQL Server)
Job ownership is an important concept in SQL Server Agent. SQL Server Agent sets the security context for job execution based on the role of the user owning the job.
By default, SQL Server Agent exe …
- 60
-2
votes
Why Do Primary Keys on Temp Tables Improve Performance Much More Than On Table Variables?
Generally many factors affects on your query performance and i try my best to mention some of that and link to source for more explanation :
Primery Key when we create primery key we create constrain …
- 60
-1
votes
Changing database compatibility from legacy CE to 120
I try my best to explain what can do in this situation base on your question information, and I hope help you.
When moving to the new CE, you can expect that some query execution plans will remain the …
- 60