Viewing 15 posts - 2,341 through 2,355 (of 3,738 total)
Post removed.
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/
September 3, 2011 at 3:45 am
Why don't you use a Precedence Constraint to the alert task?
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/
September 3, 2011 at 3:44 am
I'm not sure where your getting your values from but basically you want to do the following.
For the INSERT Perform an INSERT followed by a JOIN of all tables and...
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/
September 2, 2011 at 7:46 pm
You have 3 tables, A, B, C, D, and E? :hehe:
I'm sure that there is more to your Table Structure than you provided.
Please provide and click on the first link...
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/
September 2, 2011 at 11:39 am
harry.sh16 (8/31/2011)
Not really, this issue is something different and I searched all ssis forums for an answer before posting. Thanks.
You should probably post in the SSIS Forum. 🙂
Do either of...
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/
August 31, 2011 at 7:02 pm
Duplicate post.
http://www.sqlservercentral.com/Forums/Topic1167066-148-1.aspx
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/
August 31, 2011 at 4:46 pm
Good points Craig.
With respect to the Standby Server you may want to consider documenting the connections strings that you changed when you consolidated so that if you need to move...
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/
August 30, 2011 at 12:44 pm
This is a self join exercise.
The manager name should be derived from the employee name column.
This is one example.
http://blog.sqlauthority.com/2010/07/08/sql-server-the-self-join-inner-join-and-outer-join/
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/
August 30, 2011 at 11:39 am
JPJ (8/29/2011)
Those are links of best sources that I am looking to. Thanks!
😎
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/
August 29, 2011 at 8:50 pm
Scripts to rebuild the indexes.
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/
August 29, 2011 at 7:01 pm
ronald_yoh (9/24/2010)
do i need to rebuild all indexes one by one for each tables? as there might be a hundreds of indexes all up
You should do as Gail suggested, Rebuild...
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/
August 29, 2011 at 4:39 pm
You can perform it in T-SQL.
RESTORE DATABASE DBName
FROM DISK = '\\Server\Share\Folder\BackupFile.bak'
WITH REPLACE
You can add the code to your SSIS Package.
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/
August 28, 2011 at 3:36 pm
I believe that the Potential Data Loss means that you are only going to get an accuracy of the DateTime in minutes as opposed to seconds.
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/
August 28, 2011 at 3:29 pm
Let me know if I can help.
Regards.
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/
August 27, 2011 at 6:22 pm
I would start out with a clean install.
You may want to try to install on a Home PC if you have not already done so.
I really don't care for Express....
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/
August 27, 2011 at 3:43 pm
Viewing 15 posts - 2,341 through 2,355 (of 3,738 total)