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 answers only user 8783

Best practices are generally and informally recognized as the methods and processes that have been shown over time to be superior to those achieved by other means.

19
votes
You question revolves around - When is it a good thing to just create statistics vs create index (which create stats). From my sql server internals notes (SQLSkills class- IE1 and IE2) and SQL Server …
answered Oct 23 '15 by Kin Shah
6
votes
You should always set your max memory away from default and leave some room for OS (see Jonathan's post of how much Memory to leave based on the amount of RAM installed). Jonathan Kehayias has blogge …
answered Jul 3 '14 by Kin Shah
14
votes
You don't have to be fancy/worried or scared when you are restarting sql server. Just make sure that you dont have any long running transactions. Best is to restart sql server using console or shutd …
answered Aug 26 '13 by Kin Shah
104
votes
Is a bad practice to create a transaction always? It depends on what context you are talking here. If it is an update, then I would highly recommend using TRANSACTIONS explicitly. If it is a SELECT t …
answered May 28 '13 by Kin Shah
6
votes
I dont see anything wrong in your setup. To be fair, this is the correct way of setting up SSIS in a clustered environment. Read up SSIS and clustering: What you should do instead Also for the login …
answered May 9 '13 by Kin Shah