Michael Earl (11/10/2008)

---

I can see that, but I would not go overboard on this one.

They probably are not changing daily. I would script them, not allow them to be...

Michael Earl (11/10/2008)

---

Is your linked server environment that large and constantly changing? I would think source control for the changes would be overkill, but I suppose if you have...

Harold Buckner (11/7/2008)

---

how stupid of me. I kept going though the script and finally hit me to check the permission on the procedure. I grant execute on my db role...

Actually, they should be the same, my bad, it's been a while since I...

Harold Buckner (11/7/2008)

---

Hi Marios

I like the way you handled this task and the great information it provides. However, I had some errors on the 2000 script thats making me do...

Harold Buckner (11/7/2008)

---

Hi Marios

I like the way you handled this task and the great information it provides. However, I had some errors on the 2000 script thats making me do...

TheSQLGuru (11/6/2008)

---

I must have missed the smiley that indicated you were joking. As for resources required, the main issue with that statement is that almost everyone simply uses SIZE...

TheSQLGuru (11/6/2008)

---

Marios Philippopoulos (11/6/2008)

---

Would all 1024 drives be 'seen' by the same SQL server instance and shared by all other SQL instances? How does that help with IO throughput? Isn't...

I'm by no means a SAN expert but it seems from what you guys are saying that in the case where a SAN's resources far outnumber the resources actually required...

Would all 1024 drives be 'seen' by the same SQL server instance and shared by all other SQL instances? How does that help with IO throughput? Isn't contention a problem...

TheSQLGuru (11/6/2008)

---

1) Can you have 1024 drives direct attached effectively? You can do that with a...

How is SAN architecture in any way beneficial to SQL Server performance?

Thanks! I hate SANs, wish we could run SQL Server on desktops... 😉

TheSQLGuru (11/4/2008)

---

Jeff Moden (11/4/2008)

---

Then you should probably split it up... doing an update on something that large all at once will probably drive your code past the "tipping point" that...

Jeff Moden (11/3/2008)

---

Marios Philippopoulos (10/29/2008)

---

I'm having a performance problem, while migrating a large amount of data from one database to another within the same SQL instance.

The main wait type is...