Not much you can do after the fact.  Look at the time that the log last grew (it will usually be the last modify time of the physical file).  Where...

How about this?  It's probably possible to tidy it up so it only does one table scan, instead of two, but I'm afraid I ran out of time

Don't run DB tuning advisor.  Use the missing index DMVs instead.  Query tuning isn't easy - I hope you don't mind my saying that I think you might be in...

Start by typing "missing index" into your favourite search engine.  There'll be plenty of material there for you to consider.  Post back if there's anything in particular that you don't...

So it's grown to 330GB but the original 300GB isn't being used?  I don't really understand... unless this database is used as a staging area where large amounts of data...

Ivan

If you know, or suspect, that the database will eventually grow to 300GB, you may as well start it off at that size.  That's preferable to risking physical...

Paul

Yes, it's possible.  It would help if you could post some table DDL (CREATE TABLE statement(s)) and sample data (INSERT statement(s)).  What other relationships are there - mother,...

Jacek

I think the problem is that you have one or more values of Slownik_ID_FK in Korekty that don't correspond to a value of Slownik_ID in Slownik.  You'll need...

I don't think he's reinvented the wheel, so much as copied it from here.

John

Which THROW statement are you referring to?  Strikes me that if there's an error, such as an arithmetic overflow, then control will immediately be passed to the CATCH block and...

They're the ones auto-generated when you use a column that doesn't already have statistics on it in a query.

John

The stored procedure and the ad hoc statement don't produce any output - they merely insert rows into a table.  (Actually, the statement won't event do that - it'll return...