Return all partition table in the database. The following query returns one or more rows if the table PartitionTable is partitioned. If the table is not partitioned, no rows are returned. SELECT * FROM sys.tables AS t JOIN sys.indexes AS i ON t.[object_id] = i.[object_id] AND i.[type] IN (0,1) JOIN sys.partition_schemes ps ON i.data_space_id = ps.data_space_id... » read more
Get all Index for a table… EXEC sys.sp_helpindex @objname = N'tblXXXXX' Or query from the indexes system table… SELECT TableName = t.name, IndexName = ind.name, IndexId = ind.index_id, ind.* FROM sys.indexes ind INNER JOIN sys.tables t ON ind.object_id = t.object_id WHERE t.name = 'tblXXXXX' For those tables with multiple partitions… SELECT o.name objectname,i.name indexname, partition_id,... » read more
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