Being day eight of the DBCC Command month at SteveStedman.com, today’s featured DBCC Command is DBCC CLEANTABLE. Many times I have worked on a database that has evolved over 10 or more years of changes from different developers and DBAs. One of the signs I see in databases like this is the waste associated with obsolete columns. For instance someone …
Being day seven of the DBCC Command month at SteveStedman.com, today’s featured DBCC Command is DBCC CHECKTABLE. Description: DBCC CheckTable is used to check the structure of a table to verify the integrity of every data page associated with that table, and all of the indexes associated with that table. If you have used DBCC CheckDB, and a problem has …
Being day four of the DBCC Command month at SteveStedman.com, today’s featured DBCC Command is DBCC CHECKDB. For more info on DBCC see the Database Corruption Challenge. DBCC CheckDB Description: DBCC CHECKDB is used to check the physical integrity of the entire database. DBCC CHECKDB is used to detect corruption in the database, and should be run regularly. This is …
Being day two of DBCC Command month at SteveStedman.com, today’s featured DBCC Command is DBCC CHECKCATALOG. Description: DBCC CheckCatalog checks the catalog integrity for a given database. DBCC CheckCatalog is less intensive than DBCC CheckDB, as CheckCatalog checks that every data type in syscolumns has a matching entry in systypes and that every table and view in sysobjects has at …
Being day one of DBBC Command month at SteveStedman.com, today’s featured DBCC Command is DBCC CHECKALLOC. Description: DBCC CheckAlloc checks and can repair disk space allocation structures for a database. DBCC CheckAlloc checks the allocation for all pages in the database compared to their internal structures representing those pages. When you run DBCC CheckDB it internally runs the equivalent of DBCC …
I am available to speak at your event and bring extensive SQL Server expertise to your audience, with content that spans the breadth of SQL Server functionality and performance. My presentations are tailored to meet the needs of your attendees, whether they are beginners, advanced users, or somewhere in between. In addition to popular SQL Server topics like SSRS, performance …
You can download my resume as a PDF. SteveStedmanResume.PDF The the most up to date work information visit my Linked In Profile: http://www.linkedin.com/in/stevestedman Background For 30+ years I have been working in the software development and database areas. I first started with databases using Microsoft SQL Server in 1990, SQL Server version 1.0 The last several years I have been exclusively …
Whether you are a smaller SQL shop that doesn’t need a full time DBA, or a large shop that needs help in a specific area, the Remote DBA services that we provide are available to help you out. And offer all other SQL Server services CHECK IT OUT! With Remote DBA services, the team at Stedman Solutions is available for …
Take a look at the Database Corruption Challenge The SQL Server Health reports has been replaced with the Database Health Application. Please visit http://DatabaseHealth.com for more details. The free SQL Server Health report evaluates a number of areas of your database, and provides details on problems and what can be done to fix them. One …
Steve Stedman Bio I have been using SQL Server for over 34 years, and I have realized that out of all of the jobs that I have had, and the projects that I have worked on, the ones that I enjoy the most include SQL Server and good people. I run Stedman Solutions, LLC a SQL Server consulting firm specializing …