August « 2011 « SQL Server Journey with SQL Authority

Archive for August, 2011

SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Data Row Space Usage and NULL Storage – Day 15 of 35

Posted in Joes 2 Pros, Pinal Dave, PostADay, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology on August 15, 2011 | 58 Comments »

Answer simple quiz at the end of the blog post and – Every day one winner from India will get Joes 2 Pros Volume 3. Every day one winner from United States will get Joes 2 Pros Volume 3. Data Row Space Usage Most of a table’s space is occupied by its records. Indexes and [...]

Read Full Post »

SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Output Clause in Simple Examples – Day 14 of 35

Posted in Joes 2 Pros, Pinal Dave, PostADay, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology on August 14, 2011 | 59 Comments »

Answer simple quiz at the end of the blog post and – Every day one winner from India will get Joes 2 Pros Volume 2. Every day one winner from United States will get Joes 2 Pros Volume 2. Output We will first begin our work with the OUTPUT clause, by diving into hands-on examples of [...]

Read Full Post »

SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Ranking Functions – Advanced NTILE in Detail – Day 13 of 35

Posted in Joes 2 Pros, Pinal Dave, PostADay, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology on August 13, 2011 | 58 Comments »

Answer simple quiz at the end of the blog post and – Every day one winner from India will get Joes 2 Pros Volume 2. Every day one winner from United States will get Joes 2 Pros Volume 2. Ranking Functions Part 2 (NTILE) A friend of mine recently told me she’s very proud of [...]

Read Full Post »

SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Ranking Functions – RANK( ), DENSE_RANK( ), and ROW_NUMBER( ) – Day 12 of 35

Posted in Joes 2 Pros, Pinal Dave, PostADay, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology on August 12, 2011 | 102 Comments »

Answer simple quiz at the end of the blog post and – Every day one winner from India will get Joes 2 Pros Volume 2. Every day one winner from United States will get Joes 2 Pros Volume 2. Ranking Functions (Part 1) There are four ranking functions in SQL server. Today we will look [...]

Read Full Post »

SQL SERVER – SafePeak – The Plug and Play Immediate Acceleration Solution

Posted in PostADay, SQL, SQL Authority, SQL Performance, SQL Query, SQL Server, SQL Tips and Tricks, SQL Utility, SQLAuthority News, T SQL, Technology on August 11, 2011 | 19 Comments »

Introduction Given how important performance is these days among SQL Server critical applications, I was excited to look into a new product by SafePeak Technologies (www.SafePeak.com) that aims to immediately resolve, in a plug-and-play way, the performance, scalability and peaks challenges of SQL Server applications on the Cloud, hosting servers and enterprise data centers. While [...]

Read Full Post »

« Newer Posts - Older Posts »