Viewing 15 posts - 5,686 through 5,700 (of 7,505 total)
You've heard some thoughts regarding performance gains.
Did you consider backup performance as well ?
Maybe not that much of a gain with sql2000, but with SQL2005 you'll also be able to...
June 15, 2007 at 1:48 pm
Just my 2ct
- you have to followup size and actual usage anyway.
- if you set maxsize, you have controle and can build a "critical disk reserve" so when the db...
June 15, 2007 at 1:37 pm
Can someone please explain why there is no base row for : ![]()
![]()
June 15, 2007 at 3:12 am
the easiest way is to open profiler and create a trace using your template.
Then export the trace-settings to a sqlscript.
Add a appropriate filename (see generated script) and copy/paste it to...
June 14, 2007 at 2:30 pm
June 14, 2007 at 7:45 am
yes, you are right. Adding the /3Gb should do the trick.
gotchas ? The /3Gb is in the boot.ini so it will need a reboot.
If you do your action on the...
June 14, 2007 at 2:19 am
Thanks for the support ![]()
Being sysadmin doesn't make you a god after all ![]()
June 13, 2007 at 1:54 am
indeed, the openrowset may be the "more dynamic" and "let's see what we get" way, but how will it behave regarding performance.
btw in house we are not alowed to use...
June 13, 2007 at 1:51 am
I've been to quick with my response using a text column ![]()
Aparently text/image operators cannot be used...
June 12, 2007 at 9:51 am
same goes for varcharcolumns of 8000 ![]()
Indeed these kind of constructions will have a cost !
CREATE FUNCTION [dbo].[fn_ALZDBA_GetFullDescription](@Index int)
RETURNS @tblFullDescription TABLE
(RefIndex int not...
June 12, 2007 at 7:17 am
- did you run DBCC UPDATEUSAGE ('master') with count_rows
followed by sp_updatestats
- I wonder what sp_helpfile returns ?
June 12, 2007 at 7:02 am
June 11, 2007 at 12:10 pm
maybe applying the Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 will help (or the latest cumulative hotfix 9.00.3161 )
KB 935356
June 11, 2007 at 7:05 am
- launch sql profiler and examine your most consuming queries.
- do you have "auto update statistics" activated ?
if not, did someone run sp_updatestats ?
changes in stats will...
June 11, 2007 at 12:23 am
do your connections use isolation level repeatable read (default for .net) in stead of read committed ?
June 9, 2007 at 9:20 am
Viewing 15 posts - 5,686 through 5,700 (of 7,505 total)