Reputation
38,864
Next tag badge:
572/400 score
77/80 answers
Badges
8 104 163
Newest
 Enlightened
Impact
~1.6m people reached

Jan
15
revised Performance on SQL Join
added 320 characters in body
Jan
15
comment Performance on SQL Join
@davey - If you update the statistics on that column it should choose a more appropriate plan naturally.
Jan
14
revised Inserting rows into other table whilst preserving IDENTITY
The title was a proposed solution not the underlying problem
Jan
14
comment Performance on SQL Join
@davey - If you mouse over the arrow coming out of the seek on splitorders what are the estimated and actual number of rows?
Jan
14
answered Performance on SQL Join
Jan
14
comment Performance on SQL Join
@davey - Can you post the actual plan XML? That normally means something is awry with estimated vs actual number of rows. Sounds like you may just luck into getting a different plan better suited for the actual number of rows (e.g. maybe hash join rather than nested loops) due to either different cardinality estimates or the use of unsargable predicates in the 2nd version.
Jan
14
comment Performance on SQL Join
Can you post the actual execution plans?
Jan
14
comment Stateful views in SQL Server
What do you mean that the database crashed? Is it on a different SQL Server instance that became offline?
Jan
13
revised sql_slovak_cp1250_ci_as vs Slovak_CI_AS
added 1991 characters in body
Jan
13
revised sql_slovak_cp1250_ci_as vs Slovak_CI_AS
added 2010 characters in body
Jan
13
revised sql_slovak_cp1250_ci_as vs Slovak_CI_AS
added 17724 characters in body
Jan
13
answered sql_slovak_cp1250_ci_as vs Slovak_CI_AS
Jan
13
revised sql_slovak_cp1250_ci_as vs Slovak_CI_AS
Fixed text to use correct collation names that are in the title
Jan
10
comment SQL Server 2000 performance
BTW: You don't tell us anything about the server. If it is 32 bit then the RAM as shown in taskmgr won't go above 2GB except if you are using the 3GB switch. Also how big is the database in GB and what is the page life expectancy on the server?
Jan
9
comment cannot connect to sql server in single user mode
If you are an administrator on the server itself you can login via single user mode as described in the docs and it will treat the connection as though you are in the sysadmin role. Which as far as I can see is exactly what the blog post that is linked to from your other link does.
Jan
9
comment SQL Server 2000 performance
"Query Analyzer" is the name of the tool that was the precursor to management studio. It isn't something that you can just run on your queries.
Jan
9
comment SQL Server 2000 performance
Sounds like you are probably missing some useful indexes.
Jan
9
revised SQL Server 2000 performance
added 14 characters in body
Jan
9
comment Is there a SQL Server equivalent to “OVERRIDING USER VALUE”
No there isn't. Maybe if you explain why you need it someone can suggest an alternative.
Jan
9
comment Ok to drop indexes on FK's if they have no stats in the DMVS
On 2012 rebuild does clear the stats. There is a connect item by joseph sack about this.