All Questions
Tagged with sql-server database-design
876
questions
-1
votes
0
answers
48
views
Best Practices for Migrating 2TB MSSQL Databases with High Availability to PostgreSQL
I'm planning to migrate a large-scale MSSQL environment to PostgreSQL and would appreciate some advice and best practices. Here are the details of our current setup:
Current Environment:
Two servers ...
-1
votes
1
answer
33
views
SQL Server Management Studio "Key cannot be null" error when giving a specific user permissions on Stored Procedures
I'm attempting to give a specific user execute permissions on a Stored Procedure. When I attempt to do so, I get an error:
Key cannot be null. Parameter name: key (System)"
When I attempt to ...
2
votes
2
answers
195
views
Transactional Replication - how to set up alerts/notification to send alerts before transaction log space is full on a Publisher?
I am setting up transactional replication on my 2008R2 server to 2012 distribution server to 2012 Subscriber server. All the three servers are on FULL recovery mode. Log backup is taken every 15 ...
0
votes
1
answer
32
views
Question related to Database Design in SQL Server
I have two tables: Products and ProductVersions. The table structures are as follows:
Products Table:
ProductId
RegionId
ActiveProductVersionId
isDisabled
ApplicationId
ProductVersions Table:
...
0
votes
1
answer
48
views
Setting up Transactional Replication - Can i safely remove transactional replication if it is causing issues on my publisher?
Please excuse me if I am not making very much sense here. I am very new to replication and have been researching for quite some time about transactional replication to implement in our scenario..
I am ...
0
votes
1
answer
63
views
How to implement an "Apple or Orange but not both" constraint
A database schema design question:
Suppose I want to design a database with Robots, Technicians and Sites.
I want to use my database constraints to limit the data to prevent entering some nonsensical ...
-1
votes
1
answer
50
views
Customer Address Design Probelm
I'm designing a database for E-commercial. So the Customer have many address also 1 address also has many customers owned so I have another CustomerAddress table (many-to-many relation). Here detail :
...
0
votes
0
answers
54
views
Sql Server migration from old server to new very slow SQLEXPRESS
Hope someone can assist me. I think I might know what the problem is but this is not really resolving the issue and was wondering if it is even a valid conclusion. I am not a Guru at all with SQL.
...
1
vote
3
answers
93
views
Enforce uniqueness on combination of columns + aggregate function
I have a SQL Server database with the following tables:
CREATE TABLE [dbo].[Rule]
(
[RuleId] [int] IDENTITY(1,1) NOT NULL,
[Value1] [int] NOT NULL,
[Value2] [int] NOT ...
0
votes
3
answers
170
views
How can a column's data type be safely reduced from NVARCHAR(max)?
My biggest table owes most of its size to a stupid NVARCHAR(max) column that I wager could easily be NVARCHAR(4000) or smaller. What steps can I take to become confident that this change is safe to ...
0
votes
1
answer
381
views
How to calculate MAX server memory and MIN server memory?
There is a total of 10GB of RAM. I want to set MAX server memory and MIN server memory for SQL Server. How do I set this? Would 20% of the total RAM for the MIN value and 80% of the total RAM for the ...
-1
votes
1
answer
147
views
Optimizing Negative Int/BigInt Ranges in SQL Server: Strategies and Benefits
I am currently delving into the potential applications and advantages of utilizing the negative range of the int or bigint data types within SQL Server, with a particular focus on the range extending ...
0
votes
0
answers
44
views
copying data from database with the same skeleton
I have a database design with the same tables, procedures and all other details on two different servers. Since one of them ran out of traffic, I forwarded the web software project to the other one.
I ...
0
votes
1
answer
77
views
SQL Server using table's Primary Key as part of Foreign Key
The situation is I have a Tenant table, and a tenant based status lookup table. Each with their own autonumber Primary keys.
Now I want to add a column to the Tenant table for a default Status that ...
1
vote
1
answer
92
views
Table filtered for multiple column: eav support table can be the best solution for search performance improvement?
I have a table with 10~15 columns (some varchar, some int, some double, and some date). Table can contain tens of millions of records.
User can filter from all columns using all filter operator (equal,...