Holy Cow! - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Site Related Forums

The Yak Corral

Holy Cow!

Author

Topic

Kristen
Test

22859 Posts

Posted - 2007-09-29 : 04:49:57

The big man has graced us with his presence.

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

Kristen
Test

22859 Posts

Posted - 2007-09-29 : 04:51:02

Indeed, a number of threads:

http://www.sqlteam.com/forums/pop_profile.asp?mode=display&id=2411

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-09-29 : 05:01:11

and some even post such comment http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=89902#337350

KH
[spoiler]Time is always against us[/spoiler]

Kristen
Test

22859 Posts

Posted - 2007-09-29 : 05:09:27

Yeah, well I think he may have had a few extra in this thread

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

unless he's taking the Micky telling Madhi to format in the front end!!!!!!!!!!!!

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-10-03 : 02:21:51

Welcome Celko. Nice to see you here after a long time

Madhivanan

Failing to plan is Planning to fail

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-10-03 : 02:40:45

if we got fabian here we could probably host a pay-per-view event..

-ec

Kristen
Test

22859 Posts

Posted - 2007-10-03 : 05:05:49

"we could probably host a pay-per-view event"

Might have more luck with Jenna Jameson

pootle_flump

1064 Posts

Posted - 2007-10-03 : 07:23:44

Cool - I've just posted in a Celko thread. I hope he smacks me down good and proper - anything less would be a real letdown.

Kristen
Test

22859 Posts

Posted - 2007-10-03 : 07:45:54

I think he's hibernating again, already ...

... he's never going to make Kristen's List at this rate

Kristen
Test

22859 Posts

Posted - 2007-10-03 : 07:46:54

I think he's hibernating again, already ...

... he's never going to make Kristen's List at this rate

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-10-03 : 07:56:42

I still didn't get the purpose behind the name of this thread!

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

pootle_flump

1064 Posts

Posted - 2007-10-03 : 07:58:15

Lol - it is an English exclamation of disbelief - "Holy cow - did you see that!". Not sure if the Yankees use it too.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-10-03 : 07:58:29

Joe Celko is considered "the" guru on SQL Server.
His presence on SQLTeam forum impresses.

E 12°55'05.25"
N 56°04'39.16"

pootle_flump

1064 Posts

Posted - 2007-10-03 : 07:59:30

quote:
Originally posted by Peso

Joe Celko is considered "the" guru on SQL ~~Server~~.
His presence on SQLTeam forum impresses.

I think it is more like that

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-10-03 : 08:01:54

Oh I see. Thanks pootle_flump!

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

Kristen
Test

22859 Posts

Posted - 2007-10-03 : 08:13:37

He wrote "SQL for Smarties". Neat title ...

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2007-10-03 : 09:25:17

Joe has been around for ages.

Damian
"A foolish consistency is the hobgoblin of little minds." - Emerson

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2007-10-03 : 10:22:47

Celko has just the right combination of genuine knowledge and pompous arrogance that gives any thread he posts on the potential to become a spectacular flame-war.

He’s always entertaining, even when you’re the target. I remember clashing with him many years ago on the old CompuServe SQL Server forum. I dared to post a solution that I said would probably run faster than the solution he posted, and he flamed me for using a SQL Server specific solution instead of generic SQL. I pointed out that we were on a SQL Server forum, not a generic SQL forum, and he didn’t really take that well…

CODO ERGO SUM

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-10-03 : 10:25:59

He wasn't to keen on me either when I posted a solution which included an ORDER BY, which apparently is an CURSOR operation (which was forbidden).
After that, he didn't reply to my other solutions.

E 12°55'05.25"
N 56°04'39.16"

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-10-03 : 10:25:59

that kind of ANSI militancy reminds me of Merkin's sig.

elsasoft.org

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-10-03 : 10:51:26

Joe, if you read this, this is a new solution to the "Scheduling printer" problem on page 29 in your "Puzzles and Answers Second Edition" book.

-- Prepare sample data
DECLARE	@PrinterControl TABLE
	(
		UserID VARCHAR(10),
		PrinterName VARCHAR(4) PRIMARY KEY,
		PrinterDescription VARCHAR(40)
	)

INSERT	@PrinterControl
SELECT	'chacha', 'LPT1', 'First floor''s printer' UNION ALL
SELECT	'lee', 'LPT2', 'Second floor''s printer' UNION ALL
SELECT	'thomas', 'LPT3', 'Third floor''s printer' UNION ALL
SELECT	NULL, 'LPT4', 'Common printer for new user' UNION ALL
SELECT	NULL, 'LPT5', 'Common printer for new user'

-- Initialize search parameters
DECLARE	@UserID VARCHAR(10)

SET	@UserID = 'Celko'

-- Show the expected output with load balancing
SELECT	PrinterName
FROM	(
	SELECT	PrinterName,
		SUBSTRING('abcdefghijklmnopqrstuvwxyz',
		1 + Sequence * 26 / Total, 26 / Total) AS Names
	FROM	(
		SELECT	pc1.PrinterName,
			(
			SELECT COUNT(*) FROM @PrinterControl AS pc2
			WHERE COALESCE(pc2.UserID, @UserID) = @UserID
			AND pc2.PrinterName < pc1.PrinterName
			) AS Sequence,
			(
			SELECT COUNT(*) FROM @PrinterControl AS pc3
			WHERE COALESCE(pc3.UserID, @UserID) = @UserID
			) AS Total
		FROM	@PrinterControl AS pc1
		WHERE	COALESCE(pc1.UserID, @UserID) = @UserID
		) AS d
	) AS d
WHERE	CHARINDEX(LEFT(@UserID, 1), Names) > 0

-- Show the expected output without load balancing
SELECT	TOP 1
	PrinterName
FROM	@PrinterControl
WHERE	COALESCE(UserID, @UserID) = @UserID

E 12°55'05.25"
N 56°04'39.16"

Next Page

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources