Viewing 15 posts - 4,036 through 4,050 (of 6,035 total)
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
Novices have no business designing databases, so I won't reiterate all the bad patterns related to that. Instead I'll mention a few observations regarding common mistakes that end users make...
March 20, 2015 at 7:27 am
Hopefully R# will be to data analytics what C# is to application development, and it won't simply be a curious wallflower like J# and F#.
March 19, 2015 at 8:36 am
You can use the following stored procedure and DMV queries to get information about server disk space. Because it runs within context of SQL Server, you only need connect to...
March 18, 2015 at 9:18 am
SQL_Kills (3/17/2015)
Hi Eric,This is not giving me the result I require.
Thanks
Sorry about that; I forgot to add Y.ID = T.ID in the join, which is why it was previously cross...
March 18, 2015 at 7:33 am
Miles Neale (3/17/2015)
Eric M Russell (3/17/2015)
Miles Neale (3/17/2015)
March 17, 2015 at 4:23 pm
Viewing 15 posts - 4,036 through 4,050 (of 6,035 total)