Viewing 15 posts - 39,841 through 39,855 (of 49,552 total)
Jeff Moden (4/9/2009)
I believe you need to ping back and say it was an error. Read the last post on that link very carefully.
I'll take that 'apology' with a...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 10, 2009 at 12:59 am
The other potential problem being that there are cases where ISNUMERIC returns true, but the value cannot be cast to decimal. ISNUMERIC means that the value in question can be...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 9, 2009 at 3:47 pm
To do that, you'd need to cast the date to a varchar. Typically this is a presentation issue and shouldn't be done if this data is going to be inserted...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 9, 2009 at 1:55 pm
Dev (4/9/2009)
select * from SysUser where name like '%/_%' --> No...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 9, 2009 at 1:13 pm
WHERE SomeColumn LIKE '%/_%' ESCAPE '/'
The escape character makes SQL treat whatever follows it as a literal character.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 9, 2009 at 12:54 pm
If I'm understanding your requirements correctly, you want this:
SELECT count(*), status_code_id, bp_type_id, dateadd(mm, datediff(mm,0, effective_date),0) AS EffectiveMonth
FROM dbo.best_practice_version
WHERE dbo.best_practice_version.status_code_id IN (5, 4)
AND...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 9, 2009 at 12:07 pm
Bob Hovious (4/9/2009)
I have to ask (somewhat fearfully) how did Gail get to be Gila Monster?
😀 It's no secret or anything. The nickname dates back to University days and is...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 9, 2009 at 11:46 am
Grant Fritchey (4/9/2009)
And having seen the Gilamonster in action, I'm glad this isn't possible!
Man, I'm sorry I missed that seminar. She made a real impression.
Join us next time?...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 9, 2009 at 11:42 am
Might be a management studio bug. Try restoring using T-SQL?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 9, 2009 at 11:24 am
There are times I wish I could reach through the computer screen and beat some sense into people...
I don't know if anyone recalls, much earlier in this thread I posted...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 9, 2009 at 11:18 am
Lynn Pettis (4/9/2009)
And then there are those who really should not be giving advice. The code provided here wouldn't even pass a check in SSMS.
Are we really surprised?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 9, 2009 at 11:14 am
mzak (4/9/2009)
Is there any reason I should use one join over another?
Use CROSS JOIN when you really do want a cartesian product. Use INNER JOIN when you want exact...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 9, 2009 at 11:14 am
UB (4/9/2009)
But the problem is .... the record gets inserted into Patient table and z_audit_Patient table.
Yes, it will. As Gus said, it's due to ownership chaining.
If that's not the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 9, 2009 at 11:08 am
Please don't post in all caps. It's the online equivalent of shouting.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 9, 2009 at 10:59 am
Kavin (4/9/2009)
Anybody can guide me to move further..like what type of administration concepts they will ask and what type of simulation question will be there.
Answering either of those questions will...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 9, 2009 at 10:55 am
Viewing 15 posts - 39,841 through 39,855 (of 49,552 total)