Using SQL Server and R Services for analyzing DBA Tasks
Article shows how R Services can help database administrators with their daily work
2019-02-22 (first published: 2017-02-07)
2,700 reads
Database growth
Identify SQL Server Database Growth Rates
Unchecked SQL Server database growth can hurt the bottom line of organizations in the form of poor application performance and increased infrastructure costs. In this article, Marios Philippopoulos looks at whether there's an easy way to proactively obtain a recent list of the fastest-growing databases in a SQL Server instance using information captured by default in the database engine.
2015-08-26
3,923 reads
RE: Copy SP
INSERT INTO tbl2 (fname) SELECT fname FROM tbl1 WHERE ref#='123'Btw, the # sign isn't really good to be used as a column name. I have seen several threads here, where this caused more or less severe problems.
2004-12-16
RE: Licensing
I prefer per processor licensing, just easier to manage. I believe they require you to license all physical processors if you go that route. If they are hyper threaded - where one chip looks like two - you only need one license per physical chip regardless how it appears to the OS.
2004-08-05
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