Viewing 15 posts - 47,311 through 47,325 (of 49,571 total)
Something small that may help.
I just noticed that the forum combo box at the bottom of every page has all the forums in it. Including all the hundreds of 'Content...
February 25, 2008 at 8:10 am
Have you updated stats/rebuilt indexes after migrating the db to 2005?
If you look at the execution plan for both, what are the differences?
February 25, 2008 at 8:04 am
You need to update the statistics on all of your tables. SQL 2005 keeps more detailed column statistics than SQL 2000 did. The 2005 optimiser can use the older stats,...
February 25, 2008 at 6:46 am
Duplicate post. Ref - http://www.sqlservercentral.com/Forums/Topic459568-359-1.aspx
February 25, 2008 at 12:59 am
Your colleague may be thinking about the NOEXPAND hint. That's onlty useful if you have indexed views and a version of SQL other than enterprise.
I would not recommend the use...
February 25, 2008 at 12:31 am
Nicely said Jeff.
I always go above and beyond what's expected. If I see a problem with a system I make an effort to fix it, or get it fixed. 'Good...
February 25, 2008 at 12:09 am
That's a very, very small table. 48k = 6 pages, less than an extent. Fragmentation doesn't have much meaning on such small tables.
I wouldn't worry about fragmentation except on bigger...
February 24, 2008 at 11:52 pm
Jeff Moden (2/23/2008)
That's kinda the conclusion I came to. Thanks for the great explanation, Gail.
Glad to be of help.
You don't happen to have a good URL for how to...
February 24, 2008 at 11:44 pm
How big is that table? How many pages?
February 23, 2008 at 11:09 am
Drop the snapshot and create a new one?
Perhaps I'm misunderstanding you, but after you've created a snapshot, neither new data nor new objects created after that time will be reflected...
February 23, 2008 at 8:06 am
Jeff Moden (2/22/2008)
And this isn't even parameter sniffing because it's a script!
It's caused by the same thing. When the optimiser gets a query, it knows the value of any parameters...
February 23, 2008 at 8:00 am
It's the name listed in sysindexes. (From the list you gave earlier, all the ones like _WA_s_....)
SELECT name FROM sysindxes WHERE INDEXPROPERTY(id, indid, 'IsStatistics') = 1 will give you the...
February 23, 2008 at 7:48 am
The cost % is the optimiser's estimate of how expensive an operation is relative to the rest of the query. If you have a table scan of a very small...
February 23, 2008 at 7:45 am
I would strongly suggest that you store the date as a date time and do the conversion/formatting in your query/view.
Timestamp is used for row versioning, as the value changes whenever...
February 22, 2008 at 4:16 am
Why do you want to store the date as a formatted string?
February 22, 2008 at 2:34 am
Viewing 15 posts - 47,311 through 47,325 (of 49,571 total)