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

Oct29

Just a day ago, I received question in email regarding my article SQL SERVER – 2005 Disable Triggers – Drop Triggers. Question : How to disable all the triggers for database? Additionally, how to disable all the triggers for all servers? Answer: Disable all the triggers for a single database:…

Oct28

SQL SERVER – 2008 – Server Consolidation WhitePaper Download

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Download, SQL White Papers

Server Consolidation with SQL Server 2008 Writer: Martin Ellis Reviewer: Prem Mehra,Lindsey Allen, Tiffany Wissner, Sambit Samal Published: March 2009 Microsoft SQL Server 2008 supports multiple options for server consolidation, which provides organizations with the flexibility to choose the consolidation approach that best meets their requirements to centralize data services…

Oct27

SQL SERVER – 2005 – Get Current User – Get Logged In User

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts, SQL Server Security, SQL System Table

Interesting enough Jr. DBA asked me how he can get current user for any particular query is ran. He said he wants it for debugging purpose as well for security purpose. I totally understand the need of this request. Knowing the current user can be extremely helpful in terms of…

Oct26

SQL SERVER – Deterministic Functions and Nondeterministic Functions

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function

Deterministic functions always returns the same output result all the time it is executed for same input values. i.e. ABS, DATEDIFF, ISNULL etc. Nondeterministic functions may return different results each time they are executed. i.e. NEWID, RAND, @@CPU_BUSY etc. Functions that call extended stored procedures are nondeterministic. User-defined functions that…

Oct25

SQL SERVER – 2005 – Forced Parameterization and Simple Parameterization – T-SQL and SSMS

Pinal Dave

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

SQL Scripts, SQL Server Management Studio

SQL Server compiles query and saves the procedures cache plans in the database. When the same query is called it uses compiled execution plan which improves the performance by saving compilation time. Queries which are parametrized requires less recompilation and dynamically built queries needs compilations and recompilation very frequently. Forced…

Oct24

SQL SERVER – Simple Example of WHILE Loop With CONTINUE and BREAK Keywords

Pinal Dave

SQL Tips and Tricks

SQL Cursor, SQL Function, SQL Scripts, SQL Server

182

I have tried to explain the usage of simple WHILE loop in the first example. BREAK keywords will exit the stop the while loop and control is moved.

Oct23

SQL SERVER – Get Permissions of My Username / Userlogin on Server / Database

Pinal Dave

SQL

SQL Function, SQL Scripts, SQL Server Security, SQL Stored Procedure, SQL System Table

A few days ago, I was invited to one of the largest database company. I was asked to review database schema and propose changes to it. There was special username or user logic was created for me, so I can review their database. I was very much interested to know what kind of permissions I was assigned per server level and database level. I did not feel like asking their Sr. DBA the question about permissions.

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

SQL SERVER – Disable All Triggers on a Database – Disable All Triggers on All Servers

SQL SERVER – 2008 – Server Consolidation WhitePaper Download

SQL SERVER – 2005 – Get Current User – Get Logged In User

SQL SERVER – Deterministic Functions and Nondeterministic Functions

SQL SERVER – 2005 – Forced Parameterization and Simple Parameterization – T-SQL and SSMS

SQL SERVER – Simple Example of WHILE Loop With CONTINUE and BREAK Keywords

SQL SERVER – Get Permissions of My Username / Userlogin on Server / Database

SQL SERVER – Table Variables, Temp Tables and Parallel Queries

Avoid Join Hints – SQL in Sixty Seconds #172

SQL SERVER – Unlocking User Without Changing Password

Optimize for Ad Hoc Workloads – SQL in Sixty Seconds #173

SQL SERVER – Index Scans are Not Always Bad

Index Scans – Good or Bad? – SQL in Sixty Seconds #174

SQL SERVER – COUNT(*) and Index Used