Viewing 15 posts - 106 through 120 (of 280 total)
deepzzzz (7/17/2012)
I have changed the query as below.
SELECT * FROM table_name WHERE...
July 17, 2012 at 2:27 am
I agree with Leo, the sysjobs and sysjobhistory tables can be quite useful. Here's a query I wrote which will return the average, max, min, range and standard deviation...
July 16, 2012 at 3:21 am
Most employers don't seem to have a clue about qualifications - don't get me wrong, they're important, but they won't keep abreast of new available offerings.
Personally I'm working towards a...
July 16, 2012 at 1:06 am
What an excellent article - thanks very much for sharing your thoughts. Some really well-researched material here!
July 16, 2012 at 12:56 am
Timothy
Good points and a trigger shouldn't be considered the principal method for securing a database. Your comments about a change log - have you considered using Kimball tables? ...
July 12, 2012 at 3:39 pm
DaVinci007 - you're absolutely right, it is quite easy to get around this trigger. I suppose my point was really that this approach would supplement more powerful security measures...
July 12, 2012 at 2:31 pm
ALTER DATABASE [tempdb]
REMOVE FILE <logical_name_1>
;
Repeat until all excess files removed, then restart SQL Server.
July 12, 2012 at 9:11 am
OK, what about this? An external stored procedure call using batch file scripting and a SQL input file.
Set up your table object:
CREATE TABLE CountTable (
uid INT IDENTITY(1,1)...
July 12, 2012 at 6:28 am
Hi Kev, one way of doing this would be to append some code to your existing trigger. So when a database drop attempt is detected, you can capture the...
July 12, 2012 at 5:31 am
I would do this at the database level, have a linked table with the costs / expense information SUMmed using calculated columns and inserted into whenever an insert is made...
July 12, 2012 at 2:53 am
- Check SQL Server Configuration to ensure port settings haven't changed (default: 1433).
- Execute SQLCMD -Sservername -E -A to see if you can connect at the command line.
...
July 12, 2012 at 2:13 am
Your method works well but doesn't adapt to other branches of the organisation, so it's not particularly scalable.
Consider an organisation with structure:
Director -> Assistant Director -> Sales Manager -> Sales...
July 12, 2012 at 2:08 am
In the process of tuning up and fixing the obvious deficiencies, only been here a couple of weeks so far. There's no shortage of targets 🙂 And I...
July 10, 2012 at 11:18 am
Thanks Gail. I've taken a 4-hour data set now and although there is uneven distribution of processor use, it doesn't vary by more than 10 percentage points from top...
July 9, 2012 at 6:32 am
TOP doesn't guarantee ORDER BY. You should explicitly specify ORDER BY where possible and you can limit the result set like this:
...
ORDER BY yourCol ASC
OFFSET...
July 9, 2012 at 3:16 am
Viewing 15 posts - 106 through 120 (of 280 total)