Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Adding Hyperlink value in a column by giving another Column value as inputAdvantages and disadvantages of using Foreign KeysAdvantages/Disadvantages of using an Identity column in a table as Primary KeyAdventure works database in Microsoft Access FileAlias CNAME for SQL AlwaysON Listenerattempt to fetch logical page (4:16277272) in database 5 failed . it belongs to allocation unit 720586415830784 to 72058643040436224Backup to UNC pathBeginner question: Check constraint for Email AddressCan 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 groupCan't open Trace filesCannot Access databaseCardinality 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 columncolumn exceeds the maxLength limitComposite PRIMARY KEY when one of the COLUMNS can be NULLComposite Unique Key on multiple columns- Best PracticesComputed column specification DATETIME to DATEConditional Foreign Key?Converting to table in 3NFCould not insert a backup or restore history/detail record in the msdb database. problem with the msdb databaseCreate a view order by error The ORDER BY clause is invalid in viewsData Type for numeric(18,4)database design for better solution for approval heirarchyDatabase Name with dot/period "."Database project: how to resolve circular dependency when databases reference each otherDatabase with categories/subcategoriesDatetime Field in Composite Primary KeyDB 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 loggedDynamic Translation of language in MS SQL ServerEF6 Model First: schema specified is not valid, error 0040Error 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 2012Error while Creating a table in Sql server managment studioerror while importing data from excel using sql server import and export wizardError: 18456, Severity: 14, State: 38.execute statement inside a common table expressionFind query execution count in certain time periodForeign Key referencing non unique field in SQL ServerGreek characters in SQL Server tablesHigh buffer IO on Activity monitorHigh fragmentation and primary keyHigh MEMORYCLERK_SQLQERESERVATIONSin SQL ServerHow 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 databasehow to change the ordinal position in sql serverHow to convert this Oracle REGEXP_SUBSTR to SQL Serverhow to create a foreign key relationship in computed columns?HOW TO CREATE SALARY TABLE WITH BASIC,HRA,DA,CA,PFHow to Delete recursively from a hierarchical tablehow to design database for family tree,retrieve and displayHow to find which stored procedure not used in last 3 monthsHow to generate script with only 5 rows in tableHow to identify the level of core licensing of a particular installed SQL Server Enterprise Edition?How to identify when is index created or droppedHow to improve performance of a table that does not have a Primary keyhow to insert new row between rows in sql serverhow to open Port 1433 in SQL Server docker container ?How to partition a table on a non primary key fieldhow to remove alphanumeric characters from numeric valueHow to retrieve table schema using SQL ServerHow 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 tableHow to use local time for the system period time in Temporal tables? (System-Versioned)How to use Offset . . .Fetch Next in SQL SERVER 2008 R2Identify Column as Primary Key with Foreign Keys Referencing itIdentity without auto incrementignore case sensitive when we do inner joinImpact 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 databasesIs there a way to create a database from a JSON schema?Is varchar(MAX) always preferable?Json OutPut TruncationLarge MDF files whether to reduceLCK_M_S locks are matter to considerLinked Server Query KILLLogin/Logout and Login Count logic in SQL ServerMaximum number of partitions allowed in SQL serverMS SQL Identity auto increments even on insert failuresMsSQL Auto increment Alphanumeric IT001, IT002MSSQL Datatype for storing large size textMultiple tables with same primary keyndf file which we use for index getting full and shrink doesn't helpNTFS Allocation size MS official recommendation for SQL 2017ODBC Error(-1): #08S02 - [Microsoft][SQL Server Native Client 11.0]SMux Provider: Physical connection is not usableOperand data type varchar is invalid for divide operator?OVER (PARTITION BY ORDER BY ) SHOWING SYNTAX ERRORPoint of Sale (POS) Database schema (diagram)Primary key identity column skipping numbersPros and cons of using schemas in general and in SQL Server 2008 or 2012Remote 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 problemSQL AdventureWorks Stored ProcedureSQL Agent WarningSql database design best practice and naming standards.SQL Named Instances TCP PortsSQl Server 2014 express edition unable to start SQL Agent jobSQL Server application error ntdll.dllSQL Server Best Practices - NTFS Allocation Unit Size 64 KBSQL SERVER error 80040e57'SQL Server map network drive for backupSQL Server Naming ConventionSQL server performance for tables having large number of columnssql server stoped automatically.SQL Server View not updatingSSMS is getting crashed whenever trying to edit tableStorage space used by null/blank VARCHAR fields?Storing Base64 data in SQL ServerStoring enum or 'status' values in databaseSystem.Data.Odbc.OdbcException (0x80131937): ERROR [HYT00] [Microsoft][SQL Server]Query timeout expiredTable Names with dotstable space in mssqlTables fragmentation over 70% and page count over 1000The Bible in a SQL Service-based DatabaseThe data types text and varchar are incompatible in the add operator.The OLE DB provider "Microsoft.ACE.OLEDB.12.0" has not been registeredThe 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 timeThe operating system returned error 38(Reached the end of the file.) to SQL Server during a read at offset 0x000001f3400000 in fileThis 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 exceededTransaction replication create publication Invalid object name dbo.syspublicationsTruncate not workingUnderscore in Database NameUPDATE Varbinary(max) to NULL cannot reclaim spaceURGENT !!! 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 keyWhat is the usage of RowGUID in sql server?Which data type is used to store RTF DataWhich 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