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 answers only user 126936

'Extract, Transform and Load': Data load processing, normally in the context of data warehouse systems.

0
votes
The reporting DB no longer contains data but only views that replicate the structure of the tables in the data repo. During a rebuild of the "data repo" database the "reporting db" is set offline …
answered Jun 4 by David Browne - Microsoft
2
votes
In SQL Server with Table and Index Compression (Row, Page or Columnstore) NVarchar columns don't use two bytes per character. They use Unicode Compression. Here's an example: use master go drop da …
answered Dec 16 '17 by David Browne - Microsoft
3
votes
if I have to access same table multiple time in the stored procedure is it a good idea to load the data in temp table and access it rather than the original table? It sometimes is. It is a commo …
answered Oct 3 by David Browne - Microsoft
6
votes
You can probably improve the performance, and perhaps the scalability of all the .NET approaches by pooling and caching any objects created in the function call. EG for Paul White's code above: stat …
answered Feb 8 by David Browne - Microsoft