That's tough to say. It really depends on the type of search we're talking about. Is it across a single data set that could be encapsulated in a partitioned view...

If the agencies are going to be doing regular searches across the entire data set, I would consider putting it all into a single database (it does depend on the...

Knock wood, I never had to restore a Sharepoint farm. But, what we were doing to protect it was point in time backups with the knowledge that we'd have to...

Sioban Krzywicki (2/2/2015)

SQLRNNR (2/2/2015)

I have to agree. ...

Use the dynamic management views to gather better information. Sys.dm_exec_requests will show you the processes. That will let you more easily see what the query is of the blocking process:

SELECT...

Like Gail says. It sounds like something, unknown at this point, is wrong on your server. I'd get the consistency checks on all the databases, including the master, gets run...

Regardless of other choices, you should...

Weird duplicate post. Edited this to remove the repeated statements.

It won't change the IDs on a reboot, no.

It sounds like you have a corrupt database. Do you regularly run DBCC CHECKDB on your databases? If not, I'd strongly suggest...

Maintenance plans are there so that you do actually maintain your databases, which must be done. But, as you get more sophisticated, yes, you're probably going to stop using maintenance...

Is the connection issue to Azure? That could be network latency because you're going out to the cloud.

If it's just local... I'm not sure. I'd suggest using standard troubleshooting approaches,...

I think this is down to clarity of code versus actual functional differences. I'd go with the ISNULL and/or COALESCE over a CASE statement.

But, as with anything, test it yourself....

I'm going to be at SQL Rally at the end of February. I'll fly from there to SQLBits on Wednesday. I'm presenting two sessions at Bits. I'll also be at...

I like Ola's scripts and Michele's. I recommended them both in my book.

There is another option to look into. Minion Reindex by Sean & Jen McCown. I wrote a review...

Just so you're clear on terminology.

A backup is a page-by-page copy of the database including all the database objects and the data inside the database.

You're asking for a script for...