Viewing 15 posts - 11,941 through 11,955 (of 22,214 total)
Need the advice of the Thread.
Putting together an article on the most common backup errors (apart from not having one) and how to avoid them. I have four so far:
Backing...
August 26, 2011 at 9:23 am
I'm sorry, but you've completely lost me. What is it you're looking for now?
August 26, 2011 at 6:50 am
GilaMonster (8/26/2011)
August 26, 2011 at 6:15 am
ananda.murugesan (8/26/2011)
This is script for find out last stats updated date.
select a.id as 'ObjectID', isnull(a.name,'Heap') as 'IndexName', b.name as 'TableName',
stats_date (id,indid) as stats_last_updated_time
from sys.sysindexes as a
inner join sys.objects...
August 26, 2011 at 6:00 am
SELECT * FROM TABLE without any where clause means that every single row on the table has to get retrieved. Putting an index on it, clustered or not, doesn't change...
August 26, 2011 at 5:53 am
A heap doesn't have statistics, so I'm not sure what you're looking at there.
Clustered indexes should show the last update date. How are you looking at the statistics information?
August 26, 2011 at 5:35 am
Christi Wilson (8/25/2011)
I didn't want to start a whole new thread as...
August 26, 2011 at 5:22 am
A CTE is a derived table. So, saying which one is faster or not, is not really possible per se. It depends on how they're put together, how they're called,...
August 25, 2011 at 12:33 pm
Brandie Tarvin (8/25/2011)
Space Tramps is going to be available for order through your local bookstore when it comes out next month.
I HAVE ARRIVED!!!! Finally, a book I've written for that...
August 25, 2011 at 12:17 pm
GilaMonster (8/25/2011)
Kiara (8/25/2011)
August 25, 2011 at 12:14 pm
SQLRNNR (8/25/2011)
GilaMonster (8/25/2011)
SQLRNNR (8/25/2011)
Grant Fritchey (8/25/2011)
... and Sharepoint and the business, and some PowerShell, and search engines, and a little NoSQL and...
Really, this is a public forum... We should...
August 25, 2011 at 10:30 am
Sean Lange (8/25/2011)
Saga... (8/25/2011)
August 25, 2011 at 9:12 am
Ninja's_RGR'us (8/25/2011)
It depends.That's pretty much the only thing left to say atm!
:hehe:
+1
August 25, 2011 at 9:10 am
GilaMonster (8/25/2011)
Tom.Thomson (8/25/2011)
I saw this in an SS Central topic, and responded appropriately - I hope. If anyone thionks I was inappropriately heavy, let me know.
Grrr. What a narrow-minded...
August 25, 2011 at 9:06 am
Ninja's_RGR'us (8/25/2011)
sp_updatestats or update with fullscan IIRC they don't do the same thing?
100% accurate, they don't do the same thing. For most stats in most cases, the sampled scan, sp_updatestats...
August 25, 2011 at 7:38 am
Viewing 15 posts - 11,941 through 11,955 (of 22,214 total)