Reputation
907
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
1 6 20
Impact
~71k people reached

May
14
awarded  Famous Question
Sep
30
awarded  Explainer
Sep
25
awarded  Revival
Sep
11
awarded  Yearling
May
1
awarded  Revival
Apr
29
awarded  Notable Question
Nov
20
awarded  Popular Question
Oct
16
comment how to trigger a statistics update
We don't use the Async option so it is not the problem. We also don't have to use FULLSCAN, but even if we do it is not to expensive to scan 500k rows (takes about 10-15 seconds of shared lock on our system, which is acceptable if done only when needed). My question was about that "guaranteed way" which I am still looking for. of course using a stored procedure is an option, but with the constraint of not changing the application.
Oct
15
comment how to trigger a statistics update
+1 I did not know that, and maybe after our scheduled upgrade from SQL Server 2005 to SQL Server 2012 it will solve my problem, though it is a server-wide configuration and my need is for a specific database.
Oct
14
asked how to trigger a statistics update
Sep
11
awarded  Yearling
Jul
4
comment Can a database restore fail after it has begun?
There is no need to KILL processes after setting SINGLE_USER, and You can just set the database OFFLINE instead and then do a RESTORE.
Jun
20
revised What tasks can only sysadmin's do in SQL Server 2000?
edited body
Jun
17
revised Simplify subqueries with join
corrected spelling and added tags
Jun
17
suggested approved edit on Simplify subqueries with join
Jun
17
reviewed No Action Needed Is there a system wide way to change MariaDB to create tables using ROW_FORMAT = DYNAMIC
Jun
17
revised Allow user to do anything within his own schema but not create or drop the schema itself
edited title; minor fixes; tagging
Jun
17
suggested approved edit on Allow user to do anything within his own schema but not create or drop the schema itself
Jun
16
comment Accessing environment variables at design time in SSDT?
Jeff, in order for a commentator to know that you replied you must use @ and his name in your reply, like @billinkc in this case.
Jun
16
answered Allow user to do anything within his own schema but not create or drop the schema itself