Posts Tagged ‘sql server’
September 12, 2009 - 12:16 am
Adam Machanic interviews Joe Celko at the 2006 PASS Summit where Joe recalls an old trick that was used before the CASE statement was added to the SQL language.
Duration : 0:0:48
(more…)
Tags: Adam Machanic, boyce, database, Itzik, Joe Celko, kalen, Microsoft, PASS Summit, solid quality, sql server, t-sql, TechEd Posted in sql statement |
August 31, 2009 - 6:16 am
I declare Code Sin #1: poorly formatted code. Look, the video’s uner 90 seconds long…watch it. Your successors, your coworkers — your CHILDREN, will thank you.
Duration : 0:1:26
(more…)
Tags: (TSQL), by, code, coding, cool new features, formatting, free, free training, free training videos, free videos, from, group, having, help, IT videos, Jen McCown, Jennifer McCown, katmai, Microsoft tutorial, Midnight DBA, MidnightDBA, order, parse, query, Sean McCown, select, sql, sql server, SQL Server 2008, SQL Server MVP, SSMS, statement, t-sql, Tips, tips and tricks, where, Windows 7 Posted in select statement |
August 22, 2009 - 5:14 am
How does SQL see a SELECT statement? Which part gets evaluated first? Why should I care? Find out here, find out fast!
1 - From
2 - Where
3 - Group by
4 - Having
5 - Select
6 - Order by
Duration : 0:2:5
(more…)
Tags: (TSQL), by, cool new features, free, free training, free training videos, free videos, from, group, having, help, insert, insert into, IT videos, Jen McCown, Jennifer McCown, katmai, Microsoft tutorial, Midnight DBA, MidnightDBA, order, parse, query, Sean McCown, select, select into, sql, sql server, SQL Server 2008, SQL Server help, SQL Server MVP, SSMS, statement, t-sql, Tips, tips and tricks, where, Windows 7 Posted in select statement |