Viewing 15 posts - 181 through 195 (of 659 total)
You are working for a company that has uses SQL 2012 for their on site databases. A fellow DBA is trying to do a quick check on a database by...
June 18, 2014 at 2:13 am
Eric M Russell (5/21/2014)
By default, foreign keys are not indexed, and nor should they generally speaking.
If the table is large and the referenced table allows deletion, then foreign keys...
May 22, 2014 at 3:24 am
Steve Jones - SSC Editor (5/15/2014)
James Lean (5/15/2014)
May 16, 2014 at 1:17 am
TomThomson (5/15/2014)
May 15, 2014 at 8:46 am
Whatever the truth about the trace flags, I disagree with the answer.
In my opinion, the best way to test the behaviour of a particular database version is on a database...
May 15, 2014 at 6:32 am
Nice idea, but there were not enough options. Just looking at the first select gave the answer.
May 12, 2014 at 2:17 am
Hany Helmy (5/3/2014)
You can drag & drop that border line between query pane & result pane to minimize the result pane.
Indeed you can. And then drag and drop it back...
May 6, 2014 at 2:31 am
Thomas Abraham (4/30/2014)
BWFC (4/30/2014)
You can actually go back years and answer old questions if you just want to rack up points.
Some people do. They add extra points by adding a...
May 1, 2014 at 2:44 am
SQLRNNR (4/16/2014)
The [databases] object intended (and therefore meant by the question) was in the sys schema.
No it wasn't. According to the explanation it was in the dbo schema - but...
April 16, 2014 at 6:33 am
SQLRNNR (4/15/2014)
Every system has a sys.databases and that is what the question was referring to.
No it isn't - the question clearly refers to [dbo].[databases]
April 16, 2014 at 2:25 am
I agree with Tom, that None of the Above is probably the best answer (though I went for running in dev).
NOEXEC is definitely not correct though. Just try this
SET NOEXEC...
April 14, 2014 at 6:54 am
Uwe Ricken (4/2/2014)
Now I have the scenario as you have described in your question
No - you have a scenario, not the scenario. You have made an assumption about how the...
April 2, 2014 at 10:39 am
mkeustermans (4/1/2014)
Since king_login has default schema of king_schema and has been assigend the db_owner role and no other, the table will be created as king_schema
Like many, you are getting confused...
April 1, 2014 at 5:17 am
victoria_e_wood (3/31/2014)
March 31, 2014 at 9:32 am
Viewing 15 posts - 181 through 195 (of 659 total)