SQLRally and SQLRally - Session material

Posted by Hugo Kornelis on SQL Blog See other posts from SQL Blog or by Hugo Kornelis
Published on Sat, 09 Nov 2013 12:41:00 GMT Indexed on 2013/11/09 16:05 UTC
Read the original article Hit count: 428

Filed under:

Conference

|

OVER clause

|

People

|

Performance

|

SQL Server 2012

|

udf

|

Windowing extensions

I had a great week last week. First at SQLRally Nordic , in Stockholm, where I presented a session on how improvements to the OVER clause can help you simplify queries in SQL Server 2012 enormously. And then I continued straight on into SQLRally Amsterdam , where I delivered a session on the performance implications of using user-defined functions in T-SQL. I understand that both events will make my slides and demo code downloadable from their website, but this may take a while. So those who do not...(read more)

© SQL Blog or respective owner

Related posts about Conference

Conference Call Services - How to Find the Best Web Conference Call Hosting

as seen on Article City - Search for 'Article City'
The conferencing solutions including audio and web conference calling services have become the most popular communication tool used by businesses across the globe. These global collaboration services... [Author: Anshul Choudhary - Computers and Internet - March 27, 2010] >>> More
The Open Source Open Source Conference

as seen on Internet.com - Search for 'Internet.com'
Portland, OR open source advocates took the loss of OSCON in stride: They launched their own open source conference. How did it stack up against the heavyweight, top-down competition? >>> More
How to make possible on Asterisk meetme.conf

as seen on Server Fault - Search for 'Server Fault'
how can i configure in my Asterisk Server on meetme.conf Details :For conformance bridge extension : virtual Room 1 : Conference Call 567.xxx.xxxx Voice :Enter for conference dial 1 Voice : Enter your conference Pin then press pound my confrance ID: 10935 virtual Room 2 : Conference Call 567… >>> More
Microsoft Tech-Ed North America 2010 - SQL Server Upgrade, 2000 - 2005 - 2008: Notes and Best Practi

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
It is just a week to go for Tech-Ed North America 2010 in New Orleans, this time also I'm speaking at this conference on the subject - SQL Server Upgrade, 2000 - 2005 - 2008: Notes and Best Practices from the Field... more from here .. It is a coincedence that this is the 2nd time the same talk… >>> More
DevDays ‘00 The Netherlands day #1

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
First day of DevDays 2010, I was looking forward to DevDays to see all the new things like VS2010, .NET4.0, MVC2. The lineup for this year is again better than the year before, there are 100+ session of all kind of topics like Cloud, Database, Mobile, SharePoint, User experience, Visual Studio, Web… >>> More

Related posts about OVER clause

SQL join: where clause vs. on clause

as seen on Stack Overflow - Search for 'Stack Overflow'
After reading it, this is not a duplicate of Explicit vs Implicit SQL Joins. The answer may be related (or even the same) but the question is different. What is the difference and what should go in each? If I understand the theory correctly, the query optimizer should be able to use both interchangeably… >>> More
LINQ to XML : A query body must end with a select clause or a group clause

as seen on Stack Overflow - Search for 'Stack Overflow'
Can someone guide me on to repairing the error on this query : var objApps = from item in xDoc.Descendants("VHost") where(from x in item.Descendants("Application")) select new clsApplication { … >>> More
Difference b/w putting condition in JOIN clause versus WHERE clause

as seen on Stack Overflow - Search for 'Stack Overflow'
Suppose I have 3 tables. Sales Rep Rep Code First Name Last Name Phone Email Sales Team Orders Order Number Rep Code Customer Number Order Date Order Status Customer Customer Number Name Address Phone Number I want to get a detailed report of Sales for 2010. I would be doing a join. I… >>> More
Where clause in joins vs Where clause in Sub Query

as seen on Stack Overflow - Search for 'Stack Overflow'
DDL create table t ( id int Identity(1,1), nam varchar(100) ) create table t1 ( id int Identity(1,1), nam varchar(100) ) DML Insert into t( nam)values( 'a') Insert into t( nam)values( 'b') Insert into t( nam)values( 'c') Insert into t( nam)values( 'd') Insert into t( nam)values(… >>> More
SQL where clause to work with Group by clause after performing a count()

as seen on Stack Overflow - Search for 'Stack Overflow'
Tried my usual references at w3schools and google. No luck I'm trying to produce the following results. QTY is a derived column | Position | QTY -------------------- 1 Clerk 2 2 Mgr 2 Here's what I'm not having luck with: SELECT Position, Count(position) AS 'QTY' … >>> More