the worst we had was on SQL 2000 a few years ago. people noticed that data wasn't replicated to some subscribers. opened a case with PSS and they said to...

did you attach it without the log file after restarting SQL and switching out the data files?

i would also make sure that your file paths are correct and just like...

could have been wrong in my recollection

a month or two ago we had an instance where an update job failed. it was a simple update that joined data from another...

will probably install 4294 in QA this week and in production in a few weeks

i've seen instances especially on MS Access apps where you can't trust the net address. try running a profiler trace to see what the app is doing. worst case is...

if you use alter stored procedure, you can have a DDL trigger in your database to write the record of the change to a table. i'm about to start doing...

good article

in my experience the biggest impediment to running checkDB on a regular basis is management. i've seen it run without the repair or the all info messages options and...

john.schenck (4/22/2010)

---

true - but if you have near term plans for consolidation you may need to get DC edition along with Windows server DC

also as an fyi anyone who has...

hardware is a lot more powerful and cheaper today than it was a few years ago so you can consolidate a lot more databases on one machine. MS is going...

nice article

the SOX Gods have told us to make some changes and we are planning to change the accounts that SQL runs under in the next few weeks. and this...

20GB native should be OK. the third party products are good for multiple servers and multiple schedules for different databases

Bill Kline-270970 (4/12/2010)

---

I work in a multi db platform environment. We use both SQL Server and Oracle. I'm just a newbie when it comes to Oracle administration, and...

SSRS can't be clustered, at least not officially. you have to use the Enterprise version of SQL and scale out the SSRS on separate nodes. your reportserver database will be...

Oracle is a lot more expensive and i don't remember all the features, but it has some features that let it scale higher than SQL Server. I think the geo...

thx

the reason i've used dynamic disks for SQL is to expand the array. every year larger hard drives come out and instead of buying a new MSA70, you can just...