Finding User Created Statistics. Every so often we hear from a customer who gets a variation of this message when trying to upgrade their database to a newer version of our application: Msg 5074, Level 16, State 1, Line 1 The statistics ‘my_stats’ is dependent on column ‘column1′.
Msg 4922, Level 16, State 9, Line 1 ALTER TABLE ALTER COLUMN name failed because one or more objects access this column. The issue is that the customer has created statistics manually on a column we are trying to alter as part of the upgrade process. Locking in SQL Server. Alexander Chigrikchigrik@mssqlcity.com IntroductionTransaction Isolation LevelsLock typesLocking optimizer hintsDeadlocksView locks (sp_lock)Literature Introduction In this article, I want to tell you about SQL Server 7.0/2000 Transaction Isolation Levels, what kinds of Transaction Isolation Levels exist, and how you can set the appropriate Transaction Isolation Level, about Lock types and Locking optimizer hints, about deadlocks, and about how you can view locks by using the sp_lock stored procedure.
Transaction Isolation Levels. An Introduction to Fillfactor in SQL ServerBrent Ozar Unlimited® Are you a page half full, or a page half empty kind of person?
I’ll never think “I’ve seen it all” when it comes to SQL Server– there’s just always someone waiting around the corner who’s found a weird new thing to do with it. But there are some things I really wish I could stop finding. One of those things I hate finding is bad fillfactor settings.
SQL Server Database Growth and Autogrowth Settings. It's easy to create a database nowadays with point-'n-click, but if you've left your database's autogrowth settings at their default, you may hit problems in the future.
Why? What do I do about it? Read on! There are a lot of maintenance jobs that SQL Server performs under the covers. Whilst this makes SQL Server an easier database management system to administer with very little training, it has the consequence that the industry has many accidental DBAs who are managing SQL Server without really knowing what the database engine does behind the scene to keep their databases up and running. SQL Server Index and Statistics Maintenance. IndexOptimize is the SQL Server Maintenance Solution’s stored procedure for rebuilding and reorganizing indexes and updating statistics.
IndexOptimize is supported on SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, and SQL Server 2014. Download Download MaintenanceSolution.sql.
Business Intelligence. SQL Server Virtual Labs. TSQL. SSIS. SSRS. DBA.