How to Drop All Your Indexes – Fast
You probably shouldn't be doing this, but if you need to, Brent Ozar has a script for that.
2017-09-18
4,758 reads
You probably shouldn't be doing this, but if you need to, Brent Ozar has a script for that.
2017-09-18
4,758 reads
The stored procedure sp_DropDatabaseObject is designed to easily drop a variety of database objects with extensive feedback to the user
2010-05-26 (first published: 2009-04-21)
1,453 reads
Take a look at the SQL Server Health and History tool. It collects event log data into a repository database.
2005-02-14
I've never done it before but the first idea that comes to mind is as follows: create table tHyperlinkedTerms (hyperLinkedTermsId int IDENTITY, keyword varchar(100), description varchar(4000)) create table tGlossary (glossaryId int IDENTITY, keyword varchar(100), description varchar(4000)) -- a n to m match on this table where n<=m or m<=n -- with foreign keys pointing back […]
2003-06-16
1) You won't. Microsoft has chosen not to document all of the extended stored procedures in the environment. Researchers like Alex Chigrik have written some articles covering undocumented extended stored procedures, but I don't believe any article covers 100% of the extended stored procedures. 2) Not without some tricks, no. People have done this using […]
2003-06-16
By Rob Sewell
In the WordPress community, badges aren’t just for scouts.
By James Serra
The new data governance features in Microsoft Purview are now being made generally available...
Sometimes your Microsoft Entra ID account (formerly known as Azure Active Directory) is added...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers