Viewing 15 posts - 121 through 135 (of 2,483 total)
George, given that this is a SQL 2005 forum, I'd assume that Graham is using SQL 2005. If that is the case, then the fulltext catalogs are included in the...
October 29, 2007 at 4:15 pm
With more relevant field names we can get an idea of what sort of data is stored in them.
One thing I see a lot of is duplicate address fields for...
October 29, 2007 at 4:05 pm
Check http://www.sqldts.com, I'm sure they have an example there.
October 29, 2007 at 5:26 am
The database in totol is about 100Gb by the way
Ok that right there is going to give you a very large bottleneck.
I'm betting your Page Life Expectancy is less than...
October 29, 2007 at 5:25 am
:w00t::sick::unsure:
Presuming the field names have been changed to protect the innocent, how about posting something a little less generic and we might be able to steer you towards a better...
October 29, 2007 at 5:19 am
Yes, Jeff does make assumptions, but they are the correct assumptions to make.
Blindly following a statement like "whatever you do, don't include the time components of the dates" doesn't make...
October 29, 2007 at 5:13 am
Yes the log shipping backups will contain all the data/schema affected by DDL and DML actions. It's just like a regular backup.
This can be easily and quickly simulated by setting...
October 29, 2007 at 5:06 am
Also, how big are the databases involved in the ETL process?
Anything over 2GB and you'll definitely have an I/O bottleneck. Another design issue that the architect should have planned for...
October 29, 2007 at 4:36 am
Peter Gadsby (10/26/2007)
It seems that indexing dropping/creation is causing an issue
Do you need to drop all the indexes and re-create them? Have you run though a test scenario with at...
October 29, 2007 at 4:34 am
If they are all pointing to the same database, then a likely reason is parallelism. A connection can only be used by one task at a time. If you have...
October 29, 2007 at 4:25 am
Ok, if 'C:\Documents and Settings\Admin\Local Settings\Temp\SQL.txt' is the file name then it's nothing to do with SQL Server.
Its the log file created by an ODBC datasource.
Check this,
October 29, 2007 at 4:22 am
Check the same backup tables on the standby, they'll have the restore information.
October 25, 2007 at 4:15 pm
VAIYDEYANATHAN.V.S (10/25/2007)
October 25, 2007 at 5:09 am
Kenneth is correct in saying that the inbuilt log shipping is only available for those editions.
With a custom built solution based on scripts, you can run on any edition of...
October 25, 2007 at 4:27 am
I believe that by definition a function that is used to set/retrieve a constant should be used as you've shown.
Putting my mis-shaped, ill-fitting programmer hat on, isn't it standard practice...
October 16, 2007 at 2:39 am
Viewing 15 posts - 121 through 135 (of 2,483 total)