opc.three (5/6/2013)

---

Are you rebuilding every index? Maintenance Plans do this.

Consider using a tool that inspects the fragmentation levels and only rebuilds indexes that actually need it. Here is a...

Interesting.

We applied a hotfix already, but did nothing, it happened again. Now, not sure if...

Neeraj Dwivedi (5/6/2013)

---

I do not have any tools, I use batch scripts and SQL jobs to accomplish this. For our most critical applications, I do restore the backups in the...

No.

My cluster has been stable past 7 days or so, but I have not changed the iSCSI setting yet.

BUMP!

wow, no one ? 🙁 ... I just want to "hear" from other and their current restore / dbcc check strategy,

Did you test your software against SQL2008? There were some T-SQL changes on SQL2008 and deprecated features. You need to ensure your T-SQL code behind will also work or was...

Perry Whittle (5/3/2013)

---

I can sort of see why but I don't...

Just in case someone else is reading this thread and face a similar issue.

Our IT guy / SAN expert contacted Microsoft. He had a meeting with them and the Microsoft...

Isabelle2378 (5/1/2013)

---

Hi,

Well this is the reason for my testing this out...to see if it in fact does improve our performance. I will see if I can find the specific...

5 stars thread! Full of great information!

This is how something bad, can be turned on something good and useful.

will75 (4/30/2013)

---

I have tried this. The problem is the user I login with (my domain account) when I use command line does not have right to grant sys_admin right....

As far as I know, you need at least, to be Local Admin or part of Windows Admin Group on the machine running SQL.

You need to stop the instance, and...

John,

What's the purpose of the T-SQL CHECKPOINT, what are you trying to accomplish.

Also, not because a database is being replicated, can't be backed up. Actually, I have few databases...

Dropping my 2 cents here.

I actually contacted Ola just yesterday I think 🙂 ... for a very similar question (what a coincidence)

I've implemented his solution but found that some...

ft55 (4/29/2013)

---

Thank you for all the comments so far.

Could you expand on what you mean by reordering the transaction and how i might relate that to a select statement

I also...