Viewing 15 posts - 931 through 945 (of 3,221 total)
All the concern about protecting data, yes as a DBA you may have a significant role to insure that sensitive data is protected. But how many of you have...
October 19, 2011 at 9:27 am
First of all your table definitions contained a few errors and I corrected same as shown below. I then inserted one row of data into each table.
CREATE TABLE #DONORS(...
October 18, 2011 at 6:38 pm
Roy Ernest (10/18/2011)
Jeff Moden (10/18/2011)
bitbucket-25253 (10/17/2011)
Thanks for all you have...
October 18, 2011 at 10:04 am
Test your code, with this variation. Instead of using a TABLE VARIABLE (@Table) use a Temp Table (#Table)
Look at the QOD posted on 10/03/2011 at
http://www.sqlservercentral.com/Forums/Post.aspx?SessionID=mqk3w345ndswzpnnc0a4njj4
October 18, 2011 at 7:54 am
Jeff for a guy who is 2 days older than dirt, from a guy who is 3 days older than dirt
Thanks for all you have done to teach myself and...
October 17, 2011 at 7:04 pm
Jeff for a guy who is 2 days older than dirt, from a guy who is 3 days older than dirt
Thanks for all you have done to teach myself and...
October 17, 2011 at 7:00 pm
October 15, 2011 at 7:39 am
REad this and try the code to learn
or this one .. does not require as much code
http://cybersql.blogspot.com/2009/12/yes-table-variables-and-temp-tables.html
October 13, 2011 at 8:44 pm
Look up DML triggers .. in Books On LIne. Pay particular attention to the INSERTED and DELETED tables that triggers can generate
October 12, 2011 at 5:23 pm
Lynn Pettis (10/12/2011)
Gianluca Sartori (10/12/2011)
Lynn Pettis (10/12/2011)
October 12, 2011 at 5:17 pm
george sibbald (10/12/2011)
this trip into space, is it one way or return?
Probably should purchase a lot of Redgate software to insure a retun trip
October 12, 2011 at 3:50 pm
Nice question. Took much too long to shake the cobwebs out of my brain.
October 12, 2011 at 9:34 am
WayneS
I'm very fortunate to know Jeff, and I'm honored to consider him a friend. He has taught, and continues to teach all of us many things. And not just high-performance...
October 12, 2011 at 7:53 am
Viewing 15 posts - 931 through 945 (of 3,221 total)