Viewing 15 posts - 40,576 through 40,590 (of 49,552 total)
Grant Fritchey (3/4/2009)
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
March 4, 2009 at 11:35 am
Lowell (3/4/2009)
for varchar strings, the = comparison operator strips out ending whitespace.
Char and varchar both behave this way.
create table #test
(phrase char(10))
insert into #test values ('phrase') -- will be padded out...
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
March 4, 2009 at 11:21 am
The cache is not refreshed real-time. To force a refresh, Edit -Intellisense -Refresh Local Cache (Ctrl-Shift-R)
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
March 4, 2009 at 11:18 am
SQL ignores trailing spaces when doing string comparisons, as required by the SQL standard
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
March 4, 2009 at 11:17 am
Grant Fritchey (3/4/2009)
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
March 4, 2009 at 11:12 am
Chris Morris (3/4/2009)
21. In case using GROUP BY without an aggregate function try using DISTINCT instead
What a coincidence. In a thread earlier today in which this poster was...
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
March 4, 2009 at 10:47 am
Peter (3/4/2009)
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
March 4, 2009 at 10:17 am
Derek Dongray (3/4/2009)
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
March 4, 2009 at 10:15 am
Lynn Pettis (3/4/2009)
Have you also noted that he changed his name? Now it doesn't match the name in the quoted replies to his deleted posts. :w00t:
That's easily fixable...
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
March 4, 2009 at 9:46 am
Mangal9i (3/4/2009)
Is there I'm missing something or it is known issue on the forums?
Known issue. The forum code doesn't escape the < and > and treats anything inside them as...
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
March 4, 2009 at 9:44 am
Peter (3/4/2009)
1) When inserting multiple rows, is there any guarantee that they are inserted in the order in which they are selected in?
No but, if I recall, an Order By...
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
March 4, 2009 at 9:38 am
Mangal9i (3/4/2009)
My topic was, Answered Posts. Nobody is talking about that.
If you stick around here, get used to this. Threads drift off topic fairly often and, as I mentioned, Steve...
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
March 4, 2009 at 9:29 am
Derek Dongray (3/4/2009)
They must be giving out MVPs with breakfast cereal these days!:D
Hey! Be nice!
😉
I thought an MVP needed to do more than simply post a lot on MSDN?
Who knows....
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
March 4, 2009 at 9:27 am
Chris, judging by your posts here, you shouldn't have much trouble with the exam.
It's implementing and maintaining, so yes, more admin than dev. Beware the sims, that's where most...
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
March 4, 2009 at 9:21 am
Grant Fritchey (3/4/2009)
Holy smokes, a moderator and an MVP and he's that much of a jerk? I thought you had to be... you know... helpful... to make MVP?
In theory.
It's interesting,...
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
March 4, 2009 at 9:13 am
Viewing 15 posts - 40,576 through 40,590 (of 49,552 total)