Viewing 15 posts - 4,021 through 4,035 (of 6,026 total)
Chris Harshman (3/24/2015)
Eric M Russell (3/20/2015)
Yes, I do that sometimes, but the catch is that it has to be a 'persisted' computed column. Adding these persisted columns to an existing...
March 24, 2015 at 8:31 am
Chris Harshman (3/24/2015)
Iwas Bornready (3/24/2015)
March 24, 2015 at 7:33 am
Jeff Moden (3/22/2015)
Eric M Russell (3/20/2015)
Chris Harshman (3/20/2015)
Eric M Russell (3/20/2015)
March 24, 2015 at 7:17 am
Rename the table and see how many users complain. 🙂
Or use an extended event trace. Either way, it's not something you want to be counting 24x7. I assume you just...
March 24, 2015 at 7:04 am
Toby Harman (3/23/2015)
One area which no-one has mentioned (that I saw) was that using GUIDs as the clustered key can avoid hot-spots when adding a lot of data. The random...
March 24, 2015 at 6:47 am
below86 (3/23/2015)
Eric M Russell (3/23/2015)
below86 (3/23/2015)
Eric M Russell (3/23/2015)
No has even attempted a reboot of B. J. and the Bear.
I loved that show.
I ran into this same issue...
March 23, 2015 at 8:13 am
Phil Parkin (3/23/2015)
Eric M Russell (3/23/2015)
abhas (3/23/2015)
DATE_MODIFIED column is there.
If DATE_MODIFIED is populated when the row is initially inserted, and it's updated consistently by the application, and it's indexed,...
March 23, 2015 at 8:02 am
Koen Verbeeck (3/23/2015)
Eric M Russell (3/23/2015)
abhas (3/23/2015)
DATE_MODIFIED column is there.
If DATE_MODIFIED is populated when the row is initially inserted, and it's updated consistently by the application, and it's indexed,...
March 23, 2015 at 7:57 am
below86 (3/23/2015)
Eric M Russell (3/23/2015)
No has even attempted a reboot of B. J. and the Bear.
I loved that show.
I ran into this same issue with a couple movies....
March 23, 2015 at 7:52 am
abhas (3/23/2015)
DATE_MODIFIED column is there.
If DATE_MODIFIED is populated when the row is initially inserted, and it's updated consistently by the application, and it's indexed, then that's ideal. You may...
March 23, 2015 at 7:44 am
Charles Kincaid (3/20/2015)
Knut Boehnert (3/20/2015)
#1 No documentation...
#2 Incomplete documentation
...
#3 Inadequate documentation
...
I'm working on a tool to help with this right now. First release is targeted for April.
Don't forget the...
March 21, 2015 at 6:09 am
Chris Harshman (3/20/2015)
Eric M Russell (3/20/2015)
March 20, 2015 at 3:15 pm
xsevensinzx (3/20/2015)
Eric M Russell (3/20/2015)
#5 Inappropriate use of datetime columns. For example SELECT ... WHERE SALESDATE BETWEEN '2015/03/01' AND '2015/03/31'.
This one is the one I found myself doing...
March 20, 2015 at 1:37 pm
Steve Jones - SSC Editor (3/20/2015)
CGMChris (3/20/2015)
What exactly is the "chef problem"? A quick Google search didn't turn up anything seemingly relevant. Or perhaps Steve meant "chief"?
The chef problem...
March 20, 2015 at 12:17 pm
Viewing 15 posts - 4,021 through 4,035 (of 6,026 total)