SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Alias yes or no for Performance
 New Topic  Reply to Topic
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 6

spirit1
Cybernetic Yak Master

Slovenia
11751 Posts

Posted - 04/11/2007 :  10:25:58  Show Profile  Visit spirit1's Homepage  Reply with Quote
think BAD code

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30282 Posts

Posted - 04/11/2007 :  10:31:40  Show Profile  Visit SwePeso's Homepage  Reply with Quote
Better And Drugfree ?


Peter Larsson
Helsingborg, Sweden

Edited by - SwePeso on 04/11/2007 10:32:01
Go to Top of Page

SQLUSA
Starting Member

28 Posts

Posted - 04/11/2007 :  21:39:46  Show Profile  Visit SQLUSA's Homepage  Reply with Quote
From time to time newbie DBA-s or network admins who have hazy ideas about what makes a SQL Server tick, think that there is a magic setting which speeds up a sluggish server! Some of the db option or server settings!

Along this line, using schemas in one database as opposed to several databases or this one: table ALIAS!

Face it now: BAD CODE, MISSING INDEX, FRAGMENTED INDEX, etc. are the real culprit for server misery!

This is not witchcraft, this is science!

Kalman Toth, Database, DW & BI Architect
SQL Server 2005 Training - http://www.sqlusa.com
Go to Top of Page

blindman
Flowing Fount of Yak Knowledge

USA
2365 Posts

Posted - 04/12/2007 :  00:03:11  Show Profile  Reply with Quote
From time to time newbie posters jump on a thread and post generic platitudes that they consider the height of wisdom without taking the time to read what other people have posted or figure out what the discussion is about.
This is clueless!

e4 d5 xd5 Nf6
Go to Top of Page

blindman
Flowing Fount of Yak Knowledge

USA
2365 Posts

Posted - 04/12/2007 :  00:35:25  Show Profile  Reply with Quote
Kalman, are you planning to start using this forum for spamming your CDs as you have been doing on this forum:
http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=257&threadid=84711&highlight_key=y
I liked this quote from a different thread:
quote:
This is a typical sqlusa thread. Everyone else does all the work, and then he tries to swoop in and get the glory, without actually saying anything meaningful. And he gets his post count up to try to fool newbies into thinking that he actually knows what he's talking about, not to mention the callous abuse of unsolicited advertising. Really pathetic.

And this must be the post where you found out about sqlteam.com?
http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=74&threadid=84956&highlight_key=y

You will find that the people here are not noobs, but highly trained professionals with very finely tuned B.S. detectors. You are not going to get good google hits here.

e4 d5 xd5 Nf6
Go to Top of Page

Antonio
Posting Yak Master

United Kingdom
168 Posts

Posted - 04/12/2007 :  06:37:50  Show Profile  Visit Antonio's Homepage  Reply with Quote
quote:
Originally posted by blindman

Kalman, are you planning to start using this forum for spamming your CDs as you have been doing on this forum:
http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=257&threadid=84711&highlight_key=y
I liked this quote from a different thread:
quote:
This is a typical sqlusa thread. Everyone else does all the work, and then he tries to swoop in and get the glory, without actually saying anything meaningful. And he gets his post count up to try to fool newbies into thinking that he actually knows what he's talking about, not to mention the callous abuse of unsolicited advertising. Really pathetic.

And this must be the post where you found out about sqlteam.com?
http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=74&threadid=84956&highlight_key=y

You will find that the people here are not noobs, but highly trained professionals with very finely tuned B.S. detectors. You are not going to get good google hits here.

e4 d5 xd5 Nf6



You need to calm down. What's all investigative activity for?!
If you want to discredit his "opinion" then do it here but providing links to other communities where people might hold his "opinions" in his regard is plain wrong.

I know there is a lot of good knowledge to be gained here but I can't help feel that there is some form of SQLTeam gang culture on this site. It's probably what keeps me away from contributing to questions and stick to asking them only.


