If you rebuild a heap, how long does it take for it to become fragmented again?

i learned the hard way that if you have a busy replication environment then dropping unused indexes on your subscribers is a huge performance improvement and will get rid of...

This will depend on your IO speed, network bandwidth of source server, network at destination, IO at destination, the amount of work the NAS is doing at any time during...

does the sql server agent account on server D have rights to A and B?

Don't think i've supported a server with TDE before, but if you set up a cluster with databases encrypted with TDE why would you not restore the certificates on the...

It's not mentioned, but one of the earliest Machine Learning projects was a DARPA funded start-up that gathered data in order to predict Taliban attacks in Afghanistan. I forgot the...

How often does this break and you have to reinitialize? And how hard is it? With regular transnational we would just do it in the middle of the day and...

The biggest danger with AD groups is control of the groups. In some organizations new users are created as as a copy of an existing account. Sometimes a lower level...

having the same problem now

you can set up a sql job on both ends to run OPEN MASTER KEY DECRYPTION BY PASSWORD and ALTER MASTER KEY ADD ENCRYPTION...

In the USA it depends on the organization you work for. My last job we kind of sneaked into it as tech improved to where we can do stuff at...

have you tried just the server name? I think each instance has a browser service running or helper service that routes data to the right port if it's not default.

I was playing around and figured out you can do filesystem::\\server\f$\ and it works when I run it for one server. Doesn't work when i'm trying to run it against...

Is there anyway to use this with a UNC path? I cut and pasted some of your code and trying to write your function to run on a central server...

Off topic, but I've been playing with R on and off for the last 6 months and it's a lot better for this type of thing than SQL. You can...