Viewing 15 posts - 41,446 through 41,460 (of 49,571 total)
So the database size is 72GB, the unallocated space is 3GB
Then the reserved size is 69 GB, the data is 31 GB, the indexes are 38 GB and the unused...
January 26, 2009 at 12:54 am
Looks fine. I'll take a detailed look later.
One thing I can tell you straight off, there's no clustered index on the table that you're repeatedly joining to, and no useful...
January 26, 2009 at 12:43 am
thulani.moyana (1/25/2009)
I would like to find out if one can rely on the tuning advisor and implement all of its recommendations?
No.
The DTA does an OK job. Not great, but...
January 26, 2009 at 12:38 am
Please post in the appropriate forum in the future.
Temp tables are treated the same way (almost) as permanent tables. So creation of a temp table will force a proc to...
January 26, 2009 at 12:35 am
Why is that done in the CLR? For procs that affect data, T-SQL's a better choice.
There's no setting or anything, so the only thing I can think of is that...
January 26, 2009 at 12:32 am
The second has a very different exec plan for a simple reason. That subquery, as written, must return only one value. If it returns more, the query must fail (with...
January 26, 2009 at 12:30 am
Couple things...
Nolock is not a good thing to add everywhere. Are you aware of the problems it may cause and do you feel that the risks of bad data are...
January 25, 2009 at 11:11 am
True. I believe (from what I've been told) that correlated subqueries did always run once per row of the outer query, back in SQL 6.5.
RBarryYoung (1/25/2009)
January 25, 2009 at 10:38 am
Well, if you do with init, you'll overwrite the old backup and hence break the log chain. Not a good idea.
I just change the backup command so that each...
January 25, 2009 at 10:37 am
No idea. Post the full setup for your test (including table creation, population and the exact queries you used) and I'll check.
Just be careful with using table variables, because they...
January 25, 2009 at 10:34 am
Jeff Moden (1/25/2009)
January 25, 2009 at 10:32 am
msalmaan (1/25/2009)
My dear the question is how come the test environment will have the database size bigger than production environment.
Who knows. Maybe someone created a really large table and then...
January 25, 2009 at 2:39 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic643123-5-1.aspx
January 25, 2009 at 2:37 am
Viewing 15 posts - 41,446 through 41,460 (of 49,571 total)