If you're getting lots of inserts there's a good chance that during the day a healthy chunk of the information added to the table are falling outside of the statistics....

The biggest question is are you using Enterprise functionality? If so, going to Standard, regardless of version is going to be an issue.

You're making a modification to your server. Regardless of how "safe" that modification might be, yes, I'd make darn sure I have backups in place and that I've tested those...

Always On is a marketing term.

The two different services are failover clustering and availability groups. Failover clustering is...

SQLRNNR (4/13/2015)

---

Grant Fritchey (4/11/2015)

---

I'd suggest checking out Jonathan Kehayias article in Simple Talk on monitoring tempdb usage through extended events[/url]. If it doesn't include capturing the queries, you can just...

Yeah, it absolutely sends confirmation messages back. I wouldn't imagine that those, under most circumstances, are going to cause huge performance issues, but they absolutely do happen.

Looks like a blog recommendation. Not a big deal to post those on SQL Server Central, but instead of putting it into the general forums which are usually reserved for...

Looks like the exact same question over at ASKSSC. I gave very similar advice there.

If ever you wondered why so much emphasis is placed on backups, testing backups, ensuring backups...

The SQL Server documentation itself is pretty extensive. But, there's also a guide available here on SQL Server Central.[/url]

An online restore is an Enterprise only type of restore where you're restoring secondary files or filegroups while the primary file group is online and accessible. There's extensive documentation on...

There's also a knowledge base article on possible issues here.

It's usually kind of rare to see major network issues. Are doing the bulk load from an external source? I'd work with the network people to see if there's some...

You just have to make the calls to the in-memory objects. It's actually not very different at all from calling the regular tables. The one exception is when you have...

GilaMonster (4/13/2015)

---

Luis Cazares (4/10/2015)

---

Someone just mentioned that you could have 2 clustered indexes on a table. But I'm sure he's high. 😀

http://www.sqlservercentral.com/Forums/FindPost1676220.aspx

But, think about it, what if you're in situation...

RTM means Release to Manufacturing. It's the released product without any kind of updates or service packs applied. It's not recommended to use RTM.

To use the cumulative update, you only...