Viewing 15 posts - 7,276 through 7,290 (of 49,552 total)
However - http://dbakapil.blogspot.com/2010/07/potential-security-threat-of-using.html
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 17, 2014 at 7:52 am
Double check all of their roles and permissions, not just what you gave them.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 17, 2014 at 5:49 am
As Shaun said, the SQL Agent job will show a failure.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 17, 2014 at 5:34 am
Really?
Name a search algorithm that has O(1) performance.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 16, 2014 at 6:29 am
Viewing 15 posts - 7,276 through 7,290 (of 49,552 total)