Viewing 15 posts - 2,071 through 2,085 (of 3,232 total)
What is the datatype of JudicialServicesPersonnelTypes.Description?
October 3, 2007 at 1:10 pm
Correct me if I'm wrong, but it looks like you are trying to use the LEFT JOIN to eliminate rows. If there is a match in the docs table,...
October 3, 2007 at 11:51 am
That is because this query will be processed by the query optimizer as an INNER JOIN instead of a LEFT JOIN because your WHERE clause is telling SQL Server that...
October 3, 2007 at 11:43 am
SELECT t1.ID1, t1.Reference
FROM Table1 t1
INNER JOIN (
SELECT Reference
...
October 3, 2007 at 10:27 am
Why is SSC go great? One word really sticks out to me, mentorship. I believe that people move in two directions in all areas of their life, forward...
October 3, 2007 at 9:14 am
The 2-3 GB of data that you are importing each day is going to require quite a bit of t-log space. Your import failed because you've limited the space....
October 2, 2007 at 1:21 pm
SELECT t1.*
FROM table1 t1
LEFT JOIN table2 t2
ON t1.id = t2.id AND t1.type = t2.type
WHERE t2.id IS NULL AND t2.type IS NULL
October 2, 2007 at 1:17 pm
Not everyone is a natural extrovert, but people skills can be learned. Here's a great people skills book:
http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?z=y&EAN=9780671027032&itm=1
The ability to relate to people will get you far. The...
October 1, 2007 at 3:16 pm
Look up NOLOCK in BOL. NOLOCK tells the query optimizer to not lock rows when performing a SELECT. The hit is that you are allowing for dirty reads....
September 28, 2007 at 2:13 pm
Remi and RBAR to the Rescue!! Sounds like a new Disney move...:smooooth:
September 26, 2007 at 5:16 pm
Since my last post, I have used the Recent Posts....Posts Since My Last Visit option and it appears to give me what I was used to seeing with the Active...
September 26, 2007 at 4:53 pm
Steve Jones - Editor (9/24/2007)
Is it the two clicks or something else. The old Active Topics was set to show things since your last login. (last visit).
Ah, ha. ...
September 26, 2007 at 4:38 pm
noeld (9/26/2007)
Jo Pattyn (9/26/2007)
in addition I would also export it to some text file(s) in case future sql versions won't support the old database format
wow I have never thought of...
September 26, 2007 at 4:15 pm
Take a tape backup and send it off site.
September 25, 2007 at 4:26 pm
CREATE UNIQUE INDEX IDX_PromoMeasure_PromotionType_AdType_DisplayType ON #PromoMeasure (PromotionType, AdType, DisplayType)
September 25, 2007 at 11:16 am
Viewing 15 posts - 2,071 through 2,085 (of 3,232 total)