June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

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…
Read More

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…
Read More

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…
Read More

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.

Read More