I have two videos on Youtube on how to do this. This one is on using T-SQL to do the backups and it's the right way to do backups. This...

I have made very few changes to model over the years. Instead I just script out all the necessary changes I want to make to a database as I set...

Table variables can work, but understand that they don't have statistics which could affect their use in something like a JOIN. You might be better off using a temporary table....

There are a ton of mechanisms built into Windows and SQL Server that will let you set all this up on your own. It's just a bunch of work and...

SQL_ME_RICH (6/17/2014)

---

Grant, thank you for that confirmation. I know it probably sounds very neophyte, but I wasn't able to find anything to fully confirm this (I am working on...

SQLRNNR (6/17/2014)

---

Eirikur Eiriksson (6/17/2014)

---

Sean Lange (6/17/2014)

---

SQLRNNR (6/17/2014)

---

Did you notice that the "Active Threads" on your inner window was missing?

My active threads has been missing most of the day. For...

No special issues associated with it. Each index can have it's own fill factor and it doesn't directly affect other indexes around it. It just affects storage and retrieval of...

Hard to say based on the information at hand. For most databases less than 200gb, I had everything in primary and it all worked well enough.

Gazareth (6/17/2014)

---

I think what Russell meant there was make sure you...

It almost has to be incorrect security on the instance. It might incorrect security on the server. But it has to be incorrect security.

I would suggest completely reconfiguring and reinstalling the system from scratch. I'd even nuke the operating system and start over. You don't want to deal long term with any kind...

I'd start any upgrade with the Microsoft SQL Server Upgrade Advisor. You want to know if you've run into issues with that before you do anything else. TechNet has a...

ben.brugman (6/17/2014)

---

Thanks for you response, offcourse this was a...

You could be seeing something of what you're talking about, but as the data changes, if you have auto update stats turned on, you should see the stats change, although,...

Two guesses, possibly out of date statistics on the tables in question or possibly something up with your I/O sub-system since you're seeing an I/O error.

EDIT

Sorry for the duplicate post....