1,829 reputation
320
bio website movingsql.com
location New Jersey
age 56
visits member for 2 years, 3 months
seen 9 hours ago
coder & programmer of many defunct languages...

Jul
8
comment Database instance and database
This distinction ("Database Instance" vs. "Database") only applies to Oracle, AFAIK, and is related to Oracle's implementation model.
Jul
8
comment Is select * still a big no-no on SQL Server 2012?
@CraigYoung The performance problem may be simplified in my description, but I don't think that it is an over-simplification. Performance problems from * can only occur if the * appears in the top-level select. As long as the top-level select explicitly lists only the columns desired, * appearing anywhere else cannot cause performance problems. However, I will edit my reply to clarify that it is only a potential performance problem.
Jul
8
comment Is select * still a big no-no on SQL Server 2012?
@CraigYoung Yes0, the View's Columns issue is the binding problem I mentioned in the footnote.
Jul
2
comment Is select * still a big no-no on SQL Server 2012?
@Damien_The_Unbeliever Agreed, good point.
Jun
12
comment Cannot add foreign key constraint while creating table
If you have solved this yourself, do not change the title. Rather, post what you did to solve it as an answer, then ACCEPT your own answer.
May
14
comment SQL agent job, why is the job history showing that a step is still running even though the job has completed
What's the actual query to you are executing that is giving these results?
Apr
23
comment Fixing a corrupt Log File in small downtime window
That worked great, thanks!
Apr
22
comment Fixing a corrupt Log File in small downtime window
@MarkStorey-Smith Not a problem, they are aware in great detail and in writing of my position on this matter. At the moment, the hosting provider is on the hook.
Apr
22
comment Fixing a corrupt Log File in small downtime window
@MarkStorey-Smith Perfectly right. Unfortunately, disputes with the hosting provider are limiting the options. That's about as diplomatic as I can put it.
Apr
22
comment Fixing a corrupt Log File in small downtime window
@AaronBertrand Yes, those qualification are true and intended as implicit in my statement above. (I had qualified these originally, but ran out of room and had to edit for brevity)
Apr
22
comment Fixing a corrupt Log File in small downtime window
However, the ATTACH_REBUILD_LOG option is attractive as it seems like this approach could be both faster and smaller. thanks..
Apr
22
comment Fixing a corrupt Log File in small downtime window
That's not quite right. If a DB full backup backed up both the entire data and log files, then they would have to be almost twice as large in most cases. From size alone you can tell that a BAK does not have both the MDFs and all of the LDFs too. The article says that the full backups only contain "sufficient transaction log records" to allow rolling forward the active transactions and to roll back the uncommitted ones. So, it should only be capturing the current transactions in the backup, though I suppose there's the chance that old corrupt log records are also be picked up.
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?
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
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
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
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
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?