Viewing 15 posts - 16 through 30 (of 1,347 total)
If you rebuild a heap, how long does it take for it to become fragmented again?
March 12, 2018 at 12:49 pm
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...
March 9, 2018 at 6:49 am
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...
March 8, 2018 at 9:28 am
does the sql server agent account on server D have rights to A and B?
March 8, 2018 at 9:21 am
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...
March 8, 2018 at 8:46 am
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...
March 6, 2018 at 7:27 am
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...
February 26, 2018 at 7:36 am
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...
February 6, 2018 at 6:49 am
You are right, I took a backup of the Service Master Key and restore...
January 30, 2018 at 9:51 am
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...
January 30, 2018 at 9:43 am
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...
January 23, 2018 at 11:56 am
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.
January 23, 2018 at 11:55 am
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...
January 22, 2018 at 1:54 pm
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...
January 22, 2018 at 12:46 pm
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...
January 16, 2018 at 9:48 am