Database Design

• Adding Hyperlink value in a column by giving another Column value as input
• Advantages and disadvantages of using Foreign Keys
• Advantages/Disadvantages of using an Identity column in a table as Primary Key
• Adventure works database in Microsoft Access File
• Alias CNAME for SQL AlwaysON Listener
• attempt to fetch logical page (4:16277272) in database 5 failed . it belongs to allocation unit 720586415830784 to 72058643040436224
• Backup to UNC path
• Beginner question: Check constraint for Email Address
• Can a column name contain a subscript?
• Can we get the number of hits to a database in sql server ???
• can we remove Memory Optimized file group
• Can't open Trace files
• Cannot Access database
• Cardinality vs multiplicity?
• Characters that are not allowed in table name & column name in sql server ?
• Checkdb found 6 allocation errors , how to fix ?
• Clustered index in VARCHAR column
• column exceeds the maxLength limit
• Composite PRIMARY KEY when one of the COLUMNS can be NULL
• Composite Unique Key on multiple columns- Best Practices
• Computed column specification DATETIME to DATE
• Conditional Foreign Key?
• Converting to table in 3NF
• Could not insert a backup or restore history/detail record in the msdb database. problem with the msdb database
• Create a view order by error The ORDER BY clause is invalid in views
• Data Type for numeric(18,4)
• database design for better solution for approval heirarchy
• Database Name with dot/period "."
• Database project: how to resolve circular dependency when databases reference each other
• Database with categories/subcategories
• Datetime Field in Composite Primary Key
• DB role unable to delete-The database principal owns a schema in the database, and cannot be dropped.
• dbo.Schema.Table vs Schema.Table - Is there a difference?
• difference between delete and truncate in space of data and logged
• Dynamic Translation of language in MS SQL Server
• EF6 Model First: schema specified is not valid, error 0040
• Error 1827: CREATE/ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 2048 MB per database.
• error 41105 while working with Always on in sql 2012
• Error while Creating a table in Sql server managment studio
• error while importing data from excel using sql server import and export wizard
• Error: 18456, Severity: 14, State: 38.
• execute statement inside a common table expression
• Find query execution count in certain time period
• Foreign Key referencing non unique field in SQL Server
• Greek characters in SQL Server tables
• High buffer IO on Activity monitor
• High fragmentation and primary key
• High MEMORYCLERK_SQLQERESERVATIONSin SQL Server
• How can I generate a script to choose only top 10 items from each table in SQL database?
• How can I see the relationship of tables in Microsoft SQL Server?
• How do i create a Supertype substype relationship in SQL?
• How do I define a boolean checkbox in an SQL field datatype?
• How many bytes use a varchar? Depends on the intercalation?
• How many Schemas can be used in a database
• how to change the ordinal position in sql server
• How to convert this Oracle REGEXP_SUBSTR to SQL Server
• how to create a foreign key relationship in computed columns?
• HOW TO CREATE SALARY TABLE WITH BASIC,HRA,DA,CA,PF
• How to Delete recursively from a hierarchical table
• how to design database for family tree,retrieve and display
• How to find which stored procedure not used in last 3 months
• How to generate script with only 5 rows in table
• How to identify the level of core licensing of a particular installed SQL Server Enterprise Edition?
• How to identify when is index created or dropped
• How to improve performance of a table that does not have a Primary key
• how to insert new row between rows in sql server
• how to open Port 1433 in SQL Server docker container ?
• How to partition a table on a non primary key field
• how to remove alphanumeric characters from numeric value
• How to retrieve table schema using SQL Server
• How to store arrays in MS SQl server table cell?
• How to update last record by a trigger?
• How to update parent table identity column values in child table
• How to use local time for the system period time in Temporal tables? (System-Versioned)
• How to use Offset . . .Fetch Next in SQL SERVER 2008 R2
• Identify Column as Primary Key with Foreign Keys Referencing it
• Identity without auto increment
• ignore case sensitive when we do inner join
• Impact of define varchar(20) vs varchar(100)
• Index Size greater than Data size?
• INSERT INTO TABLE (WITH NO LOGGING)
• Invalid object name 'SYS.EXTENDED_PROPERTIES' on binary collated databases
• Is there a way to create a database from a JSON schema?
• Is varchar(MAX) always preferable?
• Json OutPut Truncation
• Large MDF files whether to reduce
• LCK_M_S locks are matter to consider
• Linked Server Query KILL
• Login/Logout and Login Count logic in SQL Server
• Maximum number of partitions allowed in SQL server
• MS SQL Identity auto increments even on insert failures
• MsSQL Auto increment Alphanumeric IT001, IT002
• MSSQL Datatype for storing large size text
• Multiple tables with same primary key
• ndf file which we use for index getting full and shrink doesn't help
• NTFS Allocation size MS official recommendation for SQL 2017
• ODBC Error(-1): #08S02 - [Microsoft][SQL Server Native Client 11.0]SMux Provider: Physical connection is not usable
• Operand data type varchar is invalid for divide operator?
• OVER (PARTITION BY ORDER BY ) SHOWING SYNTAX ERROR
• Point of Sale (POS) Database schema (diagram)
• Primary key identity column skipping numbers
• Pros and cons of using schemas in general and in SQL Server 2008 or 2012
• Remote connection to a SQL Server instance using an alias.
• Restoring Single file group on another server is showing other file groups in restoring mode with LSN related error.
• SELECT failed because the following SET options have incorrect settings: 'ANSI_NULLS, QUOTED_IDENTIFIER, ANSI_PADDING'.
• Severe error condition that threatens database integrity and must be corrected immediately.
• Should I use varchar(<n>) or varchar(MAX) ?
• shrink log file have problem
• SQL AdventureWorks Stored Procedure
• SQL Agent Warning
• Sql database design best practice and naming standards.
• SQL Named Instances TCP Ports
• SQl Server 2014 express edition unable to start SQL Agent job
• SQL Server application error ntdll.dll
• SQL Server Best Practices - NTFS Allocation Unit Size 64 KB
• SQL SERVER error 80040e57'
• SQL Server map network drive for backup
• SQL Server Naming Convention
• SQL server performance for tables having large number of columns
• sql server stoped automatically.
• SQL Server View not updating
• SSMS is getting crashed whenever trying to edit table
• Storage space used by null/blank VARCHAR fields?
• Storing Base64 data in SQL Server
• Storing enum or 'status' values in database
• System.Data.Odbc.OdbcException (0x80131937): ERROR [HYT00] [Microsoft][SQL Server]Query timeout expired
• Table Names with dots
• table space in mssql
• Tables fragmentation over 70% and page count over 1000
• The Bible in a SQL Service-based Database
• The data types text and varchar are incompatible in the add operator.
• The OLE DB provider "Microsoft.ACE.OLEDB.12.0" has not been registered
• The OLE DB provider "OraOLEDB.Oracle" for linked server supplied inconsistent metadata for a column. The column (compile-time ordinal 1) of object was reported to have a "DBCOLUMNFLAGS_ISFIXEDLENGTH" of 16 at compile time and 0 at run time
• The operating system returned error 38(Reached the end of the file.) to SQL Server during a read at offset 0x000001f3400000 in file
• This backend version is not supported to design database diagrams or tables. (MS Visual Database Tools)
• Threshold for the Memory\Pages\sec performance counter has been exceeded
• Transaction replication create publication Invalid object name dbo.syspublications
• Truncate not working
• Underscore in Database Name
• UPDATE Varbinary(max) to NULL cannot reclaim space
• URGENT !!! Cannot use TEXTIMAGE_ON when a table has no text, ntext, image, varchar(max), nvarchar(max)....
• what data type should I use to store URLs?
• What is the perfect data type to use as a primary key
• What is the usage of RowGUID in sql server?
• Which data type is used to store RTF Data
• Which data type store unit cost price and amount in sqlserver 2012?
• Why not to always use nvarchar(MAX)
• Work flow table design for dynamic approval