Viewing 15 posts - 1,246 through 1,260 (of 7,636 total)
Here's one that reminded me of many of the questions the we get: http://dilbert.com/strips/comic/2009-12-07/
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 7, 2009 at 3:03 pm
Alvin Ramard (12/7/2009)
Grant Fritchey (12/7/2009)
Number 6 (12/7/2009)
At least he put it in the Hardware section of the Forums....They're talking about fixing mice, what are you doing here Alvin? Run! Run!
Grant,...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 7, 2009 at 2:55 pm
GabyYYZ (12/7/2009)
And now for something completely different, a coworker, non-DBA, forwarded me this link. I thought it was a hilarious Dilbert: http://www.dilbert.com/strips/comic/2009-11-01/%5B/url%5DEdit: Fixed hyperlink
Yeah, I liked that one too....
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 7, 2009 at 2:43 pm
Glad I could help, angelo.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 7, 2009 at 2:20 pm
Right, the problem with enabling "guest" is that you are allowing everyone else who has any kind of access to your SQL Server to get into DB_B also, not just...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 7, 2009 at 2:05 pm
khushbu (12/6/2009)
(This is only one time activity.. So cursor is ok)
No it isn't. Professionals do not turn in inferior work just because it is for one-time use.
Here is how...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 7, 2009 at 1:48 pm
Jeff Moden (12/6/2009)
Bad day, Barry?
Heh, well, if I wanted to be a Jerk, I could say that since I've been an invalid for the last six weeks due to a...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 7, 2009 at 1:23 pm
David Portas (12/7/2009)
RBarryYoung (12/6/2009)
What would that do the DISTINCT, UNIQUE, and Primary Keys don't already do?
It would enable more advanced optimisation of queries and data access. SQL database engines are...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 7, 2009 at 1:12 pm
David Portas (12/6/2009)
RBarryYoung (12/6/2009)How can a relational query "preserve keys" across relational operations like PROJECT and JOIN?
Some examples:
P = PROJECT(a,b) R
If a is a key of R then a is...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 6, 2009 at 3:41 pm
David Portas (11/26/2009)
Relational queries preserve keys in their results, ...
I've been trying figure this out for a week now, and I just can't see how this is true. How...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 6, 2009 at 2:27 pm
What would that do the DISTINCT, UNIQUE, and Primary Keys don't already do?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 6, 2009 at 1:58 pm
Not necessarily. It just means that none of us answering happen to know the answer.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 6, 2009 at 1:56 pm
SQL_Quest-825434 (12/6/2009)
RBarryYoung (12/5/2009)
Also, an FYI for next time: SSIS questions will get better response in the Integration Services forum.
As it was a string manipulation question, so thought of posting...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 6, 2009 at 1:39 pm
Yes, could we please stop asking QotD's that only have correct answers for SQL Server 2000?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 5, 2009 at 9:48 pm
Just for reference, several years ago (2006) one of my co-workers did install just such a configuration for a customer and then did run the tests to demonstrate that SQL...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 5, 2009 at 9:32 pm
Viewing 15 posts - 1,246 through 1,260 (of 7,636 total)