Partitioning on a nullable column
tl;dr; If you are SWITCHing data into a table and the partitioning column is nullable you will need to add...
2017-05-17 (first published: 2017-05-03)
1,613 reads
tl;dr; If you are SWITCHing data into a table and the partitioning column is nullable you will need to add...
2017-05-17 (first published: 2017-05-03)
1,613 reads
I was looking around for something to write about this evening and came across one of Russ Thomas’ (b/t) old...
2017-05-17
2,854 reads
TL;DR: It’s pretty pointless and can cause performance issues.
Let’s start by asking why you might want to shrink your log....
2017-05-15
475 reads
Quite a while ago I created a couple of little security scripts to help me out with permissions research. Over...
2017-05-12 (first published: 2017-05-01)
2,230 reads
I’m a big fan of dynamic SQL. In the past I’ve written a How to, a Best Practices and even...
2017-05-11
560 reads
It’s T-SQL Tuesday again! This month we are being hosted by James Anderson (b/t). Thanks James! He has asked us...
2017-05-09
413 reads
I had this question come up at work the other day and while I knew it was true I wasn’t...
2017-05-08 (first published: 2017-04-26)
3,529 reads
When you right click on a tab you’ll see a number of different options. You can set up new horizontal...
2017-04-24
372 reads
We all know indexes are good and I’m hoping everyone knows you can have too many indexes. That means we...
2017-04-21 (first published: 2017-04-19)
2,793 reads
tl;dr; While at one point the cost of a query was an estimated time to run in seconds, today it’s...
2017-04-17
500 reads
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
Invoke-Sqlcmd -Query "ALTER AVAILABILITY GROUP $AAG REMOVE DATABASE $DB " -ServerInstance $Instance Invoke-Sqlcmd :...
I assume SSMS V20 encryption and SQL Server SSL encryption are different. I have...
Comments posted to this topic are about the item Enable a Disabled Index
I have disabled the LoggerCI index on the dbo.Logger table. How do I enable it?
See possible answers