Viewing 15 posts - 1,561 through 1,575 (of 3,738 total)
Thank you Lynn.:-)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 4, 2012 at 5:49 am
Thanks and don't you clear out your staging after the initial load to Staging and the inital load to the DW is complete.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 3, 2012 at 1:28 pm
Any thought, ideas, opinions, experiences,etc would be greatly appreciated.:-)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 3, 2012 at 1:17 pm
I took Parts of his OPEN QUERY Statements converted to Data Tranformation Task and loaded 178 tables in SSIS with the initial load and eliminated the slow OPEN QUERY Code.
He...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 3, 2012 at 12:56 pm
It appears that the person of interest has no intention of ever clearing the Staging. :hehe:
They will retain the Initial Load and each incremental load.
THe staging is never cleared...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 3, 2012 at 10:39 am
Thanks Lowell. 🙂
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 3, 2012 at 5:34 am
Listed below is the script that I have used to configure 5 servers in the past 6 months. Excluding the one that it is not working on.
I also listed some...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 3, 2012 at 5:21 am
Lowell (4/2/2012)
Lynn Pettis (4/2/2012)
What has me slightly confused is you talk about using Database Mail, but the code you show is using...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 3, 2012 at 4:42 am
SQLKnowItAll (4/2/2012)
In my neverending search for knowledge... I found this article. Welsh, does this help at all?
I had found another article similar to this.
I got an error when I...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 2, 2012 at 4:26 pm
Lynn Pettis (4/2/2012)
What has me slightly confused is you talk about using Database Mail, but the code you show is using CDONTS....
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 2, 2012 at 4:17 pm
Welsh Corgi (4/2/2012)
SELECT *
FROM sysmail_event_log
Nothing but start & stop DB Mail
SELECT *
FROM sysmail_allitems
I found the items were listed as failed.
So I check the Windows...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 2, 2012 at 4:13 pm
Lowell (4/2/2012)
SQLKnowItAll (4/2/2012)
Yup! Stepping away and observing because this is clearly not what I thought... 🙂
IIt seems to me the issue's more related to the service broker not processing the...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 2, 2012 at 4:00 pm
Lynn Pettis (4/2/2012)
I would be curious the value for is_broker_enabled in sys.databases for this database.
SELECT is_broker_enabled FROM sys.databases WHERE name = 'msdb';
Returns:
is_broker_enabled
1
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 2, 2012 at 3:43 pm
Lynn Pettis (4/2/2012)
Lowell (4/2/2012)
Lynn Pettis (4/2/2012)
What has me slightly confused is you talk about using Database Mail, but the code you show...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 2, 2012 at 3:40 pm
SQLKnowItAll (4/2/2012)
Hmm... Can you post the results of sp_configure?
Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.
Configuration option 'Database Mail XPs' changed from...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 2, 2012 at 3:37 pm
Viewing 15 posts - 1,561 through 1,575 (of 3,738 total)