Temp table quiz
Brent Ozar (b/t) posted a pop quiz on twitter earlier today.
Go ahead and give it a shot .. I’ll wait.
So?...
2017-06-26
663 reads
Brent Ozar (b/t) posted a pop quiz on twitter earlier today.
Go ahead and give it a shot .. I’ll wait.
So?...
2017-06-26
663 reads
I ran into an interesting error the other day while doing a partition switch.
Partition switch failed because : column ‘xyz’...
2017-06-26 (first published: 2017-06-15)
3,165 reads
If you are upgrading your instance to 2016 (or 2017 soon) then you probably are going to want to run...
2017-06-21
616 reads
A friend had an interesting problem today. A really big table (multiple millions of rows) and no primary key. He...
2017-06-19
908 reads
I thought I’d do another crossword. Enjoy! If you need any help with it feel free to let me know...
2017-06-16 (first published: 2017-05-31)
2,801 reads
Grant Fritchey (b/t) is our host for T-SQL Tuesday this month and surprise surprise he’d like to talk about DEVOPS....
2017-06-13
956 reads
I read an interesting question today. Someone wanted to be able to run the same stored procedure multiple times, at...
2017-06-08 (first published: 2017-05-24)
7,698 reads
If you’ve worked much with named instances you’ve probably had to deal with the question “What port is that instance...
2017-06-07
531 reads
Yes, I spelled that correctly. NUL not NULL. NUL is basically a location you can send a backup to. In...
2017-06-05
873 reads
In my last post on partitioning I used the $Partition command in passing. I’ve been thinking it deserves a bit...
2017-05-22
501 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