Viewing 15 posts - 3,256 through 3,270 (of 6,042 total)
If you're traveling between countries that are not on good terms politically with each other, then it's a good idea not to bring along your laptop or smart phone, but...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 22, 2015 at 1:38 pm
Wayne West (10/21/2015)
Eric M Russell (10/21/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 21, 2015 at 2:51 pm
Iwas Bornready (10/21/2015)
Funny. I actually thought you had something there.
Are you referring to the brute force dictionary query against sys logins table to get passwords? Yes, it works. There are...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 21, 2015 at 2:44 pm
One definition of a "bad manager" is one who locks themselves in their corner office from 8am - 5pm every day, or one who spends their day hovering over the...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 21, 2015 at 7:27 am
timlenz (10/20/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 21, 2015 at 7:19 am
SQLCurious (10/20/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 21, 2015 at 7:10 am
The following will return all objects modified today.
select * from sys.objects where cast(modify_date as date) = cast(getdate() as date);
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 20, 2015 at 12:42 pm
Kim Crosser (10/20/2015)
Eric M Russell (10/19/2015)
it's indicative of poor ETL processing or poor data modeling. I mean, why insert something and then delete it?
We have interfaces with other systems where...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 20, 2015 at 11:05 am
Steve Jones - SSC Editor (10/20/2015)
Eric M Russell (10/20/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 20, 2015 at 10:52 am
The following gem will list what database/objects currently are locked by an open transaction, the type of lock used (ie: Exclusive vs. Shared) and also the SPID, login name, etc....
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 20, 2015 at 8:17 am
Let's assume a hacker can gain access to a privileged account on a highly sensitive database, like the one belonging to the federal government's Office of Personnel Management.
(OK, let...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 20, 2015 at 8:03 am
Lynn Pettis (10/19/2015)
Eric M Russell (10/19/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 19, 2015 at 3:15 pm
What % of rows are you deleting and how often? If > 25%, then you probably want to go ahead and just drop all indexes and then rebuild afterward. Another...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 19, 2015 at 3:04 pm
Indianrock (10/19/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 19, 2015 at 1:42 pm
Lynn Pettis (10/19/2015)
...
Looking at this, I started having a problem following it. This is something I'd have...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 19, 2015 at 12:55 pm
Viewing 15 posts - 3,256 through 3,270 (of 6,042 total)