Viewing 15 posts - 1 through 15 (of 50 total)
Good article, we are also a VMWare environment and thus applicable. I noticed the example selects a single storage location, yet spins 8 drives out of this over 3 SCSI...
January 3, 2017 at 10:51 am
Need trick and scanning the AD-group is certainly useful, but wouldn't you want to know the real permissions in SQL Server itself to the Database level? Or at least compare...
March 17, 2016 at 6:45 am
the article will provide answers: http://sqlmag.com/database-security/sql-server-encryption
November 4, 2015 at 10:49 am
Usefull technique that I have used mysqelf, even to re-org a DB. One does have to question why there is this over allocation of space in the DB's to begin...
August 17, 2015 at 6:45 am
Great Article and well explained. I hear 'disk space' is cheap all the time as well. The problem typically stems from the fact that the developers don't fully understand what...
December 31, 2010 at 5:54 am
You may want to look at the disk space on those server boxes, particularly the logs. Insert INTO creates logs for the session. Afterwards the logs are emptied when you...
December 1, 2010 at 9:49 am
Thansk Parthi, works like a charm 😉
September 29, 2010 at 2:57 pm
I don't want to change the table because the server frequently runs multi-day processes, so renaming/dropping/moving is out of the question because it could affect those processes.
The list itself is...
September 29, 2010 at 12:14 pm
sorry, should have added that the username is not sufficient info, because it is likely some automated process. I rather see the query that is performed and from which DB...
September 29, 2010 at 11:44 am
Not sure that on larger datasets and/or busier server one would want to DELETE/TRUNCATE records. The risk with DELETE/TRUNCATE is that you change your original content, thus you are...
September 22, 2010 at 6:53 am
Interesting thought but returns several records. The hostname parameter did put me in the right direction for a new Google search, which resulted in the following:
SELECT HOST_NAME() AS HOST_NAME
September 15, 2010 at 9:15 am
decided to use COALESCE() function to improve coverage 😉
February 5, 2010 at 7:01 am
forgot to mention, we use 'windows authentication'
what is the difference between SYSTEM_USER and suser_sname?
February 2, 2010 at 9:52 am
Thanks for Sharing the website Brad! I find it useful to see how the robot learns and improves as generations pass. Although even higher generation can get themselves driving in...
January 15, 2010 at 6:40 am
in my example:
starting at top left as indicated by article
Line 1: instruction is not to move and pick up the can
Line 2: Move 1 square to west and pick up...
January 14, 2010 at 7:48 am