Viewing 15 posts - 14,476 through 14,490 (of 22,211 total)
I won't enter the debate about stored procedures or not.
You have some problems in your SQL code. First, why are you using DISTINCT for all the queries? This is...
August 11, 2010 at 9:31 am
there's not really a good way and, frankly, you shouldn't. TSQL is a great language for querying databases and manipulating data. It's quite horrible at all other tasks. I'd suggest...
August 11, 2010 at 9:14 am
GilaMonster (8/11/2010)
2008 feature, along with the two options (access check cache bucket count, access check cache quota) that control the token store.
Nuts. Thanks. I wasn't sure when it was introduced.
It...
August 11, 2010 at 6:08 am
Nope. There is no way to control the cache in that manner. The one thing you can do, and I think this is available in 2005, is set the system...
August 11, 2010 at 5:39 am
And for a slightly different view of the same material:
http://scarydba.wordpress.com/2010/07/23/sql-university-introduction-to-indexes-part-the-third/%5B/url%5D
August 11, 2010 at 5:37 am
No, I don't recognize that wait state. Sorry.
Have you run this DMV, sys.dm_os_wait_stats, and collected stats from it? Before, during & after your peak times will tell you quite a...
August 10, 2010 at 1:28 pm
GilaMonster (8/10/2010)
Agreed, but since the rebuild recreates the entire index regardless of what state it's in, it shouldn't be affected by how fragmented the index is, whereas the reorganise likely...
August 10, 2010 at 1:16 pm
Red Gate SQL Compare Pro comes with a command line utility. It can be completely automated.
August 10, 2010 at 12:38 pm
GilaMonster (8/10/2010)
Grant Fritchey (8/10/2010)
August 10, 2010 at 12:37 pm
Well, that "solution" is pretty dangerous. You just forced every query to go through a recompile, which can be pretty costly, depending on the query. It's likely that you're experiencing...
August 10, 2010 at 12:33 pm
GilaMonster (8/10/2010)
Megistal (8/10/2010)
If that...
August 10, 2010 at 12:25 pm
I think you're assuming that SQL Server would move all the pages in the clustered index if a split occurs. It wouldn't. It would only move the information on the...
August 10, 2010 at 12:23 pm
What business need is being satisfied by pulling all the data? Users do not look at anything past a few hundred rows in general. If you're looking at data migration,...
August 10, 2010 at 11:51 am
You'll still possibly end up with page splits in the nonclustered index AND you'll be dealing with the fact that your structure isn't taking advantage of a good clustered index....
August 10, 2010 at 11:48 am
Viewing 15 posts - 14,476 through 14,490 (of 22,211 total)