Viewing 15 posts - 3,256 through 3,270 (of 6,041 total)
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
To start, you would need a reference table mapping the longitude and latitude boundaries of each state, wouldn't you?
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 19, 2015 at 12:39 pm
Viewing 15 posts - 3,256 through 3,270 (of 6,041 total)