Viewing 15 posts - 766 through 780 (of 1,790 total)
Ninja's_RGR'us (2/13/2009)
That just bout answer it... open straight in BOL...ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/extran9/html/d33985f7-1048-4023-83e4-274090acda78.htm
UPPER (SSIS)...
Sad more than anything. Can't believe someone could take so much time working out a solution that already exists in...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 13, 2009 at 11:43 am
What are you using to execute the stored procedure? Is this part of a job or an application? Curious.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 13, 2009 at 11:19 am
Jeff - I am wondering why you are considering using Read Committed Snapshot. Any chance you could share your thoughts behind this?
Thanks in advance.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 13, 2009 at 11:15 am
Another note on this too, at the end of the blog post Bob mentions the potential for too many VLF's in the log file and that may be true and...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 13, 2009 at 8:54 am
A great article on this, albeit a bit late, from Bob Dorr can be found HERE. Might be worthwhile to read so that you can speak intelligently about the recovery...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 13, 2009 at 8:19 am
The lumigent tool that you would want to look at it called AuditDB and can be found at this LINK. Having had to support both SOX and HIPAA, that product...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 13, 2009 at 8:09 am
My guess is that this is due to the way the sp_MSForeachdb actually works in that it runs the statement in the database then moves on with each statement execution...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 13, 2009 at 7:40 am
One important note, and I believe that Kim expresses this, partitioning is not necessarily the answer to performance. It can be a great improvement in performance for those areas where...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 12, 2009 at 2:29 pm
A great place to start would be this article from Kim Tripp.
Hope this is helpful.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 12, 2009 at 12:12 pm
free_mascot (2/12/2009)
I feel...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 12, 2009 at 6:23 am
Naw, I just script anyway. 🙂
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 11, 2009 at 11:50 pm
Lynn Pettis (2/11/2009)
You've got to be kidding me....
I am, uh, um, not sure what to make of that. All I can say is ouch.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 11, 2009 at 11:26 pm
Click on My Account in the upper left hand side and then click on the change my email address.
Hope that works.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 11, 2009 at 3:02 pm
David B (2/10/2009)
What I don't trust is the fact that there is more than 1 David B floating around on the forums!Doppelganger!
😛
Yeah, just noticed you today too. Funny. I think...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 10, 2009 at 4:53 pm
GilaMonster (2/10/2009)
Bob Hovious (2/10/2009)
"I've just deleted some huge, important tables and I haven't been doing backups. How do I get these tables back?"
If you want to laugh...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 10, 2009 at 2:07 pm
Viewing 15 posts - 766 through 780 (of 1,790 total)