Viewing 15 posts - 17,206 through 17,220 (of 39,958 total)
GWAk (1/10/2011)
If your ability to communicate via the written word is not the problem, but rather, the ability to communicate effectively, face-to-face,...
January 10, 2011 at 8:21 am
If you write the reversing transaction, then you should be OK, but you need to be sure this is what you want.
If you can, I'd write the reversing query in...
January 9, 2011 at 12:44 pm
This might help as well: http://www.sqlservercentral.com/articles/2688/
January 9, 2011 at 12:39 pm
GROUP BY - http://msdn.microsoft.com/en-US/library/ms177673%28v=SQL.90%29.aspx
Edit: wrong copy/paste
January 9, 2011 at 12:38 pm
Log reader tools can help, but do you know what the large transaction was? If so, you can write the "reversing" transaction yourself.
January 8, 2011 at 12:40 pm
I found this: http://www.sqlnewsgroups.net/sqlserver/t18795-32bit-sql-64bit-windows.aspx
If Linchi has done it, you should be OK.
Your plan should work, but I don't know that many people that have done it. Can I ask why...
January 8, 2011 at 10:11 am
Sounds like you know what to do.
If you get stuck in SSIS, post a note in that forum, and someone can likely help you.
January 8, 2011 at 9:33 am
After removing SQL Server 2008 from your workstation? I assume you mean you are getting this when you open Ss2K5 Management Studio, correct?
You might need to reinstall the SS2K5 tools....
January 8, 2011 at 9:31 am
Some good advice from Craig here. If you need a consult, even remotely, I have a few people I would recommend. They can likely give you some suggestions for a...
January 8, 2011 at 9:29 am
This (http://www.sqlservercentral.com/Forums/Topic1043954-146-2.aspx), IMHO, is a great example of why it's good to have multiple articles or blogs on a topic. Elliot and I seem to be saying the same thing,...
January 8, 2011 at 9:20 am
Javascript is amazing. It makes web pages so much more interactive and interesting. It runs in a fairly low privileged manner under your account, and it's an amazing language.
It's also...
January 8, 2011 at 9:16 am
I think it's more a question of how small is it until you get the "yes-it's-the-whole-fist-customer-service" treatment.
January 8, 2011 at 8:59 am
Mark has written a nice suggestions, but it would be nice to know *how* you back up the database and then shrink the log.
- a full backup does not...
January 8, 2011 at 8:54 am
Good thought, Gus.
A few wait stat posts:
http://www.sqlservercentral.com/blogs/sqlrnnr/archive/2010/12/13/wait-stats-resources.aspx
January 7, 2011 at 1:06 pm
Eric has summarized nicely what I would do.
One note, be sure adding the identity will not break other code.
January 7, 2011 at 1:04 pm
Viewing 15 posts - 17,206 through 17,220 (of 39,958 total)