SQL Server Worker Thread Alert
We decided to build a quick worker thread alert so we know when we are near the limits.
2019-05-02
658 reads
Scripts
Add working days but avoid holidays
A function to add or subtract working days taking into account weekends and using a table of non-working days.
2019-05-01
722 reads
2019-04-30
1,065 reads
Add working days but avoid holidays
A function to add or subtract working days taking into account weekends and using a table of non-working days.
2019-04-25 (first published: 2019-04-18)
579 reads
SQL Server System Audit Report
SQL Server System Audit Report Rudy Panigas, 2018-05-25 (first published: 2016-02-02) With every technology, security is in the forefront of the minds of professionals around the world. Ensuring that your SQL Server is secure is the job of every Database Administrator (DBA). The DBA(s) needs to configure the system to minimize the “attack surface” (reducing […]
2019-04-18
571 reads
2019-04-16 (first published: 2019-04-12)
1,610 reads
Function to convert UserAccountControl number to details text
Function that converts AD UserAccountControl number to details text
2019-04-15 (first published: 2019-04-12)
315 reads
DigitsOnlyEE and AlphaNumericOnly
A nasty fast way to remove non-numeric and non-alphanumeric characters from a string
2019-03-15 (first published: 2016-05-17)
1,266 reads
2019-02-27 (first published: 2019-02-20)
290 reads
Disable or rebuild all nonclustered indexes on a table
Can be useful when inserting a lot of data into a table.
2019-02-26 (first published: 2019-02-14)
694 reads
Blogs
SQL Server 2008 and 2008 R2 is end of life on 9 July 2019
Next month, Microsoft is ending five years of extended support on SQL Server 2008...
Understanding Columnstore Indexes in SQL Server Part 1
Recently I reviewed filtered indexes, this time let’s look at columnstore indexes. These indexes...
Basic User Functions in R
By Steve Jones
As I’ve been learning more about the data platform, I’ve been exposed to some...
Forums
Compare Dates
Hello All, create table #app1 ( custID INT, Seqs INT, eff_dt datetime, term_dt datetime...
StoredProc insert and update multiuser issue
Happy to day to all, I am looking into an issue with a stored...
New to SQL - difficulties in SUMing only certain rows of a column, other misc.
This is for SQL Server 8.0 and I'm using MySQL Workbench on this. ...
Ask SSC