With exciting products like SQL Clone making their debut, the DBA will need to think through the approach to implementing such powerful tools. Done properly, these tools will provide a massive benefit to both the DBA and developer.
2019-05-10 (first published: 2017-11-28)
3,922 reads
EXEC SP_SPACEUSED can return only one result set if you want it to. This is possible using a new parameter in SQL Server 2016. If are familiar with the inbuilt stored procedure sp_spaceused, I am sure you will find this new parameter quite useful.
2016-11-30
2,001 reads
as a general rule of thumb, the more drives you can stripe your files accross the better your performance will be. Since in the first scenario your database files will be mirrored you are actually only using one drive for performance. The second scenario will give better performance.
2005-02-24
Thanks ! for the info. I'll pass anything I learn new along here.
2004-12-06
OH! You can script a view, and get the source columns/tables that way. In Enterprise Manager, right click, all tasks, generate SQL script. Click "Show All", select your view from the list and click Add. Then click Preview to see the script. Or in Query Analyzer Object Browser, right click and script to new window. Steveedit... […]
2004-11-22
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
I recently received a complaint that Query Store for a particular database was turned...
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