2012-01-29
2 reads
Blog Posts
2012-01-29
2 reads
2012-01-29
2 reads
2012-01-29
2 reads
Find failed SQL jobs with powershell
This weekend I went to SQL Saturday in Auckland. It was nice to interact with other DBAs again. Kent Chenery...
2012-01-29
11,833 reads
Find Login in Active Directory
Find Login in AD
Many times we require to know if particular login is a part of ad user group. Or...
2012-01-29
853 reads
Rebuild System Databases
Yesterday night one of FB Friend have ping me, he has issue with his local SQL Server instance. Our conversation...
2012-01-29
3,236 reads
Creating merge replication conflict alerts
One of the challenges in working with Merge Replication is handling conflicts since writes can occur at any node in...
2012-01-28
1,513 reads
January #Meme15 Round-Up
The second round of #meme15 finished up last week and it’s time to see who participated. In total, there were...
2012-01-28
793 reads
Petitions on Change.org and Thoughts on Changing PASS
I tried this out – Change.org that is – recently as part of a post about PASS and wanted to post a...
2012-01-28
787 reads
Blogs
Free webinar – Tackling the Gaps and Islands Problem with T-SQL Window Functions
I’m hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM...
Counting Groups with Window Functions: #SQLNewBlogger
By Steve Jones
I looked at row_number() in a previous post. Now I want to build on...
The query processor ran out of internal resources and could not produce a query plan – When You’ve Managed to Confuse SQL With a Crazy IN Clause.
Recently I received a cry for help over Teams. The issue was that an...
Forums
A Few Good DBAs
You can't handle the truth!! (about data integrity) A few good database administrators https://www.helpmasterpro.com/blog/a-few-good-database-administrators/...
Python with SQL 2022 Enterprise doesn’t work
I have installed Machine Learning with SQL 2022 Enterprise Edition and installed and configured...
A Guide to SQL Security in Django
Comments posted to this topic are about the item A Guide to SQL Security...
Question of the Day
Incremental Statistics
I have run this on SQL Server 2022 for the Sales database:
ALTER DATABASE Sales SET AUTO_CREATE_STATISTICS ON (INCREMENTAL = ON)I then run this in the Sales database:
USE Sales GO CREATE STATISTICS CustomerStats1 ON dbo.Customer (CustomerKey, EmailAddress) WITH INCREMENTAL = OFFThe dbo.Customer table is partitioned. How are statistics created? See possible answers