I did run dm_indexes_physical_stats on the table and the indexes were all either 0 or 0.45 percent fragmented. So assuming DBCC passes, is it probable that the only...

If a rebuild of a clustered index was stopped before completion, I would think that might be a problem. How do I determine if there is a problem and...

I've been studying with the 70-463 book, and not having much Data Warehousing experience, I'm having a tough time with it. There's a lot of technical information without a...

Yes, not obvious why the column needs to be specified again, but it seems to be working.

Dan

Maybe you can do it with Powershell, but for some tasks doesn't it take more time without removing the risk of breaking something?

I'd say so. This is like if someone in Seattle asked you to meet at Starbucks but couldn't provide an address or location.

Sounds like someone copied questions from a chapter review section of an exam preparation book. They might not even recognize a correct answer if the wording differed from what...

Jeffrey Williams 3188 (1/6/2014)

---

I would think you need RDP access to the systems, and access to each instance either through a security group membership or the 'sa' account.

Without either of...

System administrators often don't know much about SQL and won't know about instance names. This has happened to me occasionally. Here's what I've done:

1) If I can't...

When someone writing about SQL server says "Never do this: <insert action here>!" it is almost never 100 percent true. For every action you can do, there exists...

Assuming that PosDB2 is the database that grows out of control, I would set the PosDB2 database with a maximum size that you don't expect it to hit except when...

On a 36 GB server with 5 instances, I would set the MAX memory setting on each instance so that the total of all 5 was 32 GB. ...

Is there any downside to having TempDB files that are larger than needed other than that they occupy more drive space than necessary?

Most maintanace functions can be done in SQLExpress through SQL Server Management Studio, but manually. Most Express instances are maintained when a DBA gets around to it, with utilities...

"Sorry officer, I was diagnosing a failed maintanance job and I didn't see the stop sign."