As a DBA, you probably use the OBJECT_NAME() function quite a bit. I know I do. If you aren’t familiar with it, you can read the documentation if you want, but it’s a pretty straightforward function that converts object IDs into object names. I ran … [Read More]
Question How many transactions per second can SQL Server table triggers handle? If I had a highly transactional table that was inserted into 1,000 times a second, are insert triggers on that table reliable to fire every single time? asked 2019-12-21 by J.D. Answer are … [Read More]
Microsoft docs defines the dbcreator role as: Members of the dbcreator fixed server role can create, alter, drop, and restore any database. But what specific permissions are actually included in that role? If we scroll down in the docs just a little, we’ll see a … [Read More]
As a DBA or SQL Developer, you’ve surely encountered a scenario where something worked for you, but not for another user. DBAs usually are part of the sysadmin role, or have a collection of powerful permissions. If I run code as myself, I will never … [Read More]
If you’re working with compressed indexes, SQL Server provides a system stored procedure to help test the space savings of implementing data compression: sp_estimate_data_compression_savings. Starting in SQL Server 2019, it can even be used to estimate savings with columnstore. I really don’t like sp_estimate_data_compression_savings. In … [Read More]
Question I have a stored proc spGetSites that returns three columns for SiteName, SiteId and UnitCount. The stored proc runs perfectly fine. I’m trying to store the results of the stored proc to a temp table @Site to use for my report with below syntax. … [Read More]
Changing a column from int to bigint has gotten a lot easier since I started working on SQL Server back at the turn of the century. SQL Server 2016 introduced the ability to do ALTER TABLE…ALTER COLUMN as an online operation using the WITH (ONLINE=ON) … [Read More]
Copyright © 2024 | Andy Mallon | am2.co