Scripts

Technical Article

Import Multiple Packages to SSIS server

We cannot import multiple packages on the SSIS server. So, loading 100 packageS from  file location will be a tedious task for a DBA. We can solve this issue by making use of the DTUTIL utility. The DTUTIL utility can also import one package at a time, but we can write the batch file using the […]

2021-09-27 (first published: )

324 reads

Technical Article

PowerShell script to create SQL Server alias name

This script is useful for your environment having multiple always-on with replication setup and your listener value is persisted with RegisterallIP set to 1. When initiating the always-on failover, It will create/update the alias in the distributor server by pointing to the new primary server without RDP to each distributor server and that makes the […]

2021-07-07 (first published: )

478 reads

Technical Article

How to shrink tempdb database in SQL Server

This article discusses different methods that you can use to shrink the tempdb database in Microsoft SQL Server. Before you shrink the tempdb database using the methods described in this article, note the following: The tempdb size is reset to the final configured size (i.e. to the default size or the final size that was […]

2021-06-09

611 reads

Technical Article

Space allocated to the databases by disk letters

Found this useful for database migrations. This helps to identify how much space will need to be allocated for a new server and how a SQL Sever instance is using discs currently. Note. This won't show correct information on Linux instances and if you use mounting points in Windows.

3 (2)

2021-04-23 (first published: )

583 reads

Technical Article

Execute on DMVs without user having View Server State

Wanted to share this script to the community just in case anyone out there may be search for a way to allow a hosted customer the ability to query certain DMVs for information without granting them View Server State. There are some other options out there, but this worked better for me after going through […]

5 (1)

2020-09-24

953 reads

Blogs

Daily Coping 3 Dec 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

How To Start And Run A Great Home Business

By

With the current state of the economy, many people are seeking out opportunity in...

Proven Strategies For Your Home Business

By

A home business is a popular choice for many people. But it can also...

Read the latest Blogs

Forums

how to identify BottleNeck by using the data of sys.dm_os_performance_counters

By 892717952

There are many many data to show the SQL Server current performance, May I...

SQL Query Help on Time based query

By dcw8888

I have a following table (Contains script to generate the sample table with data):...

When to Use a Database

By Steve Jones - SSC Editor

Comments posted to this topic are about the item When to Use a Database

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers