AJ-636201 (2/21/2011)

---

I have created only one clustered index and that is on FirstName column, and no other index has been created not even any non clustered index.

So is there...

mikedu (2/21/2011)

---

What I have is a file that I am importing to a stage table. There are two tables after stage (current & history), the current table is a...

AJ-636201 (2/21/2011)

---

Hi,

I am trying to search the possibilities for tuning the query in which it goes for index scan.

select * from Contact where FirstName like 'a%'

As per business requirements many...

scottichrosaviakosmos (2/21/2011)

---

i want to insert data from one sql server table to another table which is in another server in sql server.

but when i insert data i dont want to...

I'd agree and it does, but RAID...

Grant Fritchey (2/21/2011)

---

You're cross over a few items there. The recovery model of the database and index rebuilds shouldn't be cross-concerns. Space on the drive is because you'll need room...

Koen Verbeeck (2/21/2011)

---

Phil Parkin (2/21/2011)

---

So you're not happy with the "just...

Steve Jones - SSC Editor (2/21/2011)

---

In addition to what Craig said, you pay for bandwidth, so factor in the cost of doing a backup, deploying code, testing on Azure, etc.

The...

Rich Yarger (2/21/2011)

---

Hello -

Recently, I was asked about my thoughts on Microsoft's Azure platform option, and whether or not it would be worthwhile to look into. Frankly -...

For anyone curious, my opinions on the SQLSaturday #47 event in Phoenix.

http://www.sqlservercentral.com/Forums/Topic1066836-1199-1.aspx

All in all, a very satisfying day.

Rich Yarger (2/19/2011)

---

Craig if I may - just one last question on this subject, because you have mentioned it a couple of times. As I have previously stated, the...

tacy.highland (2/18/2011)

---

That doesn't quite work either. I tried that in the earlier post (the "variation"). I've found other Cases which should be included in my resultset but aren't....

Rich Yarger (2/18/2011)

---

Craig, thank you again. I think the only other thing that will go on C:\DRIVE is going to be the backups, and that is it. That...

Can you provide the list of errors?

Rich Yarger (2/18/2011)

---

Hi Craig -

Wanted to pick your brain on one other idea for this RAID configuration I have been working on. We previously discussed the idea of...