797 reputation
518
bio website dba.stackexchange.com
location Israel
age 34
visits member for 1 year, 11 months
seen 2 days ago
  • DBA SQL Server Since June 2011
  • Camera: Canon 60D
    • Lenses: EFS 17-55 F2.8 IS USM, EF 50mm F1.4 USM

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 suggested 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 suggested 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
Jun
16
comment Need to divide single column into multiple columns
@MartinSmith You are correct of course, But... I work with programmers and find it easier to "force" them to always use column names than to make them think before and decide each time. I also think that not everyone who reads an answer here understands when it makes no difference and why (well, now they know...), therefor it was just "for the sake of good habit". This is definitely not to lessen from your really great answer.
Jun
16
comment Need to divide single column into multiple columns
@MartinSmith Great answer, I would replace the pseudo SELECT * with SELECT Column1, Column2 for the sake of good habit... :)
Jun
16
revised Is it a good practice to create tables dynamically in a site?
Minor corrections
Jun
16
awarded  Custodian