Blog Home Page - Page 723 of 829 - SQL Authority with Pinal Dave

Oct22

SQLAuthority News – Running SQL Server 2008 in a Hyper-V Environment Best Practices and Performance Considerations

SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQLAuthority News

Best Practices, Database, SQL Download, SQL White Papers

Hyper-V in Windows Server 2008 is a powerful virtualization technology that can be used by corporate IT to consolidate under-utilized servers, lowering TCO and maintaining or improving Quality of Service. Through a series of test scenarios that are representative of SQL Server application fundamentals, this document provides best practice recommendations…

Oct21

SQL SERVER – Fix : Error : Incorrect syntax near. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel

Pinal Dave

SQL Tips and Tricks

SQL Error Messages, SQL Scripts, SQL Server, SQL Server Security, SQL Stored Procedure

I have seen developers confused many times when they receive the following error message. Incorrect syntax near. Let us learn.

Oct20

SQL SERVER – Transaction and Local Variables – Swap Variables – Update All At Once Concept

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Server, SQL Server Security, SQL Transactions

This article is inspired from two sources. Let us learn today about how to swap variables by updating everything at once concepts.

1) My year old article – SQL SERVER – Effect of TRANSACTION on Local Variable – After ROLLBACK and After COMMIT
2) Discussion with SQL Server MVP – Jacob Sebastian – SQLAuthority News – Author Visit – SQL Hour at Patni Computer Systems

I usually summarize my article at the end, but this time let me summarize first and we will understand the article next.

Oct19

SQL SERVER – Introduction to CLR – Simple Example of CLR Stored Procedure

Pinal Dave

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

CLR, Software Development, SQL Scripts, SQL Stored Procedure, SQL Utility

CLR is abbreviation of Common Language Runtime. In SQL Server 2005 and later version of it database objects can be created which are created in CLR. Stored Procedures, Functions, Triggers can be coded in CLR. CLR is faster than T-SQL in many cases. CLR is mainly used to accomplish task…

Oct18

SQL SERVER – Retrieve – Select Only Date Part From DateTime – Best Practice – Part 2

Pinal Dave

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

Best Practices, SQL DateTime, SQL Function, SQL Scripts

A year ago I wrote post about SQL SERVER – Retrieve – Select Only Date Part From DateTime – Best Practice where I have discussed two different methods of getting datepart from datetime. Method 1: SELECT DATEADD(D, 0, DATEDIFF(D, 0, GETDATE())) Method 2: SELECT CONVERT(VARCHAR(10),GETDATE(),111) I have summarized my post…

Oct17

SQL SERVER – Get Common Records From Two Tables Without Using Join

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Joins, SQL Scripts

I really enjoy answering questions which I receive from either comments or Email. My passion is shared by SQL Server Expert Imran Mohammed. He frequently SQL community members by answering their questions frequently and promptly. Sachin Asked: Following is my scenario, Suppose Table 1 and Table 2 has same column…

Oct17

SQLAuthority News – Ahmedabad SQL Server User Group Meeting – October 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

MVP, SQL User Group, SQLAuthority Author Visit

No Comments

Tomorrow is third Saturday of the Month and every third Saturday we have Ahmedabad User Group Meeting. Our user group is growing and getting interesting. Everybody who attended last months User Group (UG) Meeting realized that how important it is to attend UG meetings. UG President Jacob Sebastian (SQL Server…

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 22 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 14 SQL Server database books and 100 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Pinal is an experienced and dedicated professional with a deep commitment to flawless customer service. If you need help with any SQL Server Performance Tuning Issues, please feel free to reach out at pinal@sqlauthority.com.

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).

Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.

Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.

Once you learn my business secrets, you will fix the majority of problems in the future.

Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.

Essentially I share my business secrets to optimize SQL Server performance.

Feb 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

SQLAuthority News – Running SQL Server 2008 in a Hyper-V Environment Best Practices and Performance Considerations

SQL SERVER – Fix : Error : Incorrect syntax near. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel

SQL SERVER – Transaction and Local Variables – Swap Variables – Update All At Once Concept

SQL SERVER – Introduction to CLR – Simple Example of CLR Stored Procedure

SQL SERVER – Retrieve – Select Only Date Part From DateTime – Best Practice – Part 2

SQL SERVER – Get Common Records From Two Tables Without Using Join

SQLAuthority News – Ahmedabad SQL Server User Group Meeting – October 2008

SQL SERVER – LogonUserExEx Fails for User & GetToken – Logging on as the CNO Failed With Error 1326

SQL SERVER – Why Server Authentication is Disabled? What Mode is SQL Server Using Currently?

SQL SERVER – Msg 1842 – The File Size, Max Size Cannot be Greater Than 2147483647 in Units of a Page Size

COVID-19, Working From Home and Performance Tuning

SQL SERVER – Free Performance Tuning Videos

What is the Difference Between sql_handle and plan_handle?- Interview Question of the Week #269

SQL SERVER – Error 9002: The Transaction Log for Database ‘SQLAuthority’ is Full Due to ‘REPLICATION’