Yes, but if you create a job to truncate the log every minute (for example), or to truncate it when it gets to 60% full, then at least you have a...

Darren

I recommend that you read this before proceeding, so that you are aware of any pitfalls of whatever method you choose.

http://www.sommarskog.se/dynamic_sql.html

John

Something like this?

WHERE ins1.createdate IN

 (SELECT createdate FROM tbl_NSP_Inspection

  WHERE InspectionUID = @InspectionUID )

I'm afraid I can't help you on the SQL CE side of things.

John

William

Is Daily_Transactions the name of the database?

DROP TABLE Daily_Transactions.dbo.hist

John

The two filegroups would have to be on separate physical disks for there to be any performance improvement.  I've never analysed it, but I would think if you're pulling a...

Trystan

Almost right.  Take the table name out of the first line to leave just the alias:

UPDATE INS1

SET INS1.IsLastOfDay = 0

FROM tbl_NSP_Inspection INS1 

INNER JOIN tbl_NSP_Inspection INS2 

ON INS1.InspectionUID = 

Gail

We have our tables on one filegroup and non-clustered indexes on another.  While this may not provide the best performance in every case, it is a satisfactory generic solution and...

You should be aware that if you use dynamic SQL in your stored procedure, it will be executed in the security context of the user running the stored procedure, and...

Oooh - I don't know.  Send it to your favourite good cause.

Seriously, though - happy to help.

John

Not tested, but something like this should work.

John

UPDATE t

SET t.lst_upd_ts = c.lst_upd_ts

FROM Tbl_Dates_Convert c JOIN Table_Dates2 t

ON t.TS = c.TS

Rob

I agree that it does seem a daft way of doing, but you don't need to have everybody having sysadmin access.  Just delete the BUILTIN\ADMINISTRATORS user (or whatever it's called...

Kathleen

OK, so you can either copy the model database files to the default location before you start SQL Server, or you can start SQL Server with the -T3608 flag and...

SQL Server implicitly converts the string into a datetime value.

If you are trying to plug in the values in the way you show in your "Test it out" section, then...

Would this work, then?

INSERT INTO #temp_Metrics_asp( Start_Time,End_Time)

SELECT CAST (mt.New_idle_Time AS datetime), -- datatype is decimal

 CAST (mt.New_idle_duration AS datetime) -- datatype is decimal

FROM tbl_metrics_asp_test mt

John

What sort of information is in the idle_time and idle_duration columns?  Is it a number of seconds, or is it a decimal number that represents the number of days... or...