HowardW (3/6/2014)

---

1024 is a very large value for BUFFERCOUNT, isn't it?

Any reason you've set this rather than not specify it (I think it's automatically tuned based on the number...

Grant Fritchey (3/6/2014)

---

Usually, but not always, ASYNC_IO_COMPLETION is caused by client side slow downs. The secondary cause is from network processes. But, in this case, it sounds like an issue...

What database platform are you using? You sure it's SQL Server?

Problem solved.

I ran the below then created my trigger:

SET QUOTED_IDENTIFIER ON

SET ANSI_NULLS ON

Good for you! Congrats! 😀

Thanks very much all. This is all great code which I have found very useful!

Thanks very much for the query but in the end I cannibalised the sp_spaceused sproc to come up with the below:

It gives back the reserved size in MB, and when...

.... you got...

Sure.. so just use it in your EXEC master..xp_cmdshell

arrjay (2/12/2014)

---

Hi there - I was wonder how you can copy all files with a certain file extension (.bak) from one location to another using sql code (not ssis).

I can...

JeeTee (2/12/2014)

---

Hi SSC,

I'd like to elicit some input from the community about foreign key usage in real systems.

Where I work, for one reason or another, we hardly use foreign keys,...

My attempt:

DECLARE @Codes TABLE

(

Codes VARCHAR(10)

)

INSERT INTO @Codes

( Codes )

VALUES ('ABC-0350'), ('DEF-00430')

SELECT codes, RIGHT(Codes, CHARINDEX('-', REVERSE(Codes))-1)

FROM @Codes

The recovery model of the database is different to the Autogrowth/Maxsize...

The first query gives me 8 and the second gives me 8, 8?!

Well here is the thing. When the recruiter approached me about the role he told me the salary would be X per annum. No range or up to blah blah.

oh...