Viewing 15 posts - 7,696 through 7,710 (of 18,923 total)
webrunner (10/5/2010)
Looks like it's getting close. Post 1000000 May happen today or tomorrow.Good luck.
- webrunner
No way... we're only getting a few 100s posts per day.
October 5, 2010 at 8:07 am
jameyschaetzel (10/4/2010)
Thanks for the quick response; so something like this:
UPDATE #temp_client_spend SET actual = (SELECT sum(billdol) FROM tc
inner join mat on mat = mmat
WHERE client = @client and woper...
October 4, 2010 at 9:53 am
I'm on 2008 standard sp 1and there's nothing left.
Thanks for the script.
October 1, 2010 at 5:37 pm
Hmm interesting info here.
Got any scripts that finds those indexes or is it just based on filtering on index names?
October 1, 2010 at 1:47 pm
getoffmyfoot (10/1/2010)
What I am seeing though is alot of sub-selects in where clauses of sub-selects in where clauses of sub-selects in where clauses in....
Yes I'd like to...
October 1, 2010 at 12:55 pm
And here's another one.
DTA crashes even with a simplist query but with a DB with 7000 objects.
https://connect.microsoft.com/SQLServer/feedback/details/608926/dta-unsuable-with-7000-objects-in-db
October 1, 2010 at 10:56 am
Hey that joke still works for GWB's lineage! :hehe:
October 1, 2010 at 9:39 am
Steve Jones - Editor (10/1/2010)
October 1, 2010 at 8:57 am
GilaMonster (9/30/2010)
Bear in mind that in read-heavy (or read only) situations (reporting DB, data warehouse) many more indexes may be desirable than for an OLTP system.
Another exemple. I have...
September 30, 2010 at 2:33 pm
Steve Jones - Editor (9/29/2010)
Each post has the ID counter for it under it to the left.Getting close to a million after 9 years.
Wow, so much content and yet that's...
September 29, 2010 at 3:00 pm
No dice, I've already done all those things.
September 29, 2010 at 2:55 pm
... the magic reboot didn't work.
I've even removed the file from my own dev machine to make sure I was accessing the prod file.
So from ssms on dev, I can...
September 29, 2010 at 2:54 pm
Not quite... drop 1200 tables and leave the 100ish used tables.
Something tells me that it might be a bad idea :hehe:.
September 29, 2010 at 2:46 pm
Daniel Bowlin (9/29/2010)
Where do you see the total number of posts?
Look a couple lines under your name and you'll see this :
Post #995597
September 29, 2010 at 2:45 pm
Viewing 15 posts - 7,696 through 7,710 (of 18,923 total)