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 61

SQL Server 2005 (major build version 9.00.xxxx). Please also tag sql-server.

3
votes
The most obvious cause would be that (select max(ID) from tblR where cID = c.cID and ISNULL(aField,'') <> '') sub-query in the WHERE clause in combination with the TOP 500 is making the order make a d …
answered Jan 15 '11 by David Spillett
15
votes
There is no direct way, that I know of, to downgrade a DB from 2008's format to 2005's unfortunately. The way I have done this in the past (actually with older versions of SQL server, but the process …
answered Jan 3 '11 by David Spillett
7
votes
It is usually recommended that you have a surrogate key in such situations, so foreign keys in other tables (and any record references that may be stored externally, such as if they are carried on que …
answered Jan 21 '11 by David Spillett
1
vote
should I really disable the page file? and reduce it to 8 GB? It isn't talking about disabling the page file - it is referring to disabling the auto-size settings. is there a rule for the siz …
answered Aug 15 '16 by David Spillett
5
votes
If you have a relevant backup plan running your log file will not grow indefinitely. You will probably find that the space within it is mainly unallocated - as blocks of pages in the log get backed up …
answered Apr 8 '11 by David Spillett
3
votes
1answer
We have a large database that has had a lot of older data stripped out, leaving primary datafile (all objects are currently in the primary filegroup) of about 80Gb containing a little less than 20Gb …
asked Aug 29 '11 by David Spillett
12
votes
IIRC you can not exactly guarantee the order that triggers (with the same definition of what to react to and when) fire for a given action against a table, for any given number of triggers. You can t …
answered Jan 10 '11 by David Spillett
11
votes
In your size estimates, have you taken into account the amount of space taken by indexes? Also if you have text fields that are set as multi-byte (N[VAR]CHAR rather than [VAR]CHAR) and the input files …
answered Aug 21 '13 by David Spillett
4
votes
If you are experiencing the problems that are documented as being fixed by installing that update, then there is unlikely to be another way to fix the problem while still keeping that version of the t …
answered Apr 2 '17 by David Spillett
8
votes
My gut says that any performance gain you get is unlikely to be worth the extra hassle (and potential for bugs ) resulting from needing to enforce the separation and perform multiple lookups in your a …
answered Feb 7 '11 by David Spillett
76
votes
Short version: seek is much better Less short version: seek is generally much better, but a great many seeks (caused by bad query design with nasty correlated sub-queries for instance, or because you …
answered May 20 '13 by David Spillett