Disk Fragmentation is one of the cause of degraded performance. Use this script for fragmentation analysis report.
This one line DOS script fetches Hardware Make and Model
OS Name, Edition (for 2003) and version
A database can have objects with multiple owners. The script will give you the list of all the TABLES, VIEWS and PROCEDURES having the specified owner. Just input the owner name and it will give you the list of all the Objects with that owner. This scope of the script is limited to the TABLES, […]
2007-06-21 (first published: 2006-01-30)
As an administrator it is required sometimes to list out the job owners.This is a simple script that will allow to fetch this information. By applying a filter a specific job owner list can be fetched.
2006-11-21 (first published: 2006-01-30)
By Steve Jones
It’s been a good week at SQL Bits. This is my favorite conference, and...
V Joyful Craftsmen máme skvělý bonus (tzv. SGP), v rámci, kterého se můžeme vzdělávat v...
I love KQL so much I even made a video and if you compare...
Get A Comprehensive Analysis of Market Trends Pi Cryptocurrency Value Prediction Here! As the world of...
Hello, I have 3 SSIS packages having connection manager defined with a userA. These...
Hi Experts, What is 'optimize for ad hoc workloads' do mean in short? I...
SQL Server Q&A from the SQLServerCentral communityGet answers