-
Personal Links
Verified Services
-
DZone MVB
-
Microsoft
Category Archives: Uncategorized
Multi-server Script to Find Orphaned Data Files using PowerShell
In this article, we take the sledgehammer approach in searching for MDFs and then comparing them against files which are available on the listed drive. The idea behind this is to generate a report of detached database files across multiple … Continue reading
Top string functions in SQL Server 2017
SQL Server 2017 has been in the talk for its many features that simplify a developer’s life. With the previous versions, developers had to write T-SQL, or user-defined functions using temporary tables, and build complex logic, just for string manipulation. … Continue reading
SQL: Different ways to generate sequence
There was a question from the op regarding adding a new column to a query output by generating the cyclic sequence numbers from 1 to 3. Select A =identity(int,1,1),B,C from table_abs 1,A,41 2,B,13 3,C,90 4,D,91 5,E,98 6,F,12 7,G,54 8,H,16 For … Continue reading
Posted in SQL, SQL 2012, Uncategorized
Tagged CTE and % example, Sequence generation, While loop example
2 Comments
SQL Server: Discuss Execute(SQL) At LinkedServer
Abstract This article details the use of “Execute AT LinkedServer” clause. It’s best in some ways when you are trying to run dynamic complex queries across heterogeneous data source. There are many instances that OpenQuery/OpenRowSet and four-part qualifier calling might not … Continue reading
SQL : How to Find Unused Indexes details
The Dynamic Management View (DMV) named sys.dm_db_index_usage_stats that track index usage details of the database. This DMV gives an information about an index which is being updated but not used in any seeks, scan or lookup operations. The below query list … Continue reading
Posted in SQL, Uncategorized
Tagged find index size, find index typ, finding no of rows of a table, finding unused inde
Leave a comment
PowerShell : CSV – Disk Space Report – Excel
Abstract Monitoring disk space utilization of server(s) is a critical and important job for any administrator. Keeping things organized might improve application availability and server availability. Being a database administrator for 10 years, I have faced and handled/managed lot of issues … Continue reading
SQL Server: Monitoring Disk Space with FSUTIL command line utility
Table of Contents Introduction Pre-requisites Data flow Enable xp_cmdshell Download SQL Code Output Conclusion References See Also Introduction This article talks about one of SQL method to fetch the disk usage details and use of T-SQL in conjunction with invoking … Continue reading
Posted in SQL, SQLCMD, Uncategorized
Tagged FSUTIL Examples, FSUTIL FSINFO, xp_cmdshell examples
Leave a comment
Disk Space GUI Tool – Multi Server(s) – Grid and Email Output
Monitoring server resources is critical and important job of any Administrator. Keeping things organized might improve application availability and server availability. Being a database administrator for 1o years have faced and handled/managed lot of issues with disk space. There are … Continue reading
Minimizing SQL Server DBCC CHECKDB Performance Impacts
Overview SQL Server is the most popular relational database management system, which is used by many organizations to maintain their data. Every user expects that data should be stored in a consistent and integrated form. SQL Server is equipped with … Continue reading
SQL – MultiServer SQL Inventory – PowerShell
Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of the servers you manage.This inventory can take any number of forms but, ideally, will allow some aggregation of information. When … Continue reading
