Viewing 15 posts - 3,631 through 3,645 (of 3,738 total)
Thank you Steve for articulating this challenge for it was very well stated.
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/
February 11, 2010 at 1:36 pm
Gail,
I have to say that I'm very impressed by your post and articles. You add a lot to the forum.
Thank you,
Welsh
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/
February 11, 2010 at 1:24 pm
Perhaps a distinquest professional that is a member of this forum could add or dispute my suggestion with respect the use of the SQL DIag Utility or any other diagnostic...
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/
February 11, 2010 at 1:19 pm
SQL Server Consolidation Professional Consultants as well as Microsoft SQL Server Server Support Staff use the SQL Diag Utility to assess the feasibility of consolidation of candidate databases as well...
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/
February 11, 2010 at 1:05 pm
Please try goggling on the error. I found various hits but I was not sure which scenario matched your situation.
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/
February 11, 2010 at 12:35 pm
Have you tried the DTS export wizard?
If you wish to become more advanced you can go into the DTS Designer and/or write code to accomplish this simple objective.
I would happy...
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/
February 11, 2010 at 12:11 pm
I have preformed many Access to SQL server and Oracle Conversions.
I would suggest that you do not use a migration wizard.
You should carefully examine the differences in the data types...
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/
February 11, 2010 at 11:46 am
Please chack the following links:
http://social.msdn.microsoft.com/Forums/en/sqltools/thread/bac7ecee-a156-4313-b532-ba15813a0700
http://relatedterms.com/ViewThread.aspx?t=1628286
If this does not adress y9our problem I would sugesst that y9ou google and I;m sure that you will find a solution to your problem.
Regards,
Welsh
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/
February 11, 2010 at 11:26 am
Have you ever used the SQL Server SQLdiag Utility?
This is a very usefull utility used in analyzing in the databases consolidation process:
http://msdn.microsoft.com/en-us/library/ms162833.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/
February 11, 2010 at 11:15 am
Posted by mistake...
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/
February 10, 2010 at 12:37 pm
I have to agree that Brad's response was excellent
Gail's article was excellent as expected.
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/
February 10, 2010 at 6:33 am
Good point on the Transaction Log Backups.
I worked at a place where I found that they were truncating the transaction log backups and sending an Alert when they became full.:hehe:
Also...
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/
February 10, 2010 at 6:15 am
I would advise you to routinely test your backup & recovery.
You may think that you can recover but when a disaster strikes you may find that you do not have...
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/
February 9, 2010 at 12:38 pm
I wrote a program years ago that would delete records as defined by batch size.
The batch size was defined in a control table. I also had a column that defined...
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/
February 9, 2010 at 5:51 am
Please refer to the following links:
http://drsql.spaces.live.com/blog/cns!80677FB08B3162E4!281.entry
http://www.coderjournal.com/2008/08/deadlocked-read-committed-snapshot-explained/
http://decipherinfosys.wordpress.com/2008/04/18/
I hope this helps...
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/
February 8, 2010 at 7:53 am
Viewing 15 posts - 3,631 through 3,645 (of 3,738 total)