Viewing 15 posts - 1,216 through 1,230 (of 2,612 total)
TRIGGERS are based on an INSERT, UPDATE, or DELETE happening. So, you can cause a trigger to fire by simply doing one of those actions - it does not...
June 20, 2008 at 6:06 am
You certainly do not need a script task for this.
Use a loop container and have it loop forever - or some pre-defined number of times.
In the loop container, add an...
June 20, 2008 at 5:45 am
You could do this with an INSTEAD OF trigger. Look it up in books online, the documentation for the syntax is pretty thorough and includes samples.
June 20, 2008 at 5:34 am
It gets installed with the client tools. I suppose you could open the dtsx file with an XML editor and modify it, but I would not recommend it.
June 20, 2008 at 5:28 am
Are they two different physical disks, or a single disk or array with two logical partitions?
The advantage of having your database file and log file on different physical disks is...
June 20, 2008 at 5:26 am
There is a procedure call to get some kind of ServiceLogID returned. So, this procedure is being called for every update made in your database, what is it doing?
Since...
June 20, 2008 at 5:20 am
EXEC msdb..sp_help_job
June 19, 2008 at 1:30 pm
Use the script wizard in Management Studio to generate a script for all objects in the database and then run the script on the new server.
June 19, 2008 at 1:28 pm
I just went and dug up that article to help illustrate why the cross apply was going to perform poorly if there were a lot of records.
And then you beat...
June 19, 2008 at 1:26 pm
Remember, because of the CROSS APPLY, this is going to be row-by-row processing, so if you have 100m rows, this is going to be pretty slow.
My guess is that people...
June 19, 2008 at 1:21 pm
So you want the SUM by year to be more than $1000.
You need an additional line in the APPLY and also add the WHERE to limit it to a single...
June 19, 2008 at 1:19 pm
FYI - your last piece of code did not work. It came back with 11/1 and the first date when 1000 was reached was 10/1.
June 19, 2008 at 1:14 pm
I modified your sample code so it uses a temp table (didn't want to create a table in my database) and has the correct length for the code.
The CROSS APPLY...
June 19, 2008 at 1:08 pm
Some "hint" Steve - that looks suspiciously like an answer to me.
June 19, 2008 at 12:00 pm
What are you planning on doing when you come across a last name with a space in it or a person with two middle initials?
June 19, 2008 at 11:57 am
Viewing 15 posts - 1,216 through 1,230 (of 2,612 total)