Bevan keighley (3/3/2009)

---

veena (3/2/2009)

---

hi,

thank you for replying....

For Some reason i want to Store TableA id in TableC....

Plz Tell me Whether i can do this in a database where Normalization rules...

I always forget they're there when I post. Makes me crazy.

:D:P;):w00t::cool::hehe:

It is bad, really bad, form to have tables without primary keys. You need a way to identify data in order to retrieve it.

The problem is, in your example, you...

Well that one just yacked me off but good. He may as well be quoting from my posts because I'm "guilty" of all the "crimes" he listed. But hey, don't...

Mangal Pardeshi (3/4/2009)

---

Please!!!!!!!

I must confess, my that comment was with one of the poster with not all of you guys.

I observe that one such member is just looking for increase...

Mangal Pardeshi (3/4/2009)

---

Sooner the better.

The rating thing, hard to know. I think if you consistently answer poorly,...

Something. That isn't closing it's connections. Could be SQL, could be something else. Probably something else.

That sounds like some app isn't closing it's connections. Lots of open connections will certainly chew up memory eventually.

It can be yes. If you look through the white paper though they're using DMV (dynamic management views) which give you a lot more detail that you'll get through the...

Stamey (3/3/2009)

---

The individual objects, like when you need to duplicate a table real quick. Used to be simple to do with SQL 2000, you got the same window as if...

Hmmm... Well, have you tried looking at the wait states and queues? That's where I'd go next. See what everything is waiting on. Here's an excellent article on it: http://download.microsoft.com/download/4/7/a/47a548b9-249e-484c-abd7-29f31282b04d/Performance_Tuning_Waits_Queues.doc

One issue I've seen repeatedly with linked servers is running the query such that the filters are processed on the SQL SErver side. This requires that a SELECT * be...

Stephanie Smith (3/3/2009)

---

I am trying to query a table that has several records for each employee. Everytime there is a change to an employee in the application, a new...

I don't understand the question. Do you mean generating individual TSQL scripts through the GUI?

2005 & 2008 are pretty much the same. Where are you hitting issues?

Backup and restore works just fine. You can also detach, copy and attach as an upgrade process. Whichever you end up doing, just make sure you run it through the...