Viewing 15 posts - 4,036 through 4,050 (of 6,041 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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
March 24, 2015 at 8:31 am
Chris Harshman (3/24/2015)
Iwas Bornready (3/24/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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....
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
March 23, 2015 at 7:44 am
No has even attempted a reboot of B. J. and the Bear.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
March 23, 2015 at 7:27 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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
March 21, 2015 at 6:09 am
Chris Harshman (3/20/2015)
Eric M Russell (3/20/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
March 20, 2015 at 12:17 pm
Viewing 15 posts - 4,036 through 4,050 (of 6,041 total)