Viewing 15 posts - 7,276 through 7,290 (of 49,571 total)
November 17, 2014 at 1:09 pm
spaghettidba (11/17/2014)
I hate captchas just as much as everyone else does, but they sure have a place in sorting humans from machines.
Yeah, google's image recognition (originally intended to interpret numbers...
November 17, 2014 at 1:04 pm
sKreetz! (11/17/2014)
Does this also apply to dba's changing their own or other dba permissions to access this information?
If the data is encrypted outside of the database (in the app) and...
November 17, 2014 at 9:21 am
If you set the stats task to column stats only, it doesn't make the slightest difference which order you run them, as they're doing independent things.
November 17, 2014 at 8:17 am
Encrypt the sensitive data in the application, If it's sensitive, it should be encrypted anyway, if it's encrypted by the app and the DBAs don't have access to where the...
November 17, 2014 at 7:52 am
Double check all of their roles and permissions, not just what you gave them.
November 17, 2014 at 7:44 am
Check the permissions and roles each has. There's nothing intrinsic to windows/sql login that would cause this.
November 17, 2014 at 7:18 am
Don't select all statistics if you're rebuilding indexes. It's a waste of time. If you're rebuilding indexes (maint plan rebuilds all), then select 'column statistics' on your stats update job.
November 17, 2014 at 6:16 am
smtzac (11/17/2014)
One more question: Should update statistics job run first or Index rebuild job?
If you set the stats task to column stats only, it doesn't make the slightest difference which...
November 17, 2014 at 5:49 am
As Shaun said, the SQL Agent job will show a failure.
November 17, 2014 at 5:46 am
Depends on the type of disaster.
If the log file is intact and SQL is still running, you can take a tail-log backup to get the data up to 9:30. If...
November 17, 2014 at 5:34 am
Really?
Name a search algorithm that has O(1) performance.
November 17, 2014 at 5:32 am
Yup, that's correct. So, given that definition, does your original question (how to implement O(1)) make any sense?
Also, what is the theoretical O(n) for a hash search (see your algorithms...
November 17, 2014 at 1:28 am
If you are going to stick with maintenance plans (not the best for index/stats maintenance), then you can select 'column statistics' on the stats update task and only the non-index...
November 17, 2014 at 1:24 am
Be careful what practice tests you use. If they're braindumps (actual questions from the exams), you can lose your certifications for studying from them. Stick to the exam practice guides...
November 16, 2014 at 6:29 am
Viewing 15 posts - 7,276 through 7,290 (of 49,571 total)