So yesterday... I posted a message regarding to transaction logs. I realize that the log are not truncated while a full backup or differentiate backup... Now another question.... I had choose to use log shipping from Primary to Secondary. I select the "Standby" and "terminate users while restore" option on the wizard. Yet, My restore […]
2004-06-17
I started this posting a couple of months ago and now after all this time, I'm still having the same problems - suspected databases daily, long waiting time (time to time - again daily, usually between 12 and 3 pm). We had to go to change all our code to reflect longer waiting periods. Sometime […]
2004-06-17
Possibility:When you get the results from a query, they have to be stored somewhere so they can be displayed. They are not being displayed directly from the database. Maybe your RAM doesn't have enough space to store the results for displaying.Try having the output be to a file instead of the Query Analyzer screen.-SQLBill
2004-06-17
Also, as I said search the articles on this site for information on restoring the Master database.-SQLBill
2004-06-16
You will need to re-install SQL Server on your DR box, then restore the backups. You will also have to repair permissions, as all of your db users will be orphaned. See sp_change_users_login in BOL.Steve
2004-06-15
2004-06-15
It has been documented that a stored procedure automatically recompiles when:If any schema changes occur to any of the objects referenced in the stored procedure. This includes adding or dropping rules, defaults, and constraints.Does this behavior apply to procedures that reference views, where the schema chages occur to the base tables?What are some ways to […]
2004-06-14
1 reads
RESTORE FILELISTONLY FROM DISK = 'c:\Northwind.bak' --This will give you the list of the logical files.RESTORE DATABASE TestDB FROM DISK = 'c:\Northwind.bak' WITH MOVE 'Northwind' TO 'c:\test\testdb.mdf', MOVE 'Northwind_log' TO 'c:\test\testdb.ldf' --This will restore it to the new location.
2004-06-13
I forgot to mention that I really can not use a temp table to store a second copy of TABLE1. There are several DTS jobs that are doing something similar. Each of these DB2 tables contains millions of records that can be up to 30GB. I can not afford to have these DTS jobs creating and […]
2004-06-11
Sorry, I typed the assignment operator ( = ) instead of the equals operator ( == ). Corrected code is shown below:function Main() { var c9 = DTSSource("Col009") var c10 = DTSSource("Col010") if (c9 == null || c9 == "null") c9 = ""; if (c10 == null || c9 == "null") […]
2004-06-10
By Steve Jones
I don’t do a lot of work with disabled index, but I learned how...
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers