T-SQL Tuesday #1: Date/Time Tricks
I’m going to try out Adam Machanic’s idea for a blog party. The topic this month are Date/Time tricks.
Instead of...
2009-12-08
657 reads
I’m going to try out Adam Machanic’s idea for a blog party. The topic this month are Date/Time tricks.
Instead of...
2009-12-08
657 reads
If you missed this, here’s your chance to make it up. If you were there, and like me, you need...
2009-12-02
710 reads
Andy Warren in the latest PASS Connector has posted an update on where we’re at with the SQL Server Standard....
2009-12-02
644 reads
I’ve been tagged by a misplaced yankee, uh, New Englander, whatever. The question is, how do I/we use SQL Server...
2009-12-01
771 reads
It’s official sports fans. Well, it’s been official since last week since Adam Machanic set up the web site. The...
2009-11-30
1,377 reads
I’m still struggling with learning XQuery. My latest little revelation was small, but vital.
The difference between:
@inXML.nodes('/rss/channel/item')and
@inXML.nodes('/rss[1]/channel[1]/item')Is the difference between a...
2009-11-30
1,528 reads
I’m still struggling with learning XQuery. My latest little revelation was small, but vital.
The difference between:
@inXML.nodes('/rss/channel/item')and
@inXML.nodes('/rss[1]/channel[1]/item')Is the difference between a...
2009-11-30
1,741 reads
Sorry, I’ve been travelling for three weeks and, except for the posts around the PASS Summit, I’ve been blogging very...
2009-11-23
544 reads
Last week I attended the Dev Connections conference for the first time. It was held in the Mandalay Bay resort...
2009-11-17
789 reads
That’s a Microsoft Tag. I’m not quite sure what exactly to do with it, but here it is. Evidently you’re...
2009-11-17
510 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