Tagged Questions
1
vote
1answer
60 views
Unique index for subquery with RANK() function
I have the following tables:
CREATE TABLE Revision (
RevisionId INT PRIMARY KEY IDENTITY,
UserName NVARCHAR(256) NOT NULL,
DateTime DATETIME NOT NULL DEFAULT GETDATE()
)
CREATE TABLE ...
1
vote
1answer
29 views
Adding users to a list and sort by category?
I'm using SQL-Server 2012 and I would like to know how to solve this program.
So:
I want to create a page that allows admins to manage a project, and part of it, would be to add members/employees to ...
4
votes
1answer
150 views
SQL Server database design for “archived but available” data
We have this large database (>1TB) that we intend to "shrink". The database revolves around one main entity, let's call it "Visit". For discussion, let's say it is a database for a medical practice.
...
1
vote
0answers
77 views
SSMS produces error if query returns too many rows
We are having an issue with a server that we linked to our sql server 2012 instance.
The server that we linked through an odbc or oledb connection is Pervasive SQL.
Selecting from the linked server ...
5
votes
3answers
1k views
Visio 2010 and SQL 2012 - Reverse Enginnering
We have upgraded to SQL 2012 and Am trying to reverse engineer our Dbs into Visio 2010. I setup a connecting using SQL 11 driver and Visio complains that that driver is not supported.
Any one run ...
1
vote
5answers
263 views
SQL Server - Database per company. How to query across databases?
We are designing a product that, as per the client's request, must utilize a database-per-company design approach with one shared database holding common data.
We are using SQL Server 2012 for the ...
