if you are counting using e.g;

select count(*) from yourtable with (nolock)

Only in this case you'll get a good approx.

(because the number doesn't have to be exact)

Darned, I loved that series.

You've just made my day even better. #Goodtimes

The IT crowd - Truest moment about...

a while ago, someone wrote Changing Career Gears

It still holds truth

😀

Grant Fritchey (12/15/2011)

---

100%, no one does that. Not even...

1)make coffee. There is no checklist to do because I have all I need on my smart phone

2)sqlperformance issues and a couple of server crashes

3)Do you want the scripts...

to ease your load, you could consider creating FK-constraints after the load has been performed.

But keep in mind to put them back in place.

Did you refresh the ssms object browser ?

Can you post the DDL for the used :

- create database

- the concerned table ( and indexes )

How about using the oFile.DateCreated property to determine the age of your bak file ?

Just today I've seen a tweet pointing to a delegation troubleshooting blog:

http://blogs.msdn.com/b/sqlserverfaq/archive/2011/12/12/troubleshooting-kerberos-delegation-using-delegconfig.aspx

We choose to leave one SQL2000 instance to host DTS-packages until the project teams get budget to upgrade the packages to SSIS.

Main reason is to avoid troubles as you have.

We...

- at db upgrade time. (after restore, together with all other db maintenance)

we have auto update stats enabled.

We check every now and then how old statistics are and rebuild them...

Jeff Moden (12/12/2011)

---

ALZDBA (12/11/2011)

---

[sarcasm]

As a firefighter sysadmin/dba, I cannot but embrace your choice of solution.

( insert in table a server a with a trigger to insert into serverb some table)

This...

R.P.Rozema provided the solution.

I just want to point to Some common date routines by Lynn Pettis

and

my rules of thumb for date/datetime related stuff http://www.sqlservercentral.com/Forums/FindPost1219915.aspx

richardkel (12/12/2011)

---

...

Everyone seems to be saying don't use triggers, but how do you get the record keys into the staging table for the records that need to be transferred by...

[sarcasm]

As a firefighter sysadmin/dba, I cannot but embrace your choice of solution.

( insert in table a server a with a trigger to insert into serverb some table)

This will guarantee my...