(Larry Leonard) This code is for CMS (Central Management Servers), and displays all the databases on all the servers that don’t have a specified table.
Tag: sql server
SQL Server Index Report with Included Columns, Storage and more for all Tables in a Database
(Percy Reyes) I am sure sometimes as SQL Server DBAs and Developers we would like to report on more detailed information about indexes on a table. One of the primary means to find the information is sp_helpindex which is a system stored procedure to check index summary information.
SQL SERVER – What is Filtered Statistics?
(Pinal Dave) Continuous learning is the only way to keep myself up-to-date with SQL Server product features. While I was working for a demo to show usage of SQL Server Statistics, I came across feature called Filter Statistics which was introduced in SQL Server 2008.
Extracting API Data Using PowerShell and Loading into SQL Server
(Tim Smith) We’d like to minimize using third party tools to extract data from APIs to load into SQL Server and wanted to know if we could implement solutions with PowerShell without too much overhead.
How to Write Queries – Understand your Database Table’s Meanings and Relationships – Step 1
(Kris Wenzel) This is the second of four articles in a series explaining the three simple steps I take to writing complex SQL statements. The series starts with this introductory article.
Remotely shutting down an instance
(Kenneth Fisher) T-SQL TuesdayThis month for T-SQL Tuesday Mike Donnelly (b/t) decided to pick a topic to fit in with Ed Leighton-Dick’s (b/t) #SQLNewBlogger challenge. His highly open ended topic is to learn something new and blog about it.
Run DBCC UPDATEUSAGE on All Databases in an Instance
(Larry Leonard) A few lines of code for those of us migrating SQL Server 2000 databases to a higher version of SQL Server and having CHECKDB fail because the counts are wrong. This simply runs DBCC UPDATEUSAGE on all the databases in the instance. I can’t say it any better than BOL:
SQL SERVER – Transaction Log Backup Failing After Rebuilding Database Log File
(Pinal Dave) Speaking at community events get me really energized. It is wonderful to connect with people who build some of the greatest code ever for their respective organizations. Last weekend, I was at a conference in Delhi and it was an awesome opportunity for me to meet a number of you.
How to restore Master database – SQL Server System Database?
(Rohit Garg) Steps to restore SQL Server Master Database :-
Getting Cluster Nodes through T-SQL
(Daniel Mellor) One of my most frustrating moments is when I need to log into the active node of a cluster. I inevitably choose a passive node first, then wind up opening the Failover Cluster Manager to find the active node then finally log in to the correct server.