Viewing 15 posts - 48,136 through 48,150 (of 49,571 total)
Do you have chapter and page? I have the book at home. I'll check it out tonight.
December 4, 2007 at 5:19 am
Ramesh (12/4/2007)
December 4, 2007 at 4:57 am
Alexandru Petre Ionescu (12/4/2007)
insert into dbo.Questions(FormID,QuestionTitle, QuestionText, AnswerType,LevelID)
select distinct FormID,QuestionTitle,QuestionText,QuestionType,LevelID
from dbo.MapFile
The "select distinct" is ordering data on the "FormID" field wich is not good to me.
The order applied on...
December 4, 2007 at 4:54 am
vyas (12/4/2007)
Table variables require less locking and logging resources than temporary tables, so table variables should be used whenever possible.
Not always.
Table variables cannot have indexes on them (other than a...
December 4, 2007 at 4:32 am
If you want the data returned in a specific order, you need to add an order by clause. Data in a table is not considered in any particular order. In...
December 4, 2007 at 4:28 am
The tran logs can be read, but they are not easy to understand and they don't contain information about people logging in and they don't keep info about who did...
December 4, 2007 at 12:24 am
If you capture the event SP_StmtCompleted (under stored procedures), yes.
Profiler/SQL trace have massive numbers of events that can be traced. Just depends what you want to capture.
December 4, 2007 at 12:15 am
If that was my table, I'd start by finding all the queries that refer to that table (profiler can help here), then in a dev environment, get a copy of...
December 4, 2007 at 12:11 am
Watch out for the simulations. They trip a lot of people up.
December 4, 2007 at 12:01 am
montgomery johnson (12/3/2007)
When I query master..sysprocesses I only get 1 record.
You need view server state permissions to see anything other than your own connection. I assume you're not sysadmin.
December 3, 2007 at 11:59 pm
Not many places. I've very very seldom needed a cross join. It's more common to have a cross join accidentily because of leaving out one or more join criteria.
Generally, if...
December 3, 2007 at 11:58 pm
Yup. Two windows (often I have more), replying to a post in more than one. Because of slow internet, I use multiple windows (at work) or multiple tabs (at home)...
December 3, 2007 at 11:46 pm
John Rowan (12/3/2007)
I was more referring to when someone posts a T-SQL question to the 2000 forum and the post gets answered with new 2005 stuff.
I'm usually careful with...
December 3, 2007 at 11:45 pm
John Rowan (11/27/2007)
I agree in that I've read sooo many posts that were so badly presented that I simply move on to another.
Likewise. I only have so much...
December 3, 2007 at 7:15 am
Or to do all the candidates in one go, rather than one at a time.
-- update where matched
UPDATE Candidates Set Candidates.Column1 = New_Candidates.Column1, ....
FROM New_Candidates
WHERE Candidates.Candidate_ID = New_Candidates.Candidate_ID
-- Insert...
December 3, 2007 at 5:44 am
Viewing 15 posts - 48,136 through 48,150 (of 49,571 total)