Automated Profiler trace import

This stored procedure was written to complement the automated profiler trace create procedure (should be here somewhere - check the scripts).Bascially, given the database (sample script to create the database included, but you may want to personalize it), this stored procedure will import the tracefile content into the table, which is indexed on expected search […]

2005-10-03 (first published: )

354 reads

Automated Profiler trace Create

This stored procedure is created to be invoked (in my case by SQL Server scheduled job), and will then create a tracefile to a specified file location (ensure that if this is NOT local, your SQL Server Agent runs on a domain account that has access to that drive. The Stored procedure will create files […]

2005-03-16 (first published: )

424 reads

Blogs

Daily Coping 10 Jul 2020

By

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

Daily Coping 9 Jul 2020

By

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

Refreshing a Power BI Dataset in Azure Data Factory

By

I recently needed to ensure that a Power BI imported dataset would be refreshed...

Read the latest Blogs

Forums

temp table performance in sql 2016

By rohitkocharda

HI everyone, I just restored a DB on sql2016 from sql2012. One of my...

Nearest Proximity For every record

By marty.seed

Hello! We have a query we are trying to build with a key component....

Isnull in a Where Clause

By luismarinaray

Dear friends, We used Stored Procedure on our Queries for us to get  valuee...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers