Viewing 15 posts - 3,106 through 3,120 (of 6,679 total)
Syed Jahanzaib Bin hassan (7/1/2011)
For In Raid 10
==========
Drive 1 : Data-Files
Drive 2 : Log -...
July 3, 2011 at 7:26 pm
It is possible that it is taking a long time to recover because you have a large transaction log - with a lot of active VLF's.
How large is your transaction...
July 3, 2011 at 9:34 am
Check with the team that manages the SMTP server - see if they are using any filtering to allow only defined servers to send mail. Also, validate any credentials...
July 3, 2011 at 9:30 am
Sorry - that doesn't make sense to me. If you are getting actual duplicate values - you have an issue with your query. Otherwise, your totals would be...
July 2, 2011 at 8:22 am
You should probably work on eliminating the duplicates from the data - instead of trying to hide the duplicates in the report.
July 1, 2011 at 2:24 pm
Sean Lange (7/1/2011)
July 1, 2011 at 2:20 pm
I would recommend that you check the recovery model of the source database. Is it full recovery? If yes, are you backing up the transaction log on a...
July 1, 2011 at 1:41 pm
I may be missing something here, but why would you pad a numeric value with spaces at the end? I would think a better format would be to pre-pend...
June 29, 2011 at 2:29 pm
Could you switch this up and provide the users with an Excel spreadsheet that accesses the database and refreshes the data?
Excel has the ability to run queries against ODBC/OLEDB data...
June 28, 2011 at 8:24 pm
You have two problems with your queries. In the first query, you have essentially turned it into an INNER JOIN by including a column from the unpreserved table (outer...
June 27, 2011 at 8:20 pm
In addition to what others have pointed out - you should always specify the length of the data type when casting or converting. Using this:
SELECT convert(varchar, duedate, 112) FROM...
June 27, 2011 at 8:10 pm
Why not use a utility like WinRAR to compress and span (if needed). Most likely, using a compression utility will give you a long time before you have to...
June 27, 2011 at 2:56 pm
Why would you have the same function in multiple databases that do different things?
Or, do you have a single database that contains these functions but you do not know the...
June 27, 2011 at 2:36 pm
coder_t2 (6/26/2011)
June 26, 2011 at 6:45 pm
george sibbald (6/24/2011)
These need applying in a controlled manner at agreed times, backups taken, with testing afterwards and a backout in...
June 25, 2011 at 11:53 am
Viewing 15 posts - 3,106 through 3,120 (of 6,679 total)