Sergiy (12/12/2007)

---

Well, what's gonna happen when you execute

[Code]

insert into real_table --will get posted to the current table regardless of type

select col_list

...

Sergiy (12/10/2007)

---

No bad experience.

Except when trigger is badly written.

Like your one. 😉

You do insert inside of INSTEAD OF INSERT.

Besides it does not make much sense, if suddenly nested trigger are...

Sergiy (12/12/2007)

---

I just did something like that today - using a staging table - the 1M or so records took 13 seconds to finish. You'll be lucky if you...

If you have a staging table, why not use that instead of a cursor to scrub/update/correlate/fill in your data. Even with the extra insert - it's going to be...

As SQLBill mentioned - it's all in the mix, as required by the customer. That being said - both sides are important. Showing that you know how to...

GO+number is 2005-specific. This doesn't work in 2000.

the TRUNCATE TABLE operation technically locks the entire table first, so if you're doing a single insert operation, it shouldn't interfere. On the other hand could be ugly if...

Adam Haines (12/12/2007)

---

Great point Clive :cool:.

The only potential problem I see is the application cannot inform the user that the backup has completed or failed. This can...

wouldn't it just be easier to attach a backup copy of the DB in a new 2005 instance and try to see if or how they work? Most of the...

TheSQLGuru (12/12/2007)

---

...but of course for write ops you have to divide by 4 for raid 5. ...

personally I think the ease of use of microsft products - the belief that...

No - user-defined functions cannot perform operations that change the database state, so DML is not allowed.

You've got the wrong stored procedure wired up to the wrong event in the ASP page. The SP used to load the page should not be the same one...

indhu06 (12/11/2007)

---

Thanks Gift.

This is wat i hv understood

I dont need licenced copy of sql server to deploy reports in my local machine(for development purpose), but i need licensed copy...

GilaMonster (12/12/2007)

---

Yup. I've seen some nasty stuff from vender software. From 38 indexes in one table, with the same leading column, to 'temporary' tables that don't get dropped (we had...

This is NOT a recommended, but...you can use the SET ANSI_NULLS OFF notation. It should allow you to use it that way.

That being said - you really should pursue...