PowerShell for Batch Operations
I’m right in the middle of moving one of our databases from Oracle to SQL Server (and I just love...
2010-03-01
1,681 reads
I’m right in the middle of moving one of our databases from Oracle to SQL Server (and I just love...
2010-03-01
1,681 reads
If you’re not reading Buck Woody’s blog, why not? Today he posted a helpful hint for getting performance counters directly...
2010-02-26
1,393 reads
What the heck is wrong with you?
Still interested? Fine. I’ll tell you my take on this whole business. I’m only...
2010-02-19
698 reads
I realize I’m prejudiced, being one of those evil DBA’s & all, but I can’t help but agree with him. It’s...
2010-02-16
776 reads
I’m getting my first look at a full-fledged nHibernate database developed by consultants for our company. I thought I’d share...
2010-02-15
1,286 reads
Today we have a guest editorial from Grant Fritchey that discusses the idea of rules based on certain types of measurements. Are they worth following? Or do we need to develop our own measures.
2010-02-08
362 reads
Whew!
It’s over. New England Data Camp v2, aka, SQL Saturday #34, was completed on Saturday. Going in we had maxed...
2010-02-01
579 reads
The event is this Saturday. Take a look at our sponsors, speakers and the program. It’s going to be a...
2010-01-27
586 reads
Phil Factor’s most recent guest editorial over at SQL Server Central has, to a degree, pointed out that the emporer’s...
2010-01-25
801 reads
I needed to create an identical index on a bunch of tables within one of my projects (yes, I know...
2010-01-21
1,806 reads
By Steve Jones
One of the parts of getting older that really sucks is I seem to...
By Chris Yates
The New Leadership Frontier In today’s digital landscape, leaders are no longer just visionaries....
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Hi, we put together an extract that runs every 15 minutes against what i...
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization in...
Comments posted to this topic are about the item Minimum Change Tracking Retention
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=xxx);What is the minimum amount of time I can set? See possible answers