dmigo (2/1/2011)

---

This is an old, long thread and maybe it has already been mentioned but you can customize and add the RowCount column in the Object Explorer Details view for...

for myself i use the index scanning DMV and just look at the leaf level for the row count

i've had really good luck with managing indexes on the subscribers. i run the index usage DMV's and delete any unused indexes. it has helped increase the reliability of replication...

we've been doing it for years and after a while it's a big pain in the a**. not that they are not stable but a pain in the a** to...

never had a problem

our QA is almost always on a later build than production and we restore databases there. we also have a process to sync databases on a SAN...

is this a SQL 2008 only function or is it in SQL 2005 as well?

we don't run SQL on vmware but if you were going to do it you would have to watch the I/O. even SQLCAT's testing showed that all the I/O goes...

we run sql 2005 and windows 2003

to add a new drive letter to an instance you have to take the instance down. i believe it's because you had to add...

we have 3 clusters and it's always downtime in patching the SQL service packs. with windows patches you can do the inactive nodes at any time you want

Perry Whittle (1/19/2011)

---

changing the IP for what a...

i wish more people knew the basics like this. troubleshooting an issue this morning and it turned out our devs tried to use NULL values as real data. worked OK...

reuben.anderson (1/19/2011)

---

We're undergoing an enterprise consolidation and virtualisation project at the moment, and I currently have an external consultant proposing to replace our physical, clustered SQL Servers, with non-clustered VM's...

the database needs a few more tables

an inventory table to track inventory and will link back to the products table

an orders table

an inventory purchases table

part 3 can be about Bob trying to migrate to Cassandra DB and it's 2 billion column/table limit

and with the locations, it's a lot of money for travel as well

have you thought about doing these via webex or something similar? there are some free webinars every month...