SQL Tips and Tricks Archives - Page 282 of 536 - SQL Authority with Pinal Dave

SQL SERVER – Difference between Create Index – Drop Index – Rebuild Index – Quiz – Puzzle – 21 of 31

January 22, 2012

SQL, SQL Interview Questions and Answers, SQL Puzzle, SQL Server, SQL Tips and Tricks

Click here to get free chapters (PDF) in the mailbox Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There…

SQL SERVER – MERGE or INSERT, UPDATE, DELETE – Quiz – Puzzle – 19 of 31

January 20, 2012

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Puzzle, SQL Server, SQL Tips and Tricks

Click here to get free chapters (PDF) in the mailbox Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There…

SQL SERVER – Importance of Resource Database – Quiz – Puzzle – 18 of 31

January 19, 2012

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Puzzle, SQL Server, SQL Tips and Tricks

Click here to get free chapters (PDF) in the mailbox Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There…

SQL SERVER – Various Ways to Create Constraints – Quiz – Puzzle – 17 of 31

January 18, 2012

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Puzzle, SQL Server, SQL Tips and Tricks

Click here to get free chapters (PDF) in the mailbox Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There…

SQL SERVER – CHECKPOINT Behavior and Database Recovery Models – Quiz – Puzzle – 16 of 31

January 17, 2012

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Puzzle, SQL Server, SQL Tips and Tricks

Click here to get free chapters (PDF) in the mailbox Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There…

SQL SERVER – Difference between CHAR, VARCHAR, NVARCHAR and VARCHAR(MAX) – Quiz – Puzzle – 15 of 31

January 16, 2012

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Puzzle, SQL Server, SQL Tips and Tricks

Click here to get free chapters (PDF) in the mailbox Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There…

SQL SERVER – Using SafePeak to Accelerate Performance of 3rd Party Applications

January 16, 2012

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

An exciting solution I found last year (2011) for SQL Server performance acceleration is SafePeak. Designed to specifically to accelerate and tune performance of cases where you have minimum control on the applications, like 3rd party line of business applications. SafePeak performs automated caching of queries and procedures results, returning…