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 140866

A database system optimised for reporting, particularly in aggregate. Often, but not always implemented using a star schema.

1
vote
Can you have your cake and eat it, too? nope. But there are some things you can do. I've worked with this EHR software called Nextgen. It has an OLTP database that never deletes/archives any data, …
answered Jun 1 '18 by James
0
votes
You can use a cursor driven from sys.databases to get the fully qualified table names, then union them all like this: declare @db varchar(255), @table varchar(255), @sql nvarchar(max) …
answered Sep 10 '18 by James
2
votes
1answer
We are expanding our data warehouse to include a new source system. In the new system, we want a single column for a primary key, but in the old system it's two columns. For exmaple: create table #n …
asked Dec 12 '19 by James