BCP command to export data to excel with column headers
This script export data into excel/CSV file using BCP comnand with column headers
2009-10-01 (first published: 2009-09-22)
3,586 reads
Scripts
Execute SQL Scripts in paralel for real performance tests
Ever tried to simulate a production environment in a development one but realized that you couldn't easily start 500 executions simultaneously ? This script will help you out.
2009-09-30 (first published: 2009-09-16)
2,083 reads
2009-09-29 (first published: 2009-09-17)
931 reads
Runaway Job Management
Be alerted or take custom actions when specified jobs are in the "Running" state for a length of time.
2009-09-25 (first published: 2009-09-15)
915 reads
2009-09-24 (first published: 2009-09-15)
706 reads
Shrink Log File to Target Percentage
Performs a checkpoint or a transaction log backup followed by a DBCC SHRINKFILE on the transaction log to the target percentage specified relative to the total data file(s) size.
2009-09-23 (first published: 2009-08-27)
2,553 reads
Generate Data Script for a Table
This script takes a table as parameter and generate its data script (INSERT INTO TABLE).
2009-09-21 (first published: 2009-09-13)
2,275 reads
Script all the jobs on a SQL server 2005 and apply them in SQL 2008
The script will produce a Drop/Create script for all the jobs existing on the server. Instead of scripting them individually.
The output script will also have schedules scripted out
2009-09-18 (first published: 2009-09-08)
7,303 reads
List columns data type and size for every table in a database
This script will list columns data type and size for every table in a database.
2009-09-15 (first published: 2009-09-02)
2,015 reads
Dynamic Select Generator
Query to generate a dynamic Select statement from any table for moving data between servers.
2009-09-11 (first published: 2009-09-01)
1,621 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
Practical SQL Server Development Tips for Better Database Projects
Working with SQL Server 2022 can be a great learning experience, but development tasks...
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers