Viewing 15 posts - 226 through 240 (of 286 total)
SQL Kiwi (1/26/2012)
January 26, 2012 at 6:38 pm
Vertigo44 (1/19/2012)
PaulB-TheOneAndOnly (1/19/2012)
January 19, 2012 at 4:23 pm
Sapen,
sorry I provided you a wrong script. It will read only the last active trace file but there are usually 4 more historical ones.
You need to modify file name like...
January 13, 2012 at 11:22 am
richard mascarenhas (1/7/2012)
sp_updatestats only updates statistics that requires updating. hence, the ones that were rebuilt will be skipped.
If you run rebuild and update stats when nobody works with DB then...
January 7, 2012 at 1:09 pm
Gregory, nice script. But I have some suggestions:
1. When you rebuild an index then statistics are updated with FULL SCAN, so it's not necessary and even harmful to run sp_updatestats...
January 4, 2012 at 10:32 am
fediori,
This is interesting...
But what are the benefits of this approach comparing to the one when surrogate key is IDENTITY?
January 4, 2012 at 9:59 am
Maybe I didn't get something but I have not heard anything about the rule: "for each unique value of the natural key there should be only one value of the...
January 3, 2012 at 8:49 pm
Actually INNER JOIN and LEFT JOIN will produce the same result with WHERE clause, but in this case internally SQL will do an INNER JOIN instead of LEFT so the...
December 29, 2011 at 2:05 pm
Lowell (12/29/2011)
ok, now i am confused; i thought the insert was SELECT 0, 'test'from Customer....but it's just SELECT 0, 'test'
for that, i'd expect an estimate of one row....
Sorry I...
December 29, 2011 at 2:02 pm
Dev (12/29/2011)
I hope it explains your scenario.
Unfortunately not. The BOL is the first place where I search for explanations but it usually doesn't provide much details.
But again this...
December 29, 2011 at 10:18 am
David Moutray (12/28/2011)
I don't think the estimates are that far off. A difference of 50% (or two to one) does not generally produce a bad execution plan.
I cannot...
December 29, 2011 at 12:11 am
What do you mean by TOP 1 if you don't specify ORDER BY? You don't care about what record it will return?
It may be a difference on how SQL Server...
December 28, 2011 at 11:44 pm
Ok, I have a question then...
How SQL Server estimates how many records will be after joining 2 tables?
And why for such a simple select on relatively small tables (100...
December 28, 2011 at 5:18 pm
Sapen (12/21/2011)
Hope all is well.
I was wondering if there is a way to determine when a new index was added to a table or how long an existing index...
December 21, 2011 at 3:31 pm
Dynamics AX keeps data in MS SQL Server so technically you can run a query against the DB and populate an SSRS report.
December 15, 2011 at 5:15 pm
Viewing 15 posts - 226 through 240 (of 286 total)