Reputation
1,956
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
4 23
Newest
 Yearling
Impact
~72k people reached

Apr
22
comment Fixing a corrupt Log File in small downtime window
First, I am not backing up nor restoring the Log file, so AFAIK, that would preclude any way of retaining the corruption. Secondly, our two approaches are almost identical, except for step #4, Attach the database and rebuild the log file. Does this actually work? I was under the impression that when Attaching an MDF you had to have the LDF also, can you really "rebuild" it? If so, how? I do know that RESTORE does this automatically (which is why I planned to use it), but I have never heard that abouut ATTACH?
Apr
22
revised Fixing a corrupt Log File in small downtime window
added 14 characters in body; edited tags
Apr
22
asked Fixing a corrupt Log File in small downtime window
Apr
17
awarded  Yearling
Apr
14
accepted Maintenance Plan Job running at additional unscheduled times?
Mar
27
revised Maintenance Plan Job running at additional unscheduled times?
edited body
Mar
27
comment Maintenance Plan Job running at additional unscheduled times?
@AaronBertrand Errp! Thanks..
Mar
27
comment Maintenance Plan Job running at additional unscheduled times?
All good suggestions Aaron. However, it did get figured it out. Thanks for the help.
Mar
27
answered Maintenance Plan Job running at additional unscheduled times?
Mar
27
revised Maintenance Plan Job running at additional unscheduled times?
added 264 characters in body
Mar
27
revised Maintenance Plan Job running at additional unscheduled times?
added 2 characters in body
Mar
27
comment Maintenance Plan Job running at additional unscheduled times?
I can edit the sub-plan, but how could I use it to figure out who submitted it? I thought running jobs were pretty divorced from their submitters.
Mar
27
asked Maintenance Plan Job running at additional unscheduled times?
Mar
10
comment Is indexing binary?
Searching without an index is O(N) and inserting is O(k). Searching with an index is O(logN) and inserting is O(logN). This is usually seen as hugely positive trade-off.
Mar
3
revised How to diagnose what is causing DB timeouts
changed query-timeout tag to connection-timeout.
Mar
3
comment Known vulnerabilities for when a guest executes a stored procedure on SQL Server
@AnupShah Oops, you are right, I misread the question.
Mar
3
suggested approved edit on How to diagnose what is causing DB timeouts
Mar
3
comment If user owns a database fixed role are they the admin of the role?
I guess you could count Application Roles as a fifth type, though they are really more of a Login/User type.
Mar
3
comment Known vulnerabilities for when a guest executes a stored procedure on SQL Server
Why don't you just give them a copy of your database?
Feb
28
comment indexing on multiple nvarchar(max) columns
Yes, that's true. I didn't quite understand that implementing a uniqueness constraint was your only need here. It's also a little odd to be using such a huge amount of text for uniqueness, since even a single extra space anywhere in up to 8GB would cause it to be different. Though i suppose that could make sense if you're using it to detect un-logged editing differences for versioning/revision identification.