Avoid Transaction Logs volume from filling
Script for preventing the volumes of the transaction logs from filling.
2016-01-27 (first published: 2014-05-13)
3,487 reads
Full drive
RE: Question of the Day for 15 Apr 2004
In SQL Server there are two large categories of roles: database and server. The sysadmin role is a server role. While we can create user-defined database roles, server roles are fixed. The list of built-in roles: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_security_6ndx.asp
2004-04-15
RE: Changing Column Names in a Store Prosedure
Please first tell me. Are you currently using SQL Server Yukon? Here is the answer to your question with assumption of SQL2K in use.Create views with different date ranges. You should able to provide two different column names in the two different views. If you provide more details of what compell you to use different […]
2004-04-09
Blogs
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Query Store Keeps Switching Itself Off, Getting it Moving Again
I recently received a complaint that Query Store for a particular database was turned...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers