Viewing 15 posts - 196 through 210 (of 405 total)
The successvalu property foe execute process task is configurable. Even though the default is 0, you should change this according to the process you are using.
You should refer the manual...
February 21, 2013 at 9:10 pm
Karen Grube,
a) You can configure SQL agent to run packages from file system. So if you can place the package in a fileshare and if the sql server agent has...
February 21, 2013 at 3:04 am
Lavanyasri (2/21/2013)
I go through the link , now my issue with the decimal data type
SELECT col1 FROM table2
WHERE col2 > 9999999999.99999
OR col1 < -9999999999.99999
In this script col1...
February 21, 2013 at 2:43 am
Hash match can spill to tempdb.
details on hash join
http://technet.microsoft.com/en-us/library/ms189313(v=sql.105).aspx
February 21, 2013 at 2:33 am
Tempdb may be use while grouping sorting etc.
You should look ate the execution plan and see whether any index/ query rewrite can help.
If you need help please share the execution...
February 21, 2013 at 2:09 am
The percentage you are seeing is the percentage relative to the batch.
Since there is only one query in batch it shows 100 percent.
If you had more than one statement for...
February 20, 2013 at 3:27 am
Check whether you have proper indexes for the child table.
Run a delete statement enabling execution plan and see whether the index is being used.
February 20, 2013 at 2:35 am
Amit,
This looks like an old thread, still
Mostly the problem would be firewall.
Look what port is configured in Reporting services configuration manager (Or ask your DBA).
Ask your network folks to open...
February 20, 2013 at 12:45 am
You cannot create computed columns that refernces other tables
http://msdn.microsoft.com/en-in/library/ms191250(v=sql.105).aspx
You might want to create a trigger to implement this, or if you are in the design phase, try to incorporate this...
February 20, 2013 at 12:41 am
Even though you have give 100 rows per job, maximum number of (total) rows(1000) is reaching frequently.
You can increase this to say 5000 and see whether it is enough for...
February 19, 2013 at 10:10 pm
Jordan,
How many rows you have in sysjobhistory?
select * from msdb.dbo.sysjobhistory
February 19, 2013 at 9:26 pm
In addition to nicks suggestion, you can use script task as per the below link
I have not used this , but will keep this in mind so may be useful...
February 19, 2013 at 8:41 pm
crazy_s245 21087 (2/19/2013)
February 19, 2013 at 8:31 pm
Gail,
Apart from forcing a hint, I would like you revisit the TOP clause. I have seen TOP behaving unexpectedly particularly when you dont have an order by. Its is...
February 19, 2013 at 2:54 am
Viewing 15 posts - 196 through 210 (of 405 total)