Podcast #128: We chat with Kent C Dodds about why he loves React and discuss what life was like in the dark days before Git. Listen now.
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 61

SQL Server 2012 (major build version 11.00.xxxx). Please also tag sql-server.

2
votes
Update: as Paul White mentions in a comment, it has been announced that SQL 2016 will support two-node alwayson groups via the limited "Basic AlwaysOn Group" feature. As Windows 2012 Standard edition …
answered Aug 25 '15 by David Spillett
3
votes
I want to display output like As a general rule display matters should not be handled in the database. The DB calls should return the data and aggregates & other amalgamations/calculations based …
answered Feb 8 by David Spillett
3
votes
Can the extensions be changed back without any conflict? Not while the database is active, but you can offline it, rename the files, then bring it back online: Check the virtual filenames as yo …
answered Oct 27 '15 by David Spillett
2
votes
That is about 7 requests per second if the rate is flat over the 24 hour period, which shouldn't have a noticeable impact on a decently specced SQL Server machine. If they are far more bunched then th …
answered Jul 27 '16 by David Spillett
3
votes
My first thought was: no, the whole row will get re-written whether you update one column or many, in both the log and data files. This should be true for simple un-indexed columns at least but there …
answered Feb 14 '18 by David Spillett
1
vote
"MSSQLSERVER" is just the default instance name, so is assumed if one is not specified. The instance name means nothing to SQL Server itself so you could have any edition of running as .\SQLEXPRESS if …
answered Feb 23 by David Spillett
1
vote
I suspect that lf_transit_cage.trayNo contains some NULL values, which causes problems for a NOT IN check but not an IN check. This is an issue that we've all hit at some point as it doesn't seem intu …
answered Dec 6 '17 by David Spillett
1
vote
SELECT INTO <table-decided-by-code> You can't dynamically set the destination table like that. If the target tables are part of a partition set partitioned on that column then SQL Server would do …
answered Mar 31 '17 by David Spillett
1
vote
As SP3 is the latest SQL Server 2012 "release" it follows the main product's support dates so drops out of its mainstream support on 2017-07-11, but from there it entered extended support so at very l …
answered Jun 1 '17 by David Spillett
0
votes
What you ate setting there is a parametrised insert or more generically use of a "prepared statement" (you will see select statements and others like this too). You might see more specific detail in t …
answered Jun 24 '14 by David Spillett
4
votes
You should be able to run separate instances of those versions on the same server without issue, though I usually recommend against doing that in production environments as I have experienced problems …
answered Mar 25 '13 by David Spillett
3
votes
It is trying to filter[1] by section_id but not quotation_id - it can't do this by seeking on an index on quotation_id,section_id so it will have to scan that index (which as it is your clustered inde …
answered May 31 '17 by David Spillett
1
vote
But it will only inserts the last inserted ID from the Query before. This is current as documented in https://docs.microsoft.com/en-us/sql/t-sql/functions/ident-current-transact-sql: Returns …
answered Feb 19 '18 by David Spillett
5
votes
For a start unless this was an absolute emergency you have done everything backwards: you should not make changes to production that have not been made in dev/test first to make sure they have the des …
answered Jun 28 '16 by David Spillett
0
votes
I've seen the query planner do similar things with index-less temporary tables, even sometimes when the number of rows in the temporary table is small. Try adding an index that covers the columns you …
answered Oct 30 '14 by David Spillett

15 30 50 per page