Viewing 15 posts - 2,386 through 2,400 (of 18,926 total)
I can't debug this for you. You need to restart from the begining and add 1 thing at a time and make sure it works at all steps.
September 22, 2011 at 7:14 am
P.S. This is a free "service". We don't work for you and we are not getting paid to help.
Thank you for your patience and understanding, even if you are...
September 22, 2011 at 6:36 am
Well the normal query would look something like this =>
SELECT * FROM dbo.BannerPlacements WHERE GETDATE() BETWEN StartDateTime AND EndDateTime
Unfortunately here you don't use defaults which makes this fail so you...
September 22, 2011 at 6:33 am
That sounds actually pretty good (assuming the box is dedicated to the server).
It's normal to leave arm for the OS and 3 GB sounds decent.
SQL will literally take al lthe...
September 22, 2011 at 6:16 am
What are you going to do?
Your answers changes the correct solution.
#1 is if
#2 and most likely is a case statement.
September 22, 2011 at 6:12 am
Resender (9/22/2011)
September 22, 2011 at 6:11 am
You either forgot a log backup or the table was gone by the time you took the full or diff.
What's left is if the table is in the full but...
September 22, 2011 at 5:47 am
Kiara (9/22/2011)
GilaMonster (9/22/2011)
Jim Murphy (9/21/2011)
And where's Gail? Is she not keeping you guys in line?
Doing the final checks and tweaks on Jonathan's book.
Keep this lot in line? How would...
September 22, 2011 at 5:41 am
Resender (9/22/2011)
Found that blog as well & did try that, but it seemed to have no effect so far.
Maybe there's a separate cache feature for the graphs ?!?!
September 22, 2011 at 2:36 am
I c your point. The problem is that it's going to be the same change management limitations !
September 21, 2011 at 5:11 pm
scale up means you buy a bigger server and move the dbs there.
Scale out means you can buy more servers and spread the load across. It's also nice to...
September 21, 2011 at 5:09 pm
tschmitt300 (9/21/2011)
Starting to wonder if that really is the best way to go here. Going to have to think about that unless anyone else has a good idea.Thanks!
I never...
September 21, 2011 at 5:07 pm
opc.three (9/21/2011)
@M_E_K, if this query is consistently pegging your DB instance where it affects other activity consider a defensive move...add a MAXDOP hint to the...
September 21, 2011 at 5:04 pm
This might be a case where I'd just go with it.
Shrink, rebuild all.
hopefully you can have a 60+ hours window on the w-e to make absolutely sure it all runs...
September 21, 2011 at 4:53 pm
SQLRNNR (9/21/2011)
Ninja's_RGR'us (9/21/2011)
SQLRNNR (9/21/2011)
Ninja's_RGR'us (9/21/2011)
Steve Jones - SSC Editor (9/21/2011)
Just a note, in case you didn't see it, Jeff's interview is up: http://www.sqlservercentral.com/articles/Exceptional+DBA+Awards/75986/
Forget that crap, this is even better!
http://www.sqlservercentral.com/Forums/FindPost1179084.aspx
CELKO (9/21/2011)
...
September 21, 2011 at 4:49 pm
Viewing 15 posts - 2,386 through 2,400 (of 18,926 total)