_________________________________________________________________________________________________________________________
Inability is a disaster; patience is bravery; abstinence is a treasure, self-restraint is a shield; and the best companion is submission to Divine Will.
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30282 Posts

Posted - 04/12/2007 :  06:52:27  Show Profile  Visit SwePeso's Homepage  Reply with Quote
Antonio, let me ask you one question.
When you ask a question (here or elsewhere), you do count on the answer is accurate, right?

What we have found out, is that SQLUSA is almost never accurate and all answers are links to his site where the first thing you see is an ad "Buy this 1600 dollar, 21 disc, education package and you will be a professional DBA earning a minimium of 60K-80K per year". His answers are often to general to be helpful.

Ok, I lied. I have to ask you one more question
Antonio, look at this topic http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=80639
quote:
Posted by SQL USA
USE AdventureWorks;
GO
SELECT VendorID, [164] AS Emp1, [198] AS Emp2, [223] AS Emp3, [231] AS Emp4, [233] AS Emp5
FROM 
(SELECT PurchaseOrderID, EmployeeID, VendorID
FROM Purchasing.PurchaseOrderHeader) p
PIVOT
(
COUNT (PurchaseOrderID)
FOR EmployeeID IN
( [164], [198], [223], [231], [233] )
) AS pvt
ORDER BY VendorID

Would you like your specific question be answered with some code copied directly from Books Online (AdventureWorks database), having nothing to do with your problem?

We don't mind him being here! He has a LOT to learn.
All we want is that the unsolicited advertising ends.

But he does not get it.


Peter Larsson
Helsingborg, Sweden

Edited by - SwePeso on 04/12/2007 07:01:44
Go to Top of Page

Kristen
Test

United Kingdom
22431 Posts

Posted - 04/12/2007 :  07:17:34  Show Profile  Reply with Quote
+1 to what Peso said.
Go to Top of Page

Antonio
Posting Yak Master

United Kingdom
168 Posts

Posted - 04/12/2007 :  07:25:35  Show Profile  Visit Antonio's Homepage  Reply with Quote
quote:
Antonio, let me ask you one question.
When you ask a question (here or elsewhere), you do count on the answer is accurate, right?


Of course....

quote:
What we have found out, is that SQLUSA is almost never accurate and all answers are links to his site where the first thing you see is an ad "Buy this 1600 dollar, 21 disc, education package and you will be a professional DBA earning a minimium of 60K-80K per year". His answers are often to general to be helpful.


LOL... yes I did visit his site.... My conclusion is that he's a WUM at best.

quote:
We don't mind him being here! He has a LOT to learn.
All we want is that the unsolicited advertising ends.

But he does not get it.


Which is why my suggestion is to ignore him/her.

Anyway Peso, I don't think it's healthy to spend too much time talking about a WUM. I only posted my opinion because I don't think its right to bring other forums in to this. Rip him to bits on here but linking to other SQL forums to discredit him is going to far IMHO.

_________________________________________________________________________________________________________________________
Inability is a disaster; patience is bravery; abstinence is a treasure, self-restraint is a shield; and the best companion is submission to Divine Will.

Edited by - Antonio on 04/12/2007 07:31:06
Go to Top of Page

blindman
Flowing Fount of Yak Knowledge

USA
2365 Posts

Posted - 04/12/2007 :  08:15:14  Show Profile  Reply with Quote
That's your opinion, Antonio. But most of us heavy posters on here also frequent other forums. I see no reason why misbehavior on other forums should not be pointed out.

WUM? http://acronyms.thefreedictionary.com/WUM


e4 d5 xd5 Nf6
Go to Top of Page

pootle_flump
Flowing Fount of Yak Knowledge

United Kingdom
1064 Posts

Posted - 04/12/2007 :  08:17:01  Show Profile  Reply with Quote
quote:
Originally posted by blindman
WUM?
Wind Up Merchant.

