Viewing 15 posts - 3,511 through 3,525 (of 13,855 total)
Thom, if that's the case, you are right.
But for the examples provided, I can't see how it's required (excepting, possibly, the change in cost price – though any half-decent application...
June 18, 2019 at 2:56 pm
I mean by running one or more queries which look for validation issues & passing the results of those queries to sp_send_dbmail.
There are many ways of doing it. Here...
June 18, 2019 at 2:39 pm
I'm not a fan of triggers, so my initial thought would be to create a SQL Agent job which runs periodically (hourly? daily?), looking at all rows in the table...
June 18, 2019 at 1:54 pm
June 18, 2019 at 1:41 pm
while it's slightly off topic, I worked with a team that mixed the V model (kinda like waterfall) and agile.. it had an unfortunate nickname of "vagile"...
June 18, 2019 at 1:34 pm
I recently migrated from Windows 2003 SBS running SQL 2005 Express along with SSMS 2005 Express. The new server is Windows 2008 R2 SP1 and has SQL 2008 R2...
June 17, 2019 at 10:46 pm
while it's slightly off topic, I worked with a team that mixed the V model (kinda like waterfall) and agile.. it had an unfortunate nickname of "vagile"
I came...
June 17, 2019 at 8:35 pm
Preferred option would be to make the Java app perform the notification itself.
Use a non-locking record count technique, such as
SELECT TotRows = SUM(row_count)
FROM sys.dm_db_partition_stats
WHERE object_id = OBJECT_ID('schemaname.tablename')
...
June 17, 2019 at 7:02 pm
Thanks all. Here is the SSIS expression for those who only need to use SSIS, DATEADD("hh",17,(DT_DBTIMESTAMP) ( (DT_STR,30,1252) (DT_DBDATE) (DATEADD("dd", -1 - (DATEPART("dw", getdate()) % 7), getdate()) ) )...
June 17, 2019 at 2:06 pm
Well done on providing the DDL for the table.
Would you also be able to provide some sample data, along with desired results, based on that sample data?
The sample data should...
June 16, 2019 at 4:14 pm
. If the owner of the job is a sysadmin - the job runs in the context of the SQL Server service account.
I don't think that this is...
June 15, 2019 at 8:29 pm
I need my child packages to run in parallel (multi-threading)... They're loading lots of data and I can't wait for one to finish before starting the other. I've tried...
June 14, 2019 at 3:42 pm
The Agent service account.
June 14, 2019 at 2:58 pm
Don't think you can. Precedence constraints are the answer – what is the reason for you not using them?
June 14, 2019 at 2:53 pm
Thanks, Jeff. The date processing capabilities in T-SQL are significantly more powerful than those built in to SSIS (though, of course, SSIS has native access to .NET libraries through C#...
June 14, 2019 at 2:23 pm
Viewing 15 posts - 3,511 through 3,525 (of 13,855 total)