Help! My backup file has doubled in size.
Help! I backed up my database yesterday and the backup file was about 200MB but today it’s closer to 400!...
2016-06-16
557 reads
Help! I backed up my database yesterday and the backup file was about 200MB but today it’s closer to 400!...
2016-06-16
557 reads
I was reading someone’s question the other day on StackExchange and while the existing comments/questions solved the OP’s (original poster)...
2016-06-10 (first published: 2016-06-02)
4,625 reads
I did a post the other day on comparing two tables. It was meant as a general overview but I...
2016-06-08
468 reads
Many years ago during an interview I was asked to “Name the top 7 DBCC commands that you use.” I...
2016-06-06
1,406 reads
There is a highly useful system view called sys.master_files. If you’ve never encountered it before it returns a list of...
2016-06-01 (first published: 2016-05-23)
1,569 reads
I really do. There is a joke that DBAs say no to everything and there is some truth to that....
2016-05-31
743 reads
Recently I created my first Azure SQL Database. But now I need to connect to it.
You can connect using...
2016-05-25
540 reads
Let’s start with a very brief definition of some RAID levels.
RAID 0 : Stripe your data across multiple disks. Writing a...
2016-05-24 (first published: 2016-05-16)
1,465 reads
I was reading a blog post from my friend Randolph West (b/t) on Best Practices and a thought struck me.
Starting...
2016-05-18
460 reads
I’ve been working on tuning a query for the last week and I’ve had to make several changes to the...
2016-05-16 (first published: 2016-05-12)
3,531 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