Admin Course - 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

Admin Course

Author

Topic

Pace
Constraint Violating Yak Guru

264 Posts

Posted - 2004-09-07 : 09:57:01

Im on it at the minute and its the best thing since sliced bread... useless I know but it is the Yak Corral

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2004-09-07 : 09:59:53

so what r u learning?

Go with the flow & have fun! Else fight the flow

ditch
Master Smack Fu Yak Hacker

1466 Posts

Posted - 2004-09-07 : 10:02:34

I'll be on a Golf Course this weekend

Duane.

Pace
Constraint Violating Yak Guru

264 Posts

Posted - 2004-09-08 : 06:50:36

well I did the MS course; Querying using T-SQL and now im doin the Administering course...

Id rather be on the track then a golf course

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2004-09-08 : 07:11:54

I seem to recall..
Isn't this the standard question for anyone doing the T-SQL course:


create table #t( nr int )
insert #t select 1 union select 2 union
select 5 union select 7 union select 8 union select 9

select nr from #t -- they taught this I bet

select ... from ...#t... -- did they teach you this ?
nr          nr          
----------- ----------- 
9           1
8           2
7           5
5           7
2           8
1           9

Welcome pace!
/rockmoose

SamC
White Water Yakist

3467 Posts

Posted - 2004-09-08 : 10:20:12

What Admin Course is this?

Pace
Constraint Violating Yak Guru

264 Posts

Posted - 2004-09-09 : 05:34:54

Rockmoose I never got that Q

how strange...

SAM C; its the microsoft Administering A SQL Server 2000 Database....

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2004-09-09 : 06:05:10

quote:
Originally posted by Pace

Rockmoose I never got that Q

how strange...

SAM C; its the microsoft Administering A SQL Server 2000 Database....

The thing is to write a sql clause to retrieve two columns with the values from the table, one column ascending, the other column descending. A bit tricky.

rockmoose
/* Chaos is the nature of things...Order is a lesser state of chaos */

SamC
White Water Yakist

3467 Posts

Posted - 2004-09-09 : 08:19:20

It's a 5 day class. I wish I could take 2 straight days for training !

Pace
Constraint Violating Yak Guru

264 Posts

Posted - 2004-09-15 : 07:18:36

ive done a few now on SQL... luckily my MD is the best possible who just lets me have whatever is needed to get the job done right... Im plaaning to practice and implement what I have learned before blagging some VS.net courses

ditch
Master Smack Fu Yak Hacker

1466 Posts

Posted - 2004-09-15 : 07:31:50

If my MD was like yours then I'd explain to him how important it is for SQL developers performance to play at least 3 rounds of golf a week (during working hours of course).

Duane.

Pat Phelan
Posting Yak Master

187 Posts

Posted - 2004-09-15 : 14:23:34