I need to create a calculated measure that sums all of the activity(minutes) in my cube from the first date in the ActivityDate dimension until a...
I'm considering to approaches to integrating changes into an exisitng production db from a development db. The main challenge is how to deal with...
I found this while trying to find some information on wait types: http://sqldev.net/misc/WaitTypes.htm I found it to very helpful
I'm trying to set the "writed cache enabled" attribute on the drive for my log files;<br />however the option appears grayed out:...
I have a database that is using simple recovery model Evey night a large amount of batch inserts are performed against it through a custom program....
I have a database thats is showing a negitive number for unallocated space from the procedure sp_spaceused I have trying restrating sql server and...
Does anyone have any experience or metrics on SQL server 2000 running on windows server 2003? I have seen claims of increased file system...
Will Sql Server Cache the results of formulas, sprocs, and udfs in a query so that if you reference the result in another column it does not need to...
I found this snippet on the site<br /><br />"rewriting stored procedures as functions will not give you any performance benefits, and quite possibly,...
I found the following article on MSDN http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sqlbitmaps.asp it seems SQL...
For best join performance, the indexes on the columns being joined should be numeric data types, not CHAR or VARCHAR. The overhead is lower and join...
is there a way to determine the size of a given index? sp_spaceused will give me the size of all indexes on a table. I want to see the size of a...
I have data in a source table that needs to be transfered into a destination table on a nightly basis. Is it faster to use a SELECT INTO or to use...
I have the following query: SELECT CostName , Cost ,( SELECT MAX(price) FROM Prices ) AS MaxPrice -- Doesn't work ,(Cost - MaxPrice) AS...
I'm seeing about 300 log flushes per second in one of my load proccesses I'm basicly doing a bunch of sproc calls to insert statements is there a...
I'm monitoring one of my load proccesses and I'm seeing ~4 pagespilts per second. Is there any easy way to deterime what table or index is causing...
I have a very large table (over 30 milion records) when I run DBCC Show contig on the table using the fast option I show a Logical Scan Fragmentation...
Separate names with a comma.
