Viewing 15 posts - 5,101 through 5,115 (of 6,041 total)
lianvh (8/2/2012)
our IT Auditors suggested the database administrators should not be able to view the Production data . Is there way to do that or should we rather...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 3, 2012 at 12:54 pm
oferhai (7/27/2012)
i tested it on 2008 and it works great - the problem is that it is not working on 2012.
for 2012 all groups and...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 30, 2012 at 8:44 am
Ajdba (7/26/2012)
Thanks a bunch!Also, can you please point me to a good link about tuning a query or Stored Procs
Regards
Aj
So, if you're interested in query performance tuning in general,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 26, 2012 at 8:32 am
ChrisM@Work (7/26/2012)
Eric M Russell (7/26/2012)
Lynn Pettis (7/25/2012)
Eric M Russell (7/25/2012)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 26, 2012 at 8:22 am
Lynn Pettis (7/25/2012)
Eric M Russell (7/25/2012)
I'm not a beer connoisseur and don't care for the small batch gourmet stuff. When I drink beer, I'm either drinking Miller High Life.
Or? ...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 26, 2012 at 6:50 am
Ajdba (7/24/2012)
ThanksAlso, how can I create an index on a computed column such as " incident_year"
Thanks
You can index a computed column that has the PERSISTED keyword.
http://msdn.microsoft.com/en-us/library/ms191250(v=sql.105).aspx
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 25, 2012 at 4:08 pm
Mark R1 (7/23/2012)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 25, 2012 at 4:01 pm
I'm not a beer connoisseur and don't care for the small batch gourmet stuff. When I drink beer, I'm either drinking Miller High Life.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 25, 2012 at 3:55 pm
Where convert(varchar, a.submitted, 120) = convert(varchar, '2011-07-07 14:39:39', 120)
Style 120 actually doesn't strip out the time portion of the datetime, so what they're doing makes no sense. I doubt the...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 25, 2012 at 12:02 pm
Steve Jones - SSC Editor (7/25/2012)
mtucker-732014 (7/23/2012)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 25, 2012 at 11:25 am
miapjp (7/24/2012)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 25, 2012 at 10:58 am
Jeff Moden (7/23/2012)
Eric M Russell (7/23/2012)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 24, 2012 at 7:53 am
Regardless of that formal methodology is used for appraisals, I expect that most managers mentally "stack rank" the employees in their department anyhow. What we're talking about here is a...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 23, 2012 at 8:20 am
hakim.ali (7/20/2012)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 20, 2012 at 8:36 am
I can see how stack ranking would be a useful tool for a company who has a tight budget for pay raises and performance bonuses, or a company which is...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 20, 2012 at 7:05 am
Viewing 15 posts - 5,101 through 5,115 (of 6,041 total)