June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check

SQL SERVER – SQL Query Techniques For Microsoft SQL Server 2008 – Book Available for SQL Server Certification

August 22, 2011
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Joes 2 Pros, SQL Scripts
We recently give away 7 physical books of Joes 2 Pros Book Volume 2. The response to following questions was overwhelming and was excellent. The book is available to purchase now in India and USA. This is great news as I often get request that where one can learn SQL…
Read More

SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – All about SQL Statistics – Day 21 of 35

August 21, 2011
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Joes 2 Pros, SQL Scripts
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. Real Life Statistics We are not surprised to see warm ski…
Read More

SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Introduction to Page Split – Day 20 of 35

August 20, 2011
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Joes 2 Pros, SQL Scripts
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. From yesterdays post we learned that the clustered index is the…
Read More

SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – The Clustered Index – Simple Understanding – Day 19 of 35

August 19, 2011
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Joes 2 Pros, SQL Scripts
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. Since the physical storage of data impacts the speed and efficiency…
Read More

SQL SERVER – Geography Data Type – Calculating Distance Between Two Points on the Earth – Day 18 of 35

August 18, 2011
Pinal Dave
SQL Tips and Tricks
Geography Data Type, Joes 2 Pros, SQL Scripts, SQL Server

In this blog post we will learn about Geography Data Type.

Read More

SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Sparse Data and Space Used by Sparse Data – Day 17 of 35

August 17, 2011
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Joes 2 Pros, SQL Scripts
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. Sparse Data Fields with fixed length data types (e.g., int, money)…
Read More

SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – System and Time Data Types – Day 16 of 35

August 16, 2011
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Joes 2 Pros, SQL Scripts
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. System and Time Data Types Keeping track of date and time…
Read More
Previous 1 … 9 10 11 12 13 14 15 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2025 All rights reserved. pinal @ SQLAuthority.com

Go to mobile version