And no - I would not describe SQLUSA as a WUM. WUMs wind people up but not everyone that winds people upo is a WUM.
Go to Top of Page

blindman
Flowing Fount of Yak Knowledge

USA
2365 Posts

Posted - 04/12/2007 :  08:21:42  Show Profile  Reply with Quote
Wind Up Merchant? That leaves me nearly as clueless as WUM.

e4 d5 xd5 Nf6
Go to Top of Page

pootle_flump
Flowing Fount of Yak Knowledge

United Kingdom
1064 Posts

Posted - 04/12/2007 :  08:44:53  Show Profile  Reply with Quote
Either you are yanking my chain (are you a WUM too?) or this is colloquial English that did not make it into the final draft of American.
http://www.usingenglish.com/reference/phrasal-verbs/wind+up.html
third definition.
Go to Top of Page

Antonio
Posting Yak Master

United Kingdom
168 Posts

Posted - 04/12/2007 :  09:02:20  Show Profile  Visit Antonio's Homepage  Reply with Quote
quote:
Originally posted by pootle_flump

Either you are yanking my chain (are you a WUM too?) or this is colloquial English that did not make it into the final draft of American.
http://www.usingenglish.com/reference/phrasal-verbs/wind+up.html
third definition.



I don't think blindman is in to urine extraction

_________________________________________________________________________________________________________________________
Inability is a disaster; patience is bravery; abstinence is a treasure, self-restraint is a shield; and the best companion is submission to Divine Will.
Go to Top of Page

Antonio
Posting Yak Master

United Kingdom
168 Posts

Posted - 04/12/2007 :  09:04:20  Show Profile  Visit Antonio's Homepage  Reply with Quote
quote:
Originally posted by blindman

That's your opinion, Antonio. But most of us heavy posters on here also frequent other forums. I see no reason why misbehavior on other forums should not be pointed out.

WUM? http://acronyms.thefreedictionary.com/WUM


e4 d5 xd5 Nf6



Averaging 1.84 ppd is heavy posting?!

BTW, noticed that you live in Delaware. I have an uncle who lives there. Nice place apparently.

_________________________________________________________________________________________________________________________
Inability is a disaster; patience is bravery; abstinence is a treasure, self-restraint is a shield; and the best companion is submission to Divine Will.
Go to Top of Page

blindman
Flowing Fount of Yak Knowledge

USA
2365 Posts

Posted - 04/12/2007 :  09:44:46  Show Profile  Reply with Quote
1000 posts is heavy posting.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=81981&bcsi_scan_E76B4D622438BEEE=5Qi3wGskkUpOUxTGcll6bAkAAADS7g8E&bcsi_scan_filename=topic.asp


e4 d5 xd5 Nf6
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30282 Posts

Posted - 04/12/2007 :  09:59:36  Show Profile  Visit SwePeso's Homepage  Reply with Quote
And when you're at it, http://www.sqlteam.com/forums/members.asp


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 04/12/2007 :  13:17:21  Show Profile  Reply with Quote
quote:
Originally posted by Antoni

I can't help feel that there is some form of SQLTeam gang culture on this site. It's probably what keeps me away from contributing to questions and stick to asking them only.


Cool, I've always wanted to be part of a gang...you graz, what's our colors?

If you say blue, light blue and white, we will all get a beating

dig, yo yo



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 04/12/2007 :  13:19:03  Show Profile  Reply with Quote
quote:
Originally posted by blindman

1000 posts is heavy posting.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=81981&bcsi_scan_E76B4D622438BEEE=5Qi3wGskkUpOUxTGcll6bAkAAADS7g8E&bcsi_scan_filename=topic.asp


e4 d5 xd5 Nf6



Here's some more heavy posting

http://www.dbforums.com/memberlist.php?&order=DESC&sort=posts&pp=30<r=



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page
Page: of 6 Previous Topic Topic Next Topic  
Previous Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000