I agree. Every US citizen should go and vote.

And everyone should go and vote.

And then go and vote again[/url].

Specifically, support our local Gila[/url] Monster[/url] or PowerShell FTW[/url].

Nelson Williams-487553 (11/2/2010)

---

I find that irresponsible. Here we are on the government created Internet engaging in the free exchange of ideas and you don't want to take part.

I think...

Ninja's_RGR'us (11/2/2010)

---

Grant Fritchey (11/2/2010)

---

Yep, what he said. Generally the size of the data stored will define, in pretty close approximation, the size of the database. You can get the size...

Yep, what he said. Generally the size of the data stored will define, in pretty close approximation, the size of the database. You can get the size a number of...

I'd have to see the execution plans for both queries before I could hazard a guess. It might be that adding the index caused the query to recompile. It might...

vgv8 (11/1/2010)

---

The last bolded part seems to me in contradiction with "it’s a table scan in all but name".

From this citation I can understand that Full CL-IX (Clustered Index)...

Congrats. You worked hard for that.

GilaMonster (10/30/2010)

---

Or put triggers on the...

The default trace does not store data manipulation calls. In order to track those you'll have to create your own server side trace.

The more important question to ask is, why is your log growing? Do you have a database in Full Recovery mode, but you're not running backups? Do you have log...

This is the Microsoft documentation. What are you looking for?

Since the statistics are stored with the database (except in the case of an upgrade, as was mentioned), they will be moved with that database. This means, if the statistics...

Then you'd probably be better off doing the integration some other way, call both databases from the app instead of one database from the other database, something along those lines.

GSquared (10/29/2010)

---

Am I correct that this table does not have a clustered index nor a primary key?

That seems to be what you're describing.

If so, that's probably a major part of...

parthi-1705 (10/29/2010)

---

The Column name i have kept on my server...