SQL Puzzle – Word Scrambler
I’ve been writing crosswords for the last few months and to change things up I thought I would do a...
2017-11-29
549 reads
I’ve been writing crosswords for the last few months and to change things up I thought I would do a...
2017-11-29
549 reads
A while back I did a post about why you shouldn’t shrink your data file. This one is going to...
2017-11-20
452 reads
I had someone ask me about this the other day. Specifically getting variable data out of a dynamic SQL statement....
2017-11-16
1,478 reads
2017-11-15
421 reads
Ewald Cress (b/t) is our host this month for Adam Machanic’s (b/t) monthly blog party T-SQL Tuesday. Having just gotten...
2017-11-14
327 reads
Views are a highly useful tool for abstracting how you see the data stored in tables. At their simplest, they...
2017-11-13 (first published: 2017-11-01)
1,506 reads
I’ve talked about Collation Confusion before. We had the dev and test instances at one collation and the production instance...
2017-11-08
391 reads
It was recently brought to my attention that not everyone knows everything. This was a shock. Everyone is born knowing...
2017-11-06
485 reads
In this age of cost-saving after cost-saving, one way you may be looking at saving money is by combining multiple...
2017-11-01 (first published: 2017-10-23)
2,111 reads
Have you ever had a query change performance unexpectedly? Intellisense all of a sudden stops working, or gives inconsistent results?...
2017-10-30
661 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