Technical Article

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 […]

You rated this post out of 5. Change rating

2005-10-03 (first published: )

362 reads

Technical Article

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 […]

You rated this post out of 5. Change rating

2005-03-16 (first published: )

434 reads

Blogs

Unlocking Real-Time Financial Insights: The Power of Microsoft Fabric

By

Microsoft Fabric is transforming real-time analytics for financial institutions. It provides a unified data...

Understanding Lakehouse Permissions in Microsoft Fabric

By

Understanding how permissions work in Microsoft Fabric can be essential for anyone managing access...

The Cost of Not Having a DBA

By

Does skipping a DBA save money? Wait until your system grinds to a halt,...

Read the latest Blogs

Forums

Union where it matches against only one shared column

By ldanks

Hi folks I have two tables, both with a NAME, START and END fields...

How to update using data from three tables?

By mjdemaris

I am in the process of migrating from MySQL to SQL Server. I have...

Select Returning Blank Rows

By JP789

I have the following select statement --#1 Select supplier, s.refnum, desc from supplier as...

Visit the forum

Question of the Day

Replacing a NULL II

What is returned from this code in SQL Server 2022?

DECLARE
  @value INT = NULL
, @value2 VARCHAR(20) = NULL;
SELECT COALESCE (@value, @value2, 100.5) AS Result;
GO

See possible answers