Viewing 15 posts - 3,091 through 3,105 (of 6,486 total)
I'm kind of surprised noone brought up one of the most common source of our self-inflicted physical woes: the snack/soda machine down the hall and our usually deplorable eating habits....
May 30, 2008 at 11:02 am
Amazing how much attention you can devote to someone when they have you in a sleeper hold:)
May 30, 2008 at 10:53 am
Is this all of the time? or around startup?
the default sizing options for tempDB tend to be entirely inadequate. As I recall - it's 1MB with autogrowth in 1MB...
May 30, 2008 at 10:52 am
bcronce (5/30/2008)
May 30, 2008 at 10:17 am
Marios Philippopoulos (5/30/2008)
Matt, I was thinking of creating a .NET console app, but I'm not sure all...
May 30, 2008 at 10:11 am
You may also try windowing the AVG function, so you have access to your average without the GROUP BY. Performance doesn't seem so great on those with big groups,...
May 30, 2008 at 10:04 am
checkai (5/30/2008)
This should work within the report itself. I set a parameter's default to this and the results looked good.
=Switch(DatePart("w", now())=1,now(),DatePart("w", now())=2,DateAdd("d",-1,now()),
DatePart("w", now())=3,DateAdd("d",-2,now()),
DatePart("w", now())=4,DateAdd("d",-3,now()),
DatePart("w", now())=5,DateAdd("d",-4,now()),
DatePart("w", now())=6,DateAdd("d",-5,now()),
DatePart("w", now())=7,DateAdd("d",-6,now()))
Or slightly simpler....
=DateAdd("d",1-weekday(now(),vbSunday), now())
May 30, 2008 at 9:37 am
Is this DTS or SSIS? You've now got the question posted in two forums under two different versions. Urgent perhaps, but you're not going to get coherent help...
May 30, 2008 at 9:34 am
Interestingly enough, if I watch the SQLServ process in task manager (on my Dev Ed. install) - it starts with about 25MB on the very first reading. Of course...
May 30, 2008 at 9:09 am
Matt Whitfield (5/30/2008)
Matt Miller (5/30/2008)
May 30, 2008 at 8:53 am
Marios Philippopoulos (5/30/2008)
SQL ORACLE (5/29/2008)
at 6:30pm /EVERY:Monday,Tuesday,Wednesday,Thursday,Friday,Sunday "c:\stop.bat"
at 6:30pm /EVERY:Monday,Tuesday,Wednesday,Thursday,Friday,Sunday "c:\start.bat"
Where stop.bat
net start...
May 30, 2008 at 8:49 am
JohnG (5/30/2008)
PK - can't see it making much difference at all.
Again, a typical "off the cuff" remark without thinking. I'm not saying ALL the time. One thing that...
May 30, 2008 at 8:27 am
swarada1783 (5/30/2008)
One more doubt. I set the AutoShrink option on the database to True. But unless I explicitly shrink the database it is not working. What could...
May 30, 2008 at 8:18 am
Argh... you're running an EAV setup. That explains it.... Sorry - I just had to ask the question...:D
I was going to suggest using a backdoor around resetting...
May 30, 2008 at 8:11 am
GilaMonster (5/30/2008)
Matt Miller (5/29/2008)
May 30, 2008 at 7:41 am
Viewing 15 posts - 3,091 through 3,105 (of 6,486 total)