SSRS Execution Log Queries
A few brief selects to expose snippets of data which may be useful for debugging larger issues.
2012-08-27 (first published: 2012-08-15)
1,406 reads
Execution Logging
Copy-and-Paste SSIS Execution Monitoring with Failure-Alert Email
This SSIS package monitors the execution of any SSIS tasks pasted into its sequence container, and sends an email when a failure of any embedded task occurs.
2010-07-12
7,556 reads
RE: Cursor not working
quote: These guys are right. You don't need a cursor to do the update. Also, let me suggest that you wrap the update statement in a transaction. BEGIN TRAN...COMMIT TRAN. When you are ready to run the code, use begin tran and the update statement without the commit tran. You should see how many records […]
2003-12-30
RE: How to know when File is done FTPing?
Check the file size. One minute later check it again - if same, you can assume its finished. If you aren't on a fast network then stretch it out to five minute checks. Another alternative is to not use the FTP object, instead running a batch file that does the ftp then as the next […]
2003-07-18
RE: awe (Address Windowing Extensions) on S2K SP3
To use AWE memory, you must run the SQL Server 2000 database engine under a Windows 2000 account that has been assigned the Windows 2000 lock pages in memory privilege. To obtain the correct amount of SQL Server memory usage, you can use the Total Server Memory (KB) performance counter, activated through System Monitor, or […]
2003-07-14
RE: SQL Server Considerations
Dear pro2003, My first question is - what're we gonna call you in 2004? ok - here's one guy's humble opinion: #1: listen to mccork on hardware - very important - get a REAL server... #2: ram on pII machines is cheap, ram on REAL servers is not - you might have to fight the […]
2003-07-10
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers