SELECT name, SCHEMA_NAME(schema_id) AS schema_name, type_desc, type FROM sys.objects WHERE parent_object_id = (OBJECT_ID('dbo.tblXXXXX')) ORDER BY name; Object type: AF = Aggregate function (CLR) C = CHECK constraint D = DEFAULT (constraint or stand-alone) F = FOREIGN KEY constraint FN = SQL scalar function FS = Assembly (CLR) scalar-function FT = Assembly (CLR) table-valued function IF... » read more
Extended properties can be all sorts of annotations added about an object. They can be added manually, or by a tool. The extended properties has no effect on queries accessing the object. For specifying extended properties, the objects in a SQL Server database are classified into three levels: 0, 1, and 2. Level 0 is... » read more
SELECT name, SCHEMA_NAME(schema_id) AS schema_name, type_desc , type FROM sys.objects WHERE parent_object_id = (OBJECT_ID(‘dbo.tblXXXX’)) AND type IN (‘C’,’F’,’PK’,’D’, ‘UQ’) order by name; GO
Partitioning is the database process where very large tables are divided into multiple smaller parts. By splitting a large table into smaller, individual tables, queries that access only a fraction of the data can run faster because there is less data to scan. The main of goal of partitioning is to aid in maintenance of... » read more
Need to install SQL Server Data Tools (SSDT) for Visual Studio. https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-2017
By default, Google mail server will deny sending email from their servers. To enable additional host/application to send email you must add additional host/application records to the routing email section. If you try to send an email from your application without setting this up, you will get the following error message: “5.7.1 Invalid credentials for... » read more
Nameservers Setup Change the default from… ns1.mydomaincom-default.domainparkingserver.net ns2.mydomaincom-default.domainparkingserver.net to… ns1.mydomain.com ns2.mydomain.com Otherwise Azure Portal will not be able to confirm your domain name. DNS Records Add the following DNS Records… Record Name Content A * xx.xx.xx.xx A @ xx.xx.xx.xx A www xx.xx.xx.xx CNAME www xx.azurewebsites.net TXT A xx.azurewebsites.net
MongoDB is a free and open-source cross-platform document-oriented database program. Classified as a NoSQL database program, MongoDB uses JSON-like documents with schemata. MongoDB is developed by MongoDB Inc., and is published under a combination of the Server Side Public License and the Apache License. Wikipedia https://www.mongodb.com/ MongoDB AtlasGlobal Cloud Database Deploy, operate, and scale a MongoDB... » read more
Use the Feature Selection page of the SQL Server Installation Wizard to select the components to include in an installation of SQL Server. By default, none of the features in the tree are selected. Use the information in the following tables to determine the set of features that best fits your needs. Server components Description... » read more