n.heyen (10/19/2012)

---

This is all new to me, we normally don't do much programming here and I've not had much luck getting started.

First, I should be able to search for text...

If you're on enterprise edition, 4 filtered indexes (1 for each distinct value) might be your best bet.

As others have pointed out, it's fairly straight forward, point and click through the wizard.

If you do run into issues, review the installer logs under C:\Program Files\Microsoft SQL...

Does the Sql Agent Job fire successfully when the deadlock occurs?

Also, are you using a named instance? In the sample code, at the bottom,

@wmi_namespace=N'\\.\root\Microsoft\SqlServer\ServerEvents\MSSQLSERVER'

"MSSQLSERVER" will be different for a...

Sql server should have permissions to copy the file, so xp_cmdshell.

My approach for moving databases:

1. Alter DB set single_user rollback immediate

2. Alter db set offline

3. xp_cmdshell to copy mdf/ldf to...

Markus (10/1/2012)

---

Thanks for the link SpringTown... I hadn't found that article. I have opened an incident with MSFT and have yet another meeting with the storage gang today. ...

sql-lover (9/28/2012)

---

...

Last but not least, why reinvent the wheel? 🙂 ... unless you are really bored, there are tons of awesome solutions online for Index Maintenance and jobs. My...

No thanks, I prefer this url: http://support.microsoft.com/kb/2137408

SQL Server logs "Msg 833" when I/O delay problems occur

vivekkumar341 (9/30/2012)

---

SQL Server has encountered 22953 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [H:\MSSQL10_50.MSSQLSERVER\MSSQL\Data\xxxxxxxxx.MDF] in database [CORETABLES_PROD] (6). The OS file handle is 0x0000000000000DE4....

checkdb is very IO intensive, and your IO subsystem isn't keeping up.

What are you using for storage?

Oh, and if you update a col that is included in an index, it will probably show up as a singleton lookup for the index but not as a...

you've answered you're own question, if an index is non unique, accesses will be scans, not seeks, hence 0 seeks reported.

your question should be "why would I see...

DR means disaster recovery, so start there.

If your servers caught fire and were destroyed right now, as in this very instant, how long could the business tolerate...

Don't reinvent the wheel. Ola hollengren's db maint scripts do exactly what you are looking for.

GilaMonster (8/30/2012)

---

Without any downtime at all, exceedingly difficult. Add new files to each filegroup on the new location, shrinkfile with the emptyfile option the files that are in the wrong...