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 71840

SQL Server 2008 R2 (major build version 10.50.xxxx). Please also tag with sql-server.

2
votes
There is an excellent blog post http://blogs.msdn.com/b/support_sql_france/archive/2012/02/07/sql-server-compilation-gateways-and-resource-semaphore-query-compile.aspx that explains what's happening. …
answered Feb 4 '16 by paulbarbin
1
vote
The engine stores the data in the DMVs for example, this query shows the batch requests per second. However, it stores just a cumulative number. You'd have to poll and record the values in another t …
answered Jan 22 '16 by paulbarbin
1
vote
You should break the quantity ordered into two columns or at least one integer column (but I like two). MinQuantity and MaxQuantity. Note I don't usually allow for abbreviations in tables or columns …
answered Apr 6 '17 by paulbarbin
1
vote
Select * from sys.traces where id = 1. This is the default trace. SQL Server Built-In Traces
answered Aug 28 '18 by paulbarbin
3
votes
You are correct, the only way to "rearrange" the order of the columns is to create a table with the new structure and push the old data into it, drop the old table and then rename the new table (or so …
answered Feb 2 '16 by paulbarbin
3
votes
You could try Pivot: I think you'll need to order on some key that ties these records together (how do you know that the starttime of "TESR" is related to the EndTime of "TESR". That probably needs …
answered Aug 14 '15 by paulbarbin
1
vote
I doubt seriously that the entire deployment happens in one batch and therefore variables wouldn't persist throughout the deploy (but you could test it). What I think makes more sense is to just stor …
answered Feb 2 '16 by paulbarbin