Viewing 15 posts - 1 through 15 (of 17 total)
Thought the same thing myself, found out you can assign a drive letter to the mount point, then CrystalDiskMark will see each of your mount point, provided of course you...
May 20, 2013 at 8:39 am
Best practice guidelines for tempdb (both 2005 & 2008) clearly states that tempdb files should be of fixed size, one per cpu (max of 8, diminishing returns with more than...
April 30, 2010 at 12:43 pm
In MHO, making a change to the underlying table structure is NOT a workaround. (period!) Therefore, the only "workaround" solution is to change the select statement. 😉
November 6, 2008 at 11:02 am
DBCC SHOWCONTIG...
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use...
August 5, 2008 at 7:55 am
been using LiteSpeed for about a year now... works as advertised!
10:1 compression, or there abouts... your mileage may vary...
easy to use interface...
has saved me a few times... for me,...
June 27, 2006 at 2:07 pm
what is the memory utilization on the server?
what is the status of maintence jobs, you should be able to see the status of any jobs run via the Event Viewer...
March 31, 2006 at 7:58 am
regarding the .mdf file... yes, checking the properties shows when the file was created, the "Modified" and "Accessed" times will coincide with the last time the SQL Server was restarted...
March 13, 2006 at 1:12 pm
March 13, 2006 at 11:16 am
in my situation... INDEXDEFRAG can only be use to clear up minor fragmentation... DBREINDEX will be used for the bulk of the reorganization...
February 15, 2006 at 6:42 am
thanks for your initial input... I'll take a look at cliconfig.exe...
more background... the servers where dblinks are functioning properly are our primary production servers...
the NON-functioning servers were built as failover...
February 14, 2006 at 7:45 am
Balmukund -> "Do you have auto-shrink option enable for the database?"
NO!, NO WAY! 😉
I'm currently taking a look at a solution offered up by Nicholas Cain... I like the fact...
February 14, 2006 at 7:31 am
>>"2) The users have not reported any problems, so is this a serious problem?"
it depends, if the corruption is isolated, the users may not actually access the part of the...
February 2, 2006 at 2:34 pm
along those lines, another thing you might look at is the following command:
dbcc sqlperf (logspace)
you might be surprised at just how much space you have allocated, that is NOT being...
February 2, 2006 at 2:09 pm
how often are you dumping the transaction log?
have you ever attempted to shrink the database files?
DBCC SHRINKFILE /* for the log file */
get the file id by using sp_helpfile
DBCC...
February 2, 2006 at 1:55 pm
Viewing 15 posts - 1 through 15 (of 17 total)