Outlier Detection with SQL Server, part 3.3: The Limitations of the Tietjen-Moore Test
By Steve Bolton
…………The Tietjen-Moore test may have the coolest-soundest name of any of the outlier detection methods I’ll be surveying...
2015-01-20
1,299 reads
By Steve Bolton
…………The Tietjen-Moore test may have the coolest-soundest name of any of the outlier detection methods I’ll be surveying...
2015-01-20
1,299 reads
One of the important task of any DBA is to find out all the jobs which are failed yesterday. Below...
2015-01-20
2,479 reads
Sometimes we need to find out how many stored procedures contains a given text. Below SQL query can be used...
2015-01-20
683 reads
Below is the SQL query which can be used to find out the tables which are created or modified on...
2015-01-20
671 reads
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2015-01-28 (first published: 2015-01-20)
6,941 reads
Sometimes we need to find out the size of the database on a server. Below SQL Scripts can be used...
2015-01-20
617 reads
As we know, this Windows policy Lock Pages in Memory option determines which accounts can use a process to keep data in physical memory, preventing the Windows operating system from paging...
2015-01-20
21 reads
As we know, this Windows policy Lock Pages in Memory option determines which accounts can use a process to keep data in...
2015-01-20
2,007 reads
I have recently seen some “bad plans” being generated by the optimiser and from investigation, the cause came down to...
2015-01-20
1,744 reads
Over this past weekend, SQL MVP Kalen Delaney sent an inspiring note to the MVP email thread, and I wanted to...
2015-01-20
1,977 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
This week I was at PASS Data Community Summit in Seattle, and I attended...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Comments posted to this topic are about the item Server-level Roles
Comments posted to this topic are about the item Pay for Performance
Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...
In SQL Server 2025, can I alter a fixed server role?
See possible answers