Milu (10/1/2008)

---

Hi Sandy & Gail,

I got so many new concepts from both of your post..thanks you a lot to both of you. but still i am in dark on my...

pavankumar.mvs (10/1/2008)

---

Hi

I am new to sql server 2005. I have few questions to the forum, Please give me the solutions.

1). My database is running fine all...

Maybe.

It depends on whether the clustered index is useful for the queries that are causing the locking. All tables should have a clustered index and 0 or more nonclustered indexes,...

Mirroring is a failover for a...

Clustering's good when you need redundancy for the entire server, not just a single databases.

Mirroring happens at the database level, so if the app depends on resources outside of the...

Sandy (10/1/2008)

---

Yes Gail,

I do agree with you for both the point you specified in above post.

Yeah, but table variables are treated the same in terms of the TempDB system tables...

It would mean that recovery would take longer, in the case where the...

Depends on how the tables are been used. If many of the queries are of the form

SELECT A, B, C, E, F, G, H, N FROM [TableName] WHERE A =...

WayneS (9/30/2008)

---

I have SS 2005 (Dev) on my computer. I frequently need to connect to a SS 2000 server. I've noticed a couple of things that I could do in...

I wanted to know your thoughts on why table variables were better than temp tables for 'highly transactional' workloads....

Jack Corbett (9/30/2008)

---

I'm glad I don't have the experience necessary to have known that. Then it would mean I had had to deal with major problems and who wants...

Scott Ohar (9/30/2008)

---

DTSRun isn't support on a 64 bit platform according to a few blogs, but if that's the case they can be wrapped around an ssis package to excute...

Only in terms of reducing blocking on the allocation pages of TempDB.

That's a huge machine. The largest I've ever played with was a 16 proc box with 64 GB memory.

Looking at the code you have, not likely. 2008, in...