Viewing 15 posts - 13,531 through 13,545 (of 22,213 total)
You should be testing anything new before you do it on your production database. No development environment or anything. You're developing straight onto production? That's very dangerous. I sure hope...
January 20, 2011 at 9:40 pm
Both files when I try to open them are giving me an error:
The XML page cannot be displayed
Cannot view XML input using style sheet. Please correct the error and...
January 20, 2011 at 12:41 pm
Out of the box, no additional installs or purchases, you can use Performance Monitor to gather metrics on stuff like Memory usage. It can also be used to monitor I/O,...
January 20, 2011 at 11:57 am
No, it was a stupid design.
January 20, 2011 at 11:19 am
Getting the exact same plan with that much data between a table variable & a temp table indicates something else is going on. Is auto-create stats or auto-update of stats...
January 20, 2011 at 11:14 am
Steve Jones - SSC Editor (1/20/2011)
January 20, 2011 at 10:52 am
We had a similar situation. A procedure (with a 76 table join) that was called hundreds of times in an hour. It hit so many tables and the data was...
January 20, 2011 at 10:41 am
Table variables like you're using show as having a single row because they don't have statistics. This can lead to seriously problematic execution plans, like you're seeing. If you have...
January 20, 2011 at 10:34 am
Personally, I wouldn't run it as a script. I'd use SQL Agent and a SQL Agent job with steps. It'll be much more functional, better error trapping, etc. If not...
January 20, 2011 at 8:28 am
It's going to be difficult to put 2tb into 100gb, virtual or not.
January 20, 2011 at 8:23 am
I actually just, just found another way you can do it. You can use extended events to capture all wait states on procedures as they occur. I don't have the...
January 20, 2011 at 8:22 am
That could work, but what other processes will be on the server? How much data do you have? I'm asking because i assume you're going virtual because you're going to...
January 20, 2011 at 8:14 am
sql_butterfly (1/20/2011)
Understood. It means as per thumb rule, the funtionality of a sproc should be as specific as possible and we should try to normalize the sproc as well.
Just so...
January 20, 2011 at 8:05 am
GilaMonster (1/20/2011)
Grant Fritchey (1/20/2011)
My most recent post was about why do log files fill up. Believe me, other people have posted about it.
A topic I'm in the middle of writing...
January 20, 2011 at 7:38 am
This is a somewhat big topic. There are probably 15-20 measures, minimum, that you ought to capture and interpret. You should also start capturing wait states to see what things...
January 20, 2011 at 7:32 am
Viewing 15 posts - 13,531 through 13,545 (of 22,213 total)