Viewing 15 posts - 8,011 through 8,025 (of 9,715 total)
Mani-584606 (4/29/2010)
Why dont you try shrinking the log ????
I'm NOT sure whether we can shrink the log file size for TempDB or not? I believe it's NOT a good...
April 30, 2010 at 6:13 am
When you retrieve this data, are you only pulling it from one database? Are you connected to that database?
Are you pulling from multiple DBs? Are you using a Linked Server?
April 30, 2010 at 6:11 am
Depends on ownership chaining. Does the same schema own both the view and the table?
April 30, 2010 at 6:09 am
Have you tried right-clicking the Logshipped DB in SSM and going to Properties? You should be able to change the owner there.
Then again, I don't have a logshipped DB to...
April 30, 2010 at 6:08 am
Without knowing the structure of your database or your query, we can't answer that question. Performance depends on too many things for us to blindly say "XYZ".
Post your query with...
April 30, 2010 at 6:06 am
The problem is, you're asking the question in a vacuum of information. Maybe if you tell us what point you're trying to prove or disprove, we could assist you better.
Server...
April 30, 2010 at 6:04 am
You're quite welcome.
Given your description, though, I'm betting it's a combination of too many connections and not a big enough paging file.
April 30, 2010 at 4:35 am
Joy Smith San (4/30/2010)
Many of the prior replies noted Transparent Data Encryption as an option. It was also noted that TDE encrypts the physical data files and not the data...
April 30, 2010 at 4:29 am
Ray,
Check with the Seattle SQL Server Users group. (I'm sure there is one). If no one there is willing or able to help, consider virtual tutoring via some internet...
April 29, 2010 at 11:38 am
Steve Jones - Editor (4/29/2010)
I would NOT recommend this, but how can stopping the service potentially cause data corruption?
I'm not talking about the service stopping itself so much as...
April 29, 2010 at 11:33 am
More details are definitely needed on the whole "not working out" statement.
Given your statement about JOINS taking care of the recordset and not needing a WHERE clause makes me think...
April 29, 2010 at 11:28 am
The best way to monitor object useage is through a Profiler Trace. Server-side is more efficient that GUI version, but either works. Filter your trace to look only for the...
April 29, 2010 at 11:23 am
Google this phrase only:
SSIS A network-related or instance-specific error has occurred while establishing a connection to SQL Server
You'll come up with PLENTY of links.
Things you should look into off...
April 29, 2010 at 11:20 am
Server Properties, Advanced. Remote Login Timeout.
Hope that helps.
You might also want to check the Event logs when this happens to see if they'll tell you anything you don't know.
April 29, 2010 at 11:10 am
You might want to repost this in the Admininstrating General Discussion forum. The backup forum might not be haunted by the people who have the answers you want.
April 29, 2010 at 11:05 am
Viewing 15 posts - 8,011 through 8,025 (of 9,715 total)