PolyBase

Technical Article

RE: Traces, traces, traces...

  • Reply

There could be server side traces created and run be the sp_trace_**** set of stored procedures. (I usually kick these sort of traces off from a scheduled job.)You could run profiler to find the source. If it turns out to be from the server itself, search the sprocs/agent jobs for sp_trace

You rated this post out of 5. Change rating

2004-07-22

Technical Article

RE: SQL Server crashing Windows when indexing

  • Reply

PeterWe've had this database and the TEMPDB both set to increase by 50% (both data and log files) and auto-shrink has been disabled.  Unfortunately, to no avail.Current statistics for database is as follows:Data file size = 4084 MB (1447 MB free)Log file size = 133 MB (118 MB free)For the specific table that the data […]

You rated this post out of 5. Change rating

2004-07-20

Blogs

Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox

By

Are you ready to take your SQL skills from theoretical to tactical? If you've...

Set a Runtime Variable in an Azure DevOps Pipeline

By

Note: I DO NOT recommend this. Any changes to a pipeline should be in...

A New Word: Symptomania

By

symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers