Viewing 15 posts - 226 through 240 (of 489 total)
As Jason says 11GB isn't very large.
Could you give a bit more detail here? Like what is the growth rate? Are there any specific tables that are unusually large? Are...
July 19, 2011 at 4:52 pm
Be careful about buying SQL 2008 vs SQL 2008 R2.
In R2 Standard Edition Microsoft have limited the memory usage. In 2008 it was OS Maximum, but with 2008 R2 this...
July 19, 2011 at 3:33 pm
After much research that lead no where, I came across an unrelated article that mentioned the DCOM component MSDtsServer100 and configuring it's end points, so I did a bit of...
July 14, 2011 at 10:27 pm
Further to my original post, I've now been able to link an error in the application event log on the server I'm trying to connect to:
Date ...
July 13, 2011 at 4:28 pm
Scripting restores for 130 odd databases isn't that much trouble since all the information is in tables you can create a single script that generates the restore scripts for all...
July 13, 2011 at 2:20 pm
Further to my previous e-mail I hve picked up that there are 2 installations of SSIS 2008R2 on different servers in the domain, both running under the NT Authority\NETWORKSERVICE account.
When...
July 11, 2011 at 8:52 pm
You can try using BCP and define the -t and -r switch both as |.
C:\Users\leo>bcp scratch.dbo.TestTable out C:\temp\pipeOut.txt -S MyTestServer\SQL2008 -T -t"|" -r"|" -n
I tried the above and it accepted...
July 5, 2011 at 9:22 pm
Much lower risk is to backup the database, then log on with the sa account, then restore it from the backup you just created. The database will be owned by...
June 29, 2011 at 3:57 pm
If you could expand on the actual issue there may be a solution out there. I don't see that using temp tables should cause locking, and TempDB growing isn't in...
June 16, 2011 at 8:24 pm
What about chached query plans? These are cleared on startup, could the cached plan no longer be effective? Have you tried doing a DBCC FREEPROCCACHE and seeing how things perform?
Also...
June 16, 2011 at 5:05 pm
Change is Required (6/8/2011)
Can we access Secondary Server in Logshiiping or Can we mirror server in mirroring .?if yes explain
As has been mentione the answer to the first question...
June 8, 2011 at 10:17 pm
If you are really concerend you can do a DBCC DropCleanBuffers, but remember this will also affect performance as it flushes all currently "clean" buffers from the buffer pool, where...
June 6, 2011 at 2:26 pm
shaili (5/11/2011)
Our Dev guys are referring to this document from Microsoft:
This article has a smal section in Lockdown of System Stored Procedures (pagers 13-14) that raises sp_send_dbmail as a system...
May 11, 2011 at 5:39 pm
from the way you have worded your question we need to clarify the real issue.
The single point of failure is really the SAN, which may include disk, power or connectivity....
May 5, 2011 at 10:32 pm
kumar.sachu08 (4/11/2011)
. I just did a right click on SQL Server Agent inManagement Studio and manually restarted the service...but still not work.
Did you try restarting it from Configuration Manager or...
April 11, 2011 at 10:31 pm
Viewing 15 posts - 226 through 240 (of 489 total)