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

Actual Difference Between EXISTS(SELECT 1 …), EXISTS(SELECT * …), and EXISTS(SELECT column …)

By

Is EXISTS(SELECT 1 ...) better than EXISTS(SELECT * ...)? Who would know better than...

ANSI_WARNINGS = OFF can break update statements with some SQL features

By

Working on a SQL 2017 database where an external, non-Microsoft application has direct access...

Bring Your Own Key to Azure SQL Database Managed Instance TDE

By

Last year Azure SQL Database Managed Instance saw the introduction of bring your own...

Read the latest Blogs

Forums

Transactions/Second

By SteveOC

Hello.Does anybody have a way to identify what transactions ran in an interval (i.e....

How to update status with conflict data where chemical temp table have same chem

By ahmed_elbarbary.2010

How to update status with conflict data where chemical temp table have same chemical...

Blob to ADF to Stored proecure

By SQL_Surfer

I'm reading file from BLOB through ADF and I would like to pass the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers