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
 Site Related Forums
 The Yak Corral
 Twit List
 New Topic  Reply to Topic
 Printer Friendly
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 88

PSamsig
Constraint Violating Yak Guru

Denmark
384 Posts

Posted - 07/13/2011 :  12:48:32  Show Profile  Send PSamsig a Yahoo! Message  Reply with Quote
quote:
Originally posted by SwePeso

...
INNER JOIN (
values(666)
) D(id)
...



Never seen that before, even when joking, I learn something new. And isn't it strange, after I thought of the UPDATE OUTPUT to get rid of the SELECT, I didn't notice I ended up with a SELECT after all, thank you for saving me from my own ignorence :)

-- If you give someone a program, you will frustrate them for a day; if you teach them how to program, you will frustrate them for a lifetime.

Edited by - PSamsig on 07/13/2011 12:51:37
Go to Top of Page

JimL
SQL Slinging Yak Ranger

USA
1535 Posts

Posted - 07/19/2011 :  14:30:55  Show Profile  Visit JimL's Homepage  Reply with Quote
Help urgent I took a job I have absolutely no Idea how to do.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=163135

And this is the future of the human race?
I think the apes will win out after all.



Jim
Users <> Logic
Go to Top of Page

robvolk
Most Valuable Yak

USA
15658 Posts

Posted - 07/19/2011 :  15:34:35  Show Profile  Visit robvolk's Homepage  Reply with Quote
quote:
Originally posted by JimL
I think the apes will win out after all.
http://www.newtechusa.com/ppi/faq.asp
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 07/19/2011 :  16:54:44  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
I've got someone over at SSC that's been whining for 2 days that he wants a script to move indexes. No signs of any work. I'd help, but each time he whines I get less motivated to go and do the search for him. (link later if you want)

--
Gail Shaw
SQL Server MVP
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 07/19/2011 :  17:09:31  Show Profile  Reply with Quote
quote:
Originally posted by GilaMonster

I've got someone over at SSC that's been whining for 2 days that he wants a script to move indexes. No signs of any work. I'd help, but each time he whines I get less motivated to go and do the search for him. (link later if you want)

--
Gail Shaw
SQL Server MVP




I saw that. Wants to move 10,000 tables to a new filegroup, but doesn't want to do any work.



CODO ERGO SUM
Go to Top of Page

robvolk
Most Valuable Yak

USA
15658 Posts

Posted - 07/19/2011 :  17:18:01  Show Profile  Visit robvolk's Homepage  Reply with Quote
This one?

http://www.sqlservercentral.com/Forums/Topic1143225-391-1.aspx
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 07/19/2011 :  17:52:59  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
Yeah, that's the one. Maybe I'll find 5 minutes tomorrow. Maybe not.

--
Gail Shaw
SQL Server MVP
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
5072 Posts

Posted - 07/19/2011 :  17:54:39  Show Profile  Visit russell's Homepage  Reply with Quote
Would at least like to see the guy demonstrate SOME effort before I spent the 5 minutes
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 07/19/2011 :  18:01:11  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
Ice, hell, pigs, fly...

--
Gail Shaw
SQL Server MVP
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
5072 Posts

Posted - 07/19/2011 :  18:01:59  Show Profile  Visit russell's Homepage  Reply with Quote
LOL Gail.
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

United Kingdom
3608 Posts

Posted - 07/20/2011 :  04:30:38  Show Profile  Reply with Quote
I can't believe someone gave in and gave him a script. Then again, the OP won't understand it anyway, so this should be fun. Next question, "can someone explain this script to me"..
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 07/20/2011 :  09:14:36  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
Not a very good script, not even a acceptable one. Joining to sys.indexes 22 times with a triangular join. Ugly.

Not going to say anything. same person who contributed that posted on a whole bunch of other threads, a few posts authoritatively wrong

--
Gail Shaw
SQL Server MVP
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 07/20/2011 :  09:37:16  Show Profile  Reply with Quote
quote:
Originally posted by GilaMonster

Not a very good script, not even a acceptable one. Joining to sys.indexes 22 times with a triangular join. Ugly.

Not going to say anything. same person who contributed that posted on a whole bunch of other threads, a few posts authoritatively wrong

--
Gail Shaw
SQL Server MVP



I don't know when he came up with the 22 column composite index; the limit on indexes is 16 columns.

From SQL Server 2008 Books Online
"
SQL Server 2008 Books Online (August 2008)

CREATE INDEX (Transact-SQL)
...
Up to 16 columns can be combined into a single composite index key. All the columns in a composite index key must be in the same table or view. The maximum allowable size of the combined index values is 900 bytes..."


Edit:
Maybe he meant an index with included columns. If that is the case, I think the limit is much higher.




CODO ERGO SUM

Edited by - Michael Valentine Jones on 07/20/2011 09:39:56
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 07/20/2011 :  09:51:17  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
I suspect it's include. The limit's the same as columns in a table I believe, huge. I have some indexes with 30+ include columns.

Personally I'd just use a subquery with the XML string concatenation trick to get the key and include columns, the rest is really trivial

--
Gail Shaw
SQL Server MVP
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
5072 Posts

Posted - 08/12/2011 :  00:12:48  Show Profile  Visit russell's Homepage  Reply with Quote
Honest question: How long do you intend to let Celko be an ass to people?

He offers nothing. He gives bad advice. He offends people. He scares off newbies. And he's a dick.

It would almost be ok if he was right 50% of the time, but he isn't.

He is an embarrassment to this fine community.

Edited by - russell on 08/12/2011 00:14:59
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 08/12/2011 :  04:32:00  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
He's an embarrassment on all forums

--
Gail Shaw
SQL Server MVP
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36661 Posts

Posted - 08/14/2011 :  15:59:47  Show Profile  Visit tkizer's Homepage  Reply with Quote
Joe's account has now been locked. Email was sent to him to let him know why. If he agrees to behave, then his account may get unlocked. We shall see.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 08/15/2011 :  01:48:55  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
Doesn't seem to have had any effect: http://www.sqlteam.com/forums/pop_profile.asp?mode=display&id=62138

--
Gail Shaw
SQL Server MVP
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36661 Posts

Posted - 08/15/2011 :  11:21:08  Show Profile  Visit tkizer's Homepage  Reply with Quote
Grrr, yeah that one came under his other account. Both are now locked.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

DonAtWork
Flowing Fount of Yak Knowledge

2161 Posts

Posted - 08/17/2011 :  09:10:01  Show Profile  Reply with Quote
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=163971

The problem is, i agree with Joe on this one. (Except for NEVER use a cursor.)
However, this being a helpful site, i do not post such things. I just yell at my monitor instead.

http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
How to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

For ultra basic questions, follow these links.
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp
Go to Top of Page
Page: of 88 Previous Topic Topic Next Topic  
Previous Page | Next 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.2 seconds. Powered By: Snitz Forums 2000