Permissions required for developing with Temporal Tables
Temporal tables are one of those new (2016+) cool features that recently came across my desk. Basically, a temporal table...
2017-10-26 (first published: 2017-10-16)
1,694 reads
Temporal tables are one of those new (2016+) cool features that recently came across my desk. Basically, a temporal table...
2017-10-26 (first published: 2017-10-16)
1,694 reads
2017-10-25
345 reads
Every now and again you have a database where you don’t necessarily need the data. It can easily be re-loaded...
2017-10-25
970 reads
CTEs are cool things. You can essentially create one or more in-line view(s) within your query. One thing that isn’t...
2017-10-18
1,961 reads
We frequently talk about dealing with outgrowing INT identity columns. What we don’t talk about all that often is small...
2017-10-17 (first published: 2017-10-09)
1,839 reads
I’ve you’ve done much work with the system views (DMVs for example) then you’ve had to translate an object_id into...
2017-10-11
418 reads
The BEGIN/END block is a fairly standard thing if you’ve ever done any coding, but it never hurts to do...
2017-10-04
948 reads
I decided that for Halloween this year it would be fun to tell SQL ghost stories. When I tweeted about...
2017-10-03
331 reads
Last month your homework was to set up your own lab. Now it’s time to put a sample database or...
2017-10-02
426 reads
2017-09-27
197 reads
At a recent conference I was asked how I executed code during my presentation....
“Could you help me, we deleted the database’s transaction log file and now that...
I had a couple of clients who were moving content from development catalogs to...
Comments posted to this topic are about the item Enable a Disabled Index
Comments posted to this topic are about the item Diving Deeper into the Import...
I have disabled the LoggerCI index on the dbo.Logger table. How do I enable it?
See possible answers