This post contains a guide on how to export data from a SQL Server database using SSMS. SSMS, SQL Server Management Studio, is the standard application that most people use to run queries for a Microsoft SQL Server Database.
There are many ways to check the size of a table in SQL Server. The way you will do it will likely depend on what your task at hand is.
Backing up a database is something I’ve always found easier done within a query window. There’s not much to it; BACKUP DATABASE [DATABASENAME] TO DISK = N'e:\directory\databasename_backupdate.bak'
This is a simple guide to restoring a full backup file in SQL Server, providing an overview of a few options that are available during the process.
This script will delete rows within a table that are out-with the specified retention period. This can be useful if you’re running deletes on large tables, and particularly if;
There’s often a need to quickly copy/paste a database query output into an Excel sheet, rather than exporting as a .csv file.
As a DBA, I’ve found Stack Exchange Data Explorer to be a really useful tool for exploring and analyzing the data from the Stack Exchange network of websites.
While looking at an old script today, one that kills SPIDs on a SQL Server database… I had an instant urge to try kill a system SPIDs, just to see what would happen.
What’s the plan when you don’t know how to fix a production issue? You can prepare this situation by reading and keeping up to date.
This is a follow-on post of sp_who, sp_who2 & sp_whoisactive and is a run-through of logging SQL Server activity to a table, using the sp_whoisactive stored procedure.
