Its possible to use some comparable expressions to a full regular expression library for matching certain patterns with T-SQL using the like operator. This tutorial uses these expressions for filtering price phrases involving alphabetic, numeric, and special characters
2018-06-14
4,713 reads
This article shows four ways you can use when installing missing R packages for Microsoft R Services.
2019-02-01 (first published: 2016-09-29)
4,770 reads
I agree - I have a hard time imagining that 15 minute backups of a tlog are unusual. However there does seem to be a direct correlation between the increase in frequency and the increase in application 'hangs'. Even more to the point, the times of the application hangs often correspond with the kickoff of […]
2005-04-29
Colin is attempting to provide help. Questions are not always clear as to their intent, giving more information rather than less helps other to help you. Colin is just trying to get that information to be of greater assistance. Berating him for that is pointless and ridiculous.
2005-04-28
There is no performance difference HOWEVER, there are differences for how many concurrent connections there are. PER SEAT = n Connections (basically HIGH LEVEL concept), PER PROCESSOR = n CPUs and INFINITE connections (Again HIGH LEVEL concept). The amount of connections is firmly dependent on system resources (but that is for a different topic).....The internal […]
2005-04-27
Its easy if you script it! We take log backups every 15 minutes. 95 log backups in a single day (skip the time that the full starts). So, manual restores are NOT something that I want to do! I wrote a procedure that creates the restore statements for me. Give it a database name, start time, […]
2005-04-08
Hi Steve,we do monitor all the servers with CA TNG Unicenter. That work perfectly by the way. So the DBA-on-24/7-call guy gets the call when something happens to one of the servers and takes care of business.What we really would like is make checking the jobs and logs quicker. Now it takes quite some time to surf […]
2004-11-10
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