Viewing 15 posts - 12,061 through 12,075 (of 22,214 total)
Steve Jones - SSC Editor (8/15/2011)
Grant Fritchey (8/15/2011)
August 15, 2011 at 10:18 am
Kiara (8/15/2011)
Grant Fritchey (8/15/2011)
Kiara (8/15/2011)
GilaMonster (8/14/2011)
Anyone want to add anything here: http://www.sqlservercentral.com/Forums/Topic1158751-10-1.aspx. Looks like the guy's making decisions for all the wrong reasons, lot of arrogance of youth there too
*sigh*...
August 15, 2011 at 6:19 am
GilaMonster (8/15/2011)
Grant Fritchey (8/15/2011)
He's young and male. Therefore, he's a moron.
My take too, and why I mostly ignored that comment. Plus for the last year I've been working with...
August 15, 2011 at 6:18 am
There's no easy way to move a sub-set of the data. You have to take into account that there are so many relationships to maintain between all the tables, you...
August 15, 2011 at 6:10 am
Kiara (8/15/2011)
GilaMonster (8/14/2011)
Anyone want to add anything here: http://www.sqlservercentral.com/Forums/Topic1158751-10-1.aspx. Looks like the guy's making decisions for all the wrong reasons, lot of arrogance of youth there too
*sigh* I wish I...
August 15, 2011 at 6:03 am
If you loathe technology, don't do it. It's not worth it. I love technology and sometimes hate this job. If I didn't absolutely love the problems I was dealing with...
August 15, 2011 at 6:00 am
Also, if your servers are getting that out of sync, you might want to reexamine your development and deployment processes. Tools like SQL Compare will help a lot, but having...
August 15, 2011 at 5:40 am
Some DDL operations are also available in the default trace, but not all.
Otherwise, you need to set up a system for monitoring this ahead of time.
August 15, 2011 at 5:39 am
You're scanning almost 11 million rows. That's just going to be slow. No way to add some WHERE clauses to the query to limit the result set? Add in the...
August 14, 2011 at 6:12 am
I concur. You need to address the root causes, not simply try to limit the size of tempdb. In fact, as you're finding, you won't be able to. If whatever...
August 14, 2011 at 5:18 am
Have you checked the execution plan?
From the looks of things, it's going to be scanning the temp table because you don't have indexing there. As data sizes grow, performance will...
August 14, 2011 at 5:16 am
The different types of JOIN operations are not interchangeable. They mean, and do, different things. You need to focus on that first. Changing the JOIN type as a means of...
August 14, 2011 at 5:13 am
No one knows for sure. The thing is, everything is not going to move out of all companies, but the trend is towards more & more stuff in the cloud....
August 14, 2011 at 5:05 am
Just remember that if you turn the query into a stored procedure and you use parameters, you're more likely to get the plan similar to when you hard code the...
August 14, 2011 at 4:56 am
Hey guys, want a free little toy from Red Gate? It's called Tab Magic and remembers what tabs you had open when you close SSMS. Kinda cool. A product of...
August 12, 2011 at 7:38 am
Viewing 15 posts - 12,061 through 12,075 (of 22,214 total)