a little off-topic but maybe someone can answer this for me

in windows 2003 and later on basic disks i run diskpart and i can create the 64k offset for performance...

ian-707364 (4/8/2010)

---

Look at the price of a regular SAN with regular disks. It still can't compete on price! I did a price/performance comparison of a single MSA70 (25 disks) to...

I think Brent Ozar tested the HP version of this on tempdb a few weeks back. HP rebrands these, but i think they only sell the blade server version under...

very interesting

we've used something similar to this but a lot simpler for almost 10 year to store business rules for applications and users.

good article

i had to learn the basics late last year and it's pretty easy to get going to write basic reports. next step for me is to write complicated reports...

good article

i had to learn the basics late last year and it's pretty easy to get going to write basic reports. next step for me is to write complicated reports...

can't say the same thing for everyone, but a lot of times its easier and faster to just reinitialize replication than troubleshoot it or migrate it. script it out, and...

have you looked at the query to see if it can be optimized, indexes created, changed, etc? or how much data it returns?

with 32 bit you are limited to 4GB...

the differential backup backs up every page or extent that changes since the last full. forgot which on it is. this means that if you run alter index or change...

Kendal Van Dyke (3/30/2010)

---

David,

Can you elaborate on the following statement you made:

the number of records in the MSRepl_transactions table is likely to be very high and once it has gone...

got the derived column to work. haven't used SSIS much.

data source is the sp then it goes to the derived column that adds the column server_name and populates it with...

how would i do that? the source of the data flow is exec sp_replcounters

i would script out the publication and run the script on the distributor to create the publication from scratch. or create it from scratch

you can add included columns to your nonclustered indexes to minimize RID Lookups

Luke L (3/10/2010)

---

SQL Noob (3/10/2010)

---

hardware resources. we run a scale out version of SSRS and the main server has 32GB of RAM. Reason is our BI devs wrote a bad...