What are you trying to accomplish?  If you want a read-only secondary server for reporting, then there are multiple technologies in SQL that you can leverage.  Availability Groups and replication...

Is there a reason you are reindexing? What is the reason?

Are you using online reindexing?

Have you considered the difference in activity on one vs. the other server?

What about configuration?  What...

I am almost positive that Ant-Green is correct.

The question is why are you doing this? If this is a development environment, SSRS should have been installed as a free (developer)...

Does anyone realize that if the docs are stored on the file system as opposed to a blob in a table, the need to scan them is then...

Does anyone realize that if the docs are stored on the file system as opposed to a blob in a table, the need to scan them is then part of...

Here is what I will propose to my Azure architect.

At each release:

1- I will launch a copy of the production to the Test environment.

2- I will limit access to...

And now you understand why the cloud is not cheaper than on-prem!

Out of curiosity, I ran this on my local machine.

I have used this approach to insert lists of records that were deleted or updated and it is also a good way to write scripts that insert into multiple...

Today is Steve’s birthday.  He’s turning 25.

Cry last time I rebuilt my computer I used an old windows...

Thanks  everyone for the comments.

I've avoided writing articles for several years because I always feel that it takes a lot to write something simple - and often enough it...

Ok, then can this be a pick list? Eliminate the human error.

Search for...

If this is a user search that's coming from a UI, can you create a translation table?

What about full text search?