1. Create SQL Server job that EXEC your S.P.

2. Job/Properties/Notifications

Move quotation sign behing comma.

Run this script:

SELECT t.name,

i.index_id,

i.type_desc,

i.name,

...

Yes, it can happen. I had a situation when 3 SPID's were blocking each other in a circular mode. I got an impression that SQL Server does not handle such...

Do you pass the right @TraceID taken from sys.traces?

Also, try to call it with hard-coded value:

exec sp_trace_setfilter 2, 13, 0, 4, 3000000

TheComedian (5/27/2014)

---

Hi all,

I've deleted a non clustered index that was taking up too much place but after running the exec sp_spaceused for the table, I've found that the index_size is...

But what is your problem? You posted a solution, just wrap it into a stored procedure and place it in your prod server. And call it whenever you have a...

I usually run this query on both sides and monitor its progress. It would be helpful if you have two monitors

select SCHEMA_NAME = left(s.name,30),

...

Do you have autoshrink database property set to true?

I tried to:

notepad $profile

but got an error: "The system cannot find the path specified."

What is the whole path ?

Thanks

You have just written what you need:

select Sum(surgical_case_count)

where wait_status = 'within target'

SELECT YEAR(GETDATE())*10000 + MONTH(GETDATE())*100 + DAY(GETDATE())

What SQL dialect is it?

In MS SQL Server T-SQL you should use parameters in form @year, @ccty, etc.

1. Change SORT_IN_TEMPDB = OFF

2. Remove MAXDOP or set it to high and run at at weekend.

3. Consider partitioning such a huge table by date.

Why not to select * into table_having_blob_1 from table_having_blob, then drop table_having_blob and rename table_having_blob_1 to table_having_blob.