deepzzzz (7/17/2012)

---

The given example is working fine. But using contains in full text its not giving me the right answer

I have changed the query as below.

SELECT * FROM table_name WHERE...

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...

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...

What an excellent article - thanks very much for sharing your thoughts. Some really well-researched material here!

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? ...

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...

ALTER DATABASE [tempdb]

REMOVE FILE <logical_name_1>

;

Repeat until all excess files removed, then restart SQL Server.

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)...

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...

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...

- 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.

...

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...

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...

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...

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...