2011-08-31 (first published: 2011-08-24)
2,361 reads
2011-08-31 (first published: 2011-08-24)
2,361 reads
Lists all the tables in a database that do not contain any LOB columns(text, ntext, image, varchar (max), nvarchar (max), varbinary (max) and xml).
Useful when rebuilding indexes online.
2011-08-30 (first published: 2011-08-25)
741 reads
2011-08-24 (first published: 2011-08-12)
987 reads
A query tem o objetivo de consultar o status do usuario AD via Management Studio.
2011-08-22
393 reads
Script tem o objetivo de encontrar login com a role SysAdmin e informar seu status.
2011-08-22
213 reads
2011-08-18 (first published: 2011-08-04)
1,100 reads
Sometimes logging onto a box for a simple change like this is not possible for the business. This allows you to change this directly from T-SQL without having to log on or RDP into the box.
2011-08-17 (first published: 2011-07-28)
444 reads
This script quick tip for those who will accurately monitor sessions on SQL Server.
2011-08-16 (first published: 2011-08-02)
1,641 reads
SQL Script to Open DTC for distributed transactions and also configure SQL Server for Distributed Transactions.
2011-08-12 (first published: 2011-08-03)
714 reads
This gives you info about blocking, head blocker,wait_type, duration of the queries that are currently running
2011-08-11 (first published: 2011-08-04)
2,222 reads
By Steve Jones
A customer recently wanted to know if any of their instances were too old...
A reader of one of my previous posts pointed out that the legend order...
Please, let me reiterate: The only valid test of a backup is a restore....
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