Index Stats Duplication
I came across a recent posting about seeing multiple entries in sys.dm_db_index_usage_stats for the same index. This kind of behavior...
2010-04-22
2,062 reads
SQL RNNR
SQL 2008 R2
Really short post here. I just found out that Stacia Misner (blog |blog 2 | @StaciaMisner) and Ross Mistry have released...
2010-04-21
562 reads
Stepping Stone Cert II
Back on March 30, I wrote about a Stepping Stone Certification that seems to be missing between the MCM and...
2010-04-20
733 reads
BLOB Report T-SQL Tuesday #005- Reporting
This month for my second submission into T-SQL Tuesday, I decided to go with something that provides some insight into...
2010-04-13
1,142 reads
S3OLV April Meeting Recap
We held our meeting last night and had a good time. Thanks to those that were able to make it...
2010-04-09
449 reads
How Silly
Have you ever done anything that made you feel like a dunderhead? Maybe a little bone-headed, thick, numb-skullish?
Here is my...
2010-04-07
548 reads
LV April SQL Users Group Meeting
S3OLV or SSSOLV will be holding our meeting Thursday April 8th. The User Group is in affiliation with PASS and...
2010-04-06
457 reads
IP and Default Trace…T-SQL Tuesday #005 - A week early - D'oh
As chance would have it, I had been checking Adam’s blog daily for the last few days to find the...
2010-04-06
1,757 reads
Goal Review Q1
As we close out the First Quarter of 2010 it is time to review progress made on the Goals I...
2010-04-01
500 reads
Index Info
I recently came across an interesting script to help show index info and usage. As I began to dissect the...
2010-03-31
1,992 reads
Blogs
Securing Kubernetes With External Secrets Operator on AWS
Here’s a way to centralize management, rotate secrets conveniently without downtime, automate synchronization and...
Save Azure PostgreSQL Backup to Storage
This may or may not be helpful in the long term, but since I’m...
The Book of Redgate: What’s Great about Redgate?
By Steve Jones
“I’m sick of hearing about Red Gate.” The first article in the book has...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Pitfalls to avoid while feeding events into CrowdStrike
Comments posted to this topic are about the item Pitfalls to avoid while feeding...
Column Adds and Drops
Comments posted to this topic are about the item Column Adds and Drops
Question of the Day
Column Adds and Drops
I run this batch on SQL Server 2022. What happens?
ALTER TABLE dbo.Accounts ADD AccountAccessType INT GO ALTER TABLE dbo.Accounts DROP AccountAccessType GOSee possible answers