Lowell (11/16/2011)

---

i'm trying to think this through, does this sound right to everyone?

SQL retrieves the data in what the query engine deems is the fastest way possible, and caches that...

itsamarnath (11/16/2011)

---

I changed the location of database settings from G Drive to T Drive.

Does this need a recycle of SQL Server?

I dont think so, because, when I tried to create...

jpSQLDude (11/15/2011)

---

Sean Lange (11/15/2011)

---

You are over thinking this. Don't make it so difficult in your mind. The client machine makes a request for a web page. This is done when...

Check out this:

http://msdn.microsoft.com/en-us/library/ms151706.aspx

I couldn't find anything really about placing the distribution database on the subscriber, but that's because it is not really done. You see, when you create a...

I will...

aurato (11/15/2011)

---

jared-709193 (11/15/2011)

---

aurato (11/15/2011)

---

jared-709193 (11/15/2011)

---

Now we understand your real concern. You don't want indexes there that are unused because you feel that it may affect performance. Let me...

aurato (11/15/2011)

---

jared-709193 (11/15/2011)

---

Now we understand your real concern. You don't want indexes there that are unused because you feel that it may affect performance. Let me ask you...

aurato (11/15/2011)

---

jared-709193 (11/15/2011)

---

Can you tell us the primary reason for you wanting to drop these? Are you annoyed with the amount of indexes or are you running out of space?...

aurato (11/15/2011)

---

jared-709193 (11/15/2011)

---

aurato (11/15/2011)

---

Well, the create date of tempdb is September 7, 2011 and of the five indexes that don't have any user seeks/scans/lookups 4 of them don't have any...

Can you tell us the primary reason for you wanting to drop these? Are you annoyed with the amount of indexes or are you running out of space? Obviously these...

aurato (11/15/2011)

---

Well, the create date of tempdb is September 7, 2011 and of the five indexes that don't have any user seeks/scans/lookups 4 of them don't have any system scans/lookups...

jpSQLDude (11/15/2011)

---

Thank you all for the responses, but I am still VERY unclear on how this actually works.

I remember reading years ago when the whole .NET thing first was getting...

Also, explain to him that a dynamic web page is really a bunch of static pages. So the action on a .NET page sends a request to the server,...

If it is truly web based, it is going through IIS or something similar. If it is local, the databases can be accessed directly.

Sometimes the simplest solutions evade me... 🙂

Jared