SQL Server unpredictable select results (dbms error?)
sql-server-2012 sql-server-2008
Ryszard Bocian Ryszard Bocian
7 >*Are we doing something wrong or is it SQL Server error?*
Paul White
Ignore accents in 'where'
sql-server-2008
lumo lumo
2 This problem can be solved using [accent insensitive collations](https://msdn.microsoft.com/en-us/library/ms144250(v=sql.105).aspx).
Tom V
Shared Lock issued on IsolationLevel.ReadUncommitted
sql-server-2008
dsum dsum
3 > What is HOBT lock?
Martin Smith
Can SQL Server create collisions in system generated constraint names?
sql-server-2014 sql-server-2008
jl6 jl6
4 > Can SQL Server create collisions in system generated constraint names?
Martin Smith
2 >Assuming I have 100 million tables, I calculate less than a 1-in-1-trillion chance of a collision
david browne microsoft
Return a column per date in a range
sql-server-2008
Federico Giust Federico Giust
7 You can use the `PIVOT` function to perform this query. My answer will include both a *static* and a *dynamic* version because sometimes it is easier to understand it using a static version.
taryn
5 I'm old school, and find `CASE` easier to work out in my head than `PIVOT`. I'm sure bluefeet will show up shortly and put me to shame, but in the meantime you can play with this dynamic SQL query. Assuming your table stores `DATE` and not `DATETIME` (or even worse, `VARCHAR`):
aaron bertrand
Index on Persisted Computed column needs key lookup to get columns in the computed expression
sql-server-2008
GarethD GarethD
5 Although this might be a bit of a co-incidence due to the artificial nature of your test data, being as you mentioned SQL 2012 I tried a rewrite:
wBob
2 >*Why is a Key Lookup required to get A, B and C when they are not referenced in the query at all? I assume they are being used to calculate Comp, but why?*
Paul White
Intermittent “Conversion failed…” error
sql-server-2008
jsc jsc
2 Your intermittent errors probably stem from the explicit `CAST` conversions that you're performing, combined with the `WHERE` filters. For any given query, SQL Server will create an execution plan, which you can think of as a roadmap of operations in a given order. The execution plan for any query can often vary in a number of ways, and SQL Server tries to choose the plan that will be the most efficient for every particular scenario. In this choice, lots of factors will influence how the plan is generated.
daniel hutmacher
UPDATE statement processing records that should be eliminated by WHERE clause
sql-server-2008
James James
4 You should not make any assumptions about how SQL Server ***will*** process your query, except this: you should always assume that SQL Server ***can*** process your query in a way that is different from how it is explicitly written on the screen. And also this behavior can change based on any of the factors that can influence whether a new plan will be used for the next execution of even the same query, so if you apply a hint or change the query in any way or add or remove an index and the error goes away, don't assume the error won't come back tomorrow.
aaron bertrand
Insert multiple rows into a table with only an IDENTITY column
sql-server-2008
Andriy M Andriy M
3 As of writing this, there is no way to insert multiple rows into just an `IDENTITY` column using an `INSERT` statement. The `DEFAULT VALUES` placeholder stands for just one row. And the `INSERT ... SELECT` syntax has no extension to support the same functionality as the `DEFAULT VALUES` clause.
Andriy M
When is the SQL Server database ready to accept queries?
sql-server-2008
ahmed ahmed
2 The SQL Server database is ready to accept queries as soon as:
Paul White
chat
transcript

Enter question or answer id or url (and optionally further answer ids/urls from the same question) from

Separate each id/url with a space. No need to list your own answers; they will be imported automatically.