SQL Server

SQL Server

Nine Undocumented SQL Server 2014 Database Maintenance Plan Stored Procedures

by

Nine Undocumented SQL Server 2014 Database Maintenance Plan Stored Procedures SQL Server 2014 supports the following useful undocumented database maintenance plan stored procedures: sp_clear_dbmaintplan_by_db sp_maintplan_close_logentry sp_maintplan_delete_log sp_maintplan_delete_plan sp_maintplan_delete_subplan sp_maintplan_open_logentry sp_maintplan_start sp_maintplan_subplans_by_job sp_maintplan_update_subplan_tsx Note. These stored procedures exist in the msdb database, not in master. sp_clear_dbmaintplan_by_db The sp_clear_dbmaintplan_by_db database maintenance plan stored procedure is used to delete the maintenance plans, the […]

Continue Reading →
SQL Server

Overview of Database Management System (DBMS) – Part 4

by

Overview of Database Management System (DBMS) – Part 4 Assumed every advantages, now is there any reason for not using Database Management System (DBMS)? A Database Management System (DBMS) is a multifaceted part of software, improved for definite types of capabilities like – responding to compound requests otherwise controlling numerous simultaneous queries as well as its performance might not be […]

Continue Reading →
SQL Server

Can one person handle all the content marketing when starting your business?

by

Can One Person Handle All the Content Marketing When Starting Your Business? Career Management Series By Laura Lee Rose Hello, this is Laura Lee Rose – author of TimePeace: Making peace with time – and I am a business and efficiency coach that specializes in time management, project management and work-life balance strategies. I help busy professionals and entrepreneurs create […]

Continue Reading →
SQL Server

Partitioning relational and multidimensional data for OLAP solution (Part 1)

by

Partitioning relational and multidimensional data for OLAP solution – (Part – 1) The design of the relational database and all multidimensional structures will help to determine the performance of your overall solution. First introduced in SQL Server 2005, SQL Server partitioned tables features allow you to partition data in a table across multiple filegroups. Most often, the partitioning is used […]

Continue Reading →
SQL Server

Three Undocumented SQL Server 2014 Full-Text Search Stored Procedures

by

Three Undocumented SQL Server 2014 Full-Text Search Stored Procedures SQL Server 2014 supports the following three undocumented full-text search system stored procedures: sp_fulltext_recycle_crawl_log sp_MShelpfulltextindex sp_MShelpfulltextscript sp_fulltext_recycle_crawl_log The sp_fulltext_recycle_crawl_log system stored procedure is used to recycle crawl log for the given full-text catalog name. Syntax sp_fulltext_recycle_crawl_log [ @ftcat = ] ‘ftcat’ Arguments [ @ftcat = ] ‘ftcat’ Is the full-text catalog […]

Continue Reading →
SQL Server

Overview of Database Management System (DBMS) – Part 3

by

Overview of Database Management System (DBMS) – Part 3 Features of Database The Database Management System (DBMS) tactic has a number of distinguishing features which are discussed in details as follows:- 1. Simultaneous Use The database management system lets numerous end users to access the database simultaneously. Responding to dissimilar quires of the various end users with the identical information […]

Continue Reading →
SQL Server

Five undocumented SQL Server 2014 distributed queries stored procedures

by

Five undocumented SQL Server 2014 distributed queries stored procedures SQL Server 2014 supports the following five useful undocumented distributed queries stored procedures: – sp_catalogs_rowset – sp_catalogs_rowset2 – sp_catalogs_rowset_rmt – sp_linkedservers_rowset – sp_linkedservers_rowset2 sp_catalogs_rowset The sp_catalogs_rowset distributed queries stored procedure returns the database name for the specified database if the current user has access for this database. Syntax sp_catalogs_rowset [ @catalog_name […]

Continue Reading →
SQL Server

Undocumented SQL Server 2014 extended stored procedures (Part 2)

by

Undocumented SQL Server 2014 extended stored procedures (Part 2) In this article, you can find the description of some useful undocumented SQL Server 2014 extended stored procedures. xp_enum_oledb_providers This extended stored procedure can be used to get the list of all available OLE DB providers. It returns Provider Name, Parse Name and Provider Description. Syntax: EXECUTE xp_enum_oledb_providers To get a […]

Continue Reading →
1 … 63 64 65 66 67 … 115