@Kermit this is actually non-standard by the ISO/ANSI-92 standard. And at the same time standard with the 2003+ standards (not sure about the 1999 one), provided that companies(id) is the primary key of that table. Not that MySQL actually checks anything... — ypercube2 mins ago
I do that often to people at work. They aren't native english speakers and I'm constantly throwing Idioms at them and they have no clue what I'm talking about.
I'm still not sure I understand why this site is reputation-based. I think that all this does is make people afraid to participate in conversations.
All of the per-site metas are not reputation-based - the privileges you have there match what you've earned on their main site. Does the amount of participation you've had exclusively in the per-site meta affect your ability to jump into a conversation about issues on a site where you have participated highly? No. Should you be afraid of losing reputation for sharing an unpopular opinion there and getting down-voted into oblivion? No, and I th…
I'm still not sure I understand why this site is reputation-based. I think that all this does is make people afraid to participate in conversations.
All of the per-site metas are not reputation-based - the privileges you have there match what you've earned on their main site. Does the amount of...
Possible Duplicate:
Is there any way to favorite/bookmark an answer?
This is migrated from a suggestion I made at UserVoice.
Often times I am not interested in the question so much as I am the answer. Unfortunately, the only site option for bookmarking an optimal answer is to bookmark...
(New to SQL Server)
Oracle and SQLite documentation gives SQL syntax in form of diagrams, for example:
SELECT in SQLite http://sqlite.org/lang_select.html vs SELECT in SQL Server http://technet.microsoft.com/en-us/library/ms189499.aspx
Diagrams are way easier to read, so why SQL Server syntax i...
Because Stack Overflow and its Meta site do not share reputation.
This is, as you've observed, different from the other Stack Exchange sites and their Metas, which do share reputation. The reason this site is different is because, in addition to being the per-site meta for Stack Overflow, it is ...
because meta is for people who dont want to actually contribute to the general knowledge base of humanity. instead, it's for whining and bureaucracy. the metas are the ivory towers of the network: they provide no actual benefit to humanity and only serve to satisfy the egos and complaints of the margins. — swasheck12 secs ago
@PaulWhite ah. cool. i noticed in that blog post that you said in a comment that you find these things by looking for them. how do you look? just start at 1 and and try QUERYTRACEON 1 ... observe ... QUERYTRACEON 2 ... observe ... ?
@swasheck SSMS estimated plans for the inner side of a nested loops join show the per-iteration estimate. Actual plans in SSMS show the aggregate over all iterations. This is inconsistent and confusing to many people, so PE does the math to make the two directly comparable.
@swasheck Multiple ways. Brute force is one, though it is tedious and time-consuming. Most of the interesting ones come from debugging the SQL Server code.
@swasheck To be honest, I wasn't sure that's what you were after. What's all this about greyhounds?
so ... i've not yet figured out how to install WinDbg. i only want the bare minimum and i find it hard to figure out what that is ... i dont want to install the full SDK debugging kit
@PaulWhite i didnt really follow your point about the benefits of using `DBCC FREEPROCCACHE` vs `OPTION ( RECOMPILE, QUERYTRACEON 3604, QUERYTRACEON 9292, QUERYTRACEON 9204 );`
@swasheck FREEPROCCACHE ensures you get a fresh compilation (because the cache is empty). RECOMPILE does a similar thing for the statement, but also enables other optimizations like parameter-embedding that means you might get a different execution plan shape.
I'm still not sure I understand why this site is reputation-based. I think that all this does is make people afraid to participate in conversations.
All of the per-site metas are not reputation-based - the privileges you have there match what you've earned on their main site. Does the amount of...
Possible Duplicate:
Is there any way to favorite/bookmark an answer?
This is migrated from a suggestion I made at UserVoice.
Often times I am not interested in the question so much as I am the answer. Unfortunately, the only site option for bookmarking an optimal answer is to bookmark...
WITH CTE AS(
SELECT set_name, table_name, cfg_name, col_name, col_row, delete_id, recovery_unique_id,
RN = ROW_NUMBER()OVER(PARTITION BY set_name, table_name, cfg_name, col_name, col_row, delete_id, recovery_unique_id ORDER BY cfg_name, col_name)
FROM cfg_param_recs )
DELETE FROM CTE ...
(New to SQL Server)
Oracle and SQLite documentation gives SQL syntax in form of diagrams, for example:
SELECT in SQLite http://sqlite.org/lang_select.html vs SELECT in SQL Server http://technet.microsoft.com/en-us/library/ms189499.aspx
Diagrams are way easier to read, so why SQL Server syntax i...
