Complex/Conditional ORDER BYs
Typically it’s considered best to run your queries without an ORDER BY and let the application do any sorting needed....
2016-04-04
464 reads
Typically it’s considered best to run your queries without an ORDER BY and let the application do any sorting needed....
2016-04-04
464 reads
I’ve playing around with AdventureWorks and managed to found some hidden code! Truly odd stuff. I’m so shocked I couldn’t...
2016-04-01
497 reads
To test or not to test. That is the question. Or is it? Shouldn’t we always test? That was the...
2016-03-30
780 reads
I answered an interesting question on SE today (ever notice how many posts come from stuff I read on forums?)...
2016-03-28
498 reads
tl;dr; There is no short version of this. It’s LONG. It’s interesting but you might want to skip it if...
2016-03-25 (first published: 2016-03-21)
4,610 reads
Tomorrow (3/24/2016) at noon CT I’ll be presenting my SQL Server Security Basics session for the Pass Security Virtual Chapter....
2016-03-23
463 reads
Ever wondered how to tell what permissions are required to run a statement or perform a task? Well, sometimes it...
2016-03-16
471 reads
Hey, I need sysadmin access to ServerA.
Ok. Why do you need sysadmin?
Well I need to be able to read and...
2016-03-16 (first published: 2016-03-10)
2,312 reads
This is one of those things that I found very interesting but figured I’d probably never really use. Of course...
2016-03-14
479 reads
The question of How to grant the ability to create/alter stored procedures and views came up today on dba.stackexchange.com. It’s...
2016-03-11 (first published: 2016-03-02)
2,249 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