The app gets a permission error while it works for you as a sysadmin. Here is how a db_executor role fixes it without opening everything.
SQL SERVER – Using “High Performance” Power Plan for SQL Server
A simple, often missed setting on a new server: switch Windows to the High Performance Power Plan. Here is why it matters for SQL Server and where to set it.
Interview Question of the Week #017 – Performance Comparison of Union vs Union All
Compare UNION vs UNION ALL with duplicate examples, compatible types, actual plans, and the extra work required for distinct rows.
SQL SERVER – Generate Different Random Number for Each Group Using RAND() Function
The RAND() function returns the same value for every row in a query. Here is a simple trick to generate a different random number for each group.
SQL SERVER – Different Methods to Know Parameters of Stored Procedure
Need to know parameters of stored procedure code quickly? Here are two methods, including sp_help, that list each parameter with its type and order.
SQL Server – Error While Enabling CDC on a Table – The specified ‘@server’ is invalid (valid values are returned by sp_helpserver)
A reader got an error while enabling CDC on a table: The specified ‘@server’ is invalid. Here is what the message means and what caused it for him.
Hey DBA – Watch Your Vendors! Hey Vendors – Try a Little Harder! – Notes from the Field #077
Notes from the Field #077: Mike Walsh asks every DBA to watch their vendors, and asks vendors to try a little harder. Lessons for both sides.