Bru Medishetty (2/7/2012)

---

Have you clearly read the OP's requirement? He needs a mechanism to synchronize data from 3 client office databases to a centralized Server. In such a scenario how...

Also bear in mind that with most carriers you can actually email the SMS number directly (example for US T-Mobile customers you can email xxxxxxxxxx@tmomail.net which will send the SMS...

You'd really have to test performance, but I certainly wouldn't use RAID0 anywhere in my infrastructure. Can you really afford for your data warehouse to be offline because a single...

Can you run

select @@version and paste the results so we can confirm the SQL version you are running?

Just an additional thought. Depending on the version of SQL Server that you are running and the requirements around the data you may be able to run a mirror and...

If you find yourself in the situation whereby you need to rebuild a disk to reset the starting offset you'll need to start by moving all of the databases on...

With modern (last 18months) and the successful implementation of TRIM in SSDs I wouldn't worry too much about their lifespan.

SSDs provide excellent performance, however they are costly. I would...

kurtwest (1/19/2012)

---

I don't think the DNS Alias will work in this case. I am going from two stand alone SQL servers and two clustered SQL servers, to a new...

Unfortunately you can't point DNS to a particular port, only to the server (which is where a load balancer would have come in handy). Although saying that you could specify...

Excellent idea!

In the past I've also run things through a load balancer and it shows the connection coming from there.

host_name from sys.dm_exec_sessions doesn't give you what you need?

The answer is || that much.

Truth be told there are no hard set values. It very much depends on what your server is doing, the number of queries that get...

You only want to reindex tables less than 80% fragmented? What about those that are higher?

Honestly, rather then roll your own I would recommend checking out Michelle Ufford's reindexing script...

Actually, the DB name can change, but you would have to update your connection string to support that.

The only thing I'd recommend is ensuring that your server listen on 1433.

btw...

You can always check what IPs/Hosts are hitting your server using the DMVs.

For example:

SELECT dec.session_id ,

dec.net_transport ,

...