March 9, 2009 at 11:53 am
How about just categorizing it as Plain Old Laziness?? 😀
-Roy
March 9, 2009 at 11:55 am
GilaMonster (3/9/2009)
Lynn Pettis (3/9/2009)
You have to wonder what people are being taught when you see code like this:ALTER TRIGGER [dbo].[tr_insert]
ON [dbo].[table1]
AFTER INSERT
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
DECLARE @i INT
SELECT @i = COUNT(*) FROM inserted
SELECT @i
IF (@i > 1)
BEGIN
inser into table2
select * from table1 where date not in (select date from table2)
end
IF (@i = 1 )
begin
INSERT INTO [dbo].[table1]
([ReportDate]
,[EmployeeID]
,[CreatedDate]
,[CreatedBy])
select * from inserted
end
There are times you want to help, but you just don't know where to start.
And not content with posting that question 3 times, he PM'd me with it.
Hey, me too! I just ignored that PM because the same text was in the thread.
I handle PM's like this by posting the the text of the PM as a quote in my response on the thread, which is usually, "Please keep all related posts in this thread so that others can benefit as well."
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 9, 2009 at 11:55 am
Roy Ernest (3/9/2009)
How about just categorizing it as Plain Old Laziness?? 😀
Being able to research, find, and understand data is a skill. One skill he obviously doesn't have, or does not want to use at this time!
March 9, 2009 at 11:56 am
All right! Lynn is turning into one of those old school saints who wades in & beats the snot out of the unbelievers.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 9, 2009 at 11:59 am
K. Brian Kelley (3/9/2009)
DavidB (3/9/2009)
Laughing.... I have struggled down a path or two with that one before as well and found myself wondering if I was talking to two different people and then realizing that there was some really fundamental basic knowledge that was missing.I will say though that had you asked me that question, i.e. "want me to install it for you?", I might have answered "yes". 😛
I doubt lack of training is the problem with said user, having had my own interactions with him. The fact of the matter is that in one case had he typed in Google the key words from his question, the first three or four links laid out what he needed to do. That's not a training issue. I don't know what the issue is, but it's not about missing some fundamental basic knowledge unless it it a lack of knowledge on how to use a search engine.
Yeah, I didn't mean "fundamental basic knowledge" in context of Database Administration but more along the lines of technology as a whole. Not trying to be hard but some people really don't get it and will always be hindered by that. 🙂
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 9, 2009 at 12:00 pm
Lynn Pettis (3/9/2009)
Lynn Pettis (3/9/2009)
And Gail, its easy to see why you leave Mike to others to answer. I mean, really.Look at his latest post on that thread. I mean, you really have to be kidding.
I have to admit that I understand his concern about running an service pack install. I know I am always nervous when I do it on a production box. I do it on my personal machines without a care, but once I get to the real thing I do have concern. Of course I take backups of everything BEFORE starting the SP install.
Of course, I don't understand his misunderstanding of the advice he has already been given.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 9, 2009 at 12:01 pm
Grant Fritchey (3/9/2009)
All right! Lynn is turning into one of those old school saints who wades in & beats the snot out of the unbelievers.
That is too funny! Nearly choked on my sprite when I read that!
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 9, 2009 at 12:08 pm
GSquared (3/9/2009)
Grant Fritchey (3/9/2009)
All right! Lynn is turning into one of those old school saints who wades in & beats the snot out of the unbelievers.That is too funny! Nearly choked on my sprite when I read that!
I'm glad I wasn't trying to take a drink as i read this either. :w00t:
March 9, 2009 at 1:10 pm
Saints may not beat the snot out of the unbelievers but ancient Jedi Masters do....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 9, 2009 at 1:16 pm
Speaking of jedi masters and padawans.... I think I'm going to add the following disclaimer to all my future security articles:
"If you do not understand what this code is doing. DO NOT run it! You may end up locking yourself out of your own SQL Server.
Even with the explanation on the DAC some folks are putting the logon trigger in place and having a hard time undoing it after they effectively prevent themselves from logging in.
K. Brian Kelley
@kbriankelley
March 9, 2009 at 1:23 pm
Bob Hovious (3/9/2009)
Saints may not beat the snot out of the unbelievers ....
Actually, in D&D they do, St. Cuthbert being the "cannonical" example.
😀
[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]
March 9, 2009 at 1:24 pm
... some folks are putting the logon trigger in place and having a hard time undoing it after they effectively prevent themselves from logging in.
That may be a good thing. Maybe those people should be locked out in the first place.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
March 9, 2009 at 1:29 pm
Alvin Ramard (3/9/2009)
... some folks are putting the logon trigger in place and having a hard time undoing it after they effectively prevent themselves from logging in.
That may be a good thing. Maybe those people should be locked out in the first place.
Why? I run all code presented to me without thought. How else do I know what it does?
What does "Fatal Error" mean?
:hehe:
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
March 9, 2009 at 1:37 pm
K. Brian Kelley (3/9/2009)
"If you do not understand what this code is doing. DO NOT run it! You may end up locking yourself out of your own SQL Server."
If everyone put disclaimers like that on their articles and scripts that would only leave the people who do not have backups to complain about?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 15 posts - 2,416 through 2,430 (of 66,815 total)
You must be logged in to reply to this topic. Login to reply