.NETADO.NETAgileAngularArchitectureASP.NETAuthenticationAzureAzure FunctionBIBig DataBlazorBusinessC#Cloud ServiceCosmosDBCSSDebuggingDesignEncryptionEntity FrameworkFYIGoogleHardwareInternetInterviewsJavascriptjQueryLeadershipLINQManagementMicrosoftMobileMS OfficeMS SQLNetworkingNoSQLOOPProject ManagementSoftware DevelopmentSource ControlSSISSSRSSyncfusionTeamTestingTSQLUncategorizedVendor SoftwareVisual StudioWebWeb ServicesWindowsWordPress
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