Viewing 15 posts - 31 through 45 (of 1,539 total)
Long running Queries? Find their SPids and see what are they waiting on..
November 28, 2011 at 7:57 am
Backups do not interfare with other operations. Have you tried finding if there is any blocking during that period? You said the backups are on some shared drive (assuming...
November 28, 2011 at 6:34 am
This is normal. When SQL Server reaches a particular level of memory uses, It doesn't release it back to operating system unless there is memory pressure. Check your max memory...
November 28, 2011 at 6:02 am
Dev (11/28/2011)
1204 & 1222.Trace Flags (Transact-SQL)
1222 is for 2005 and above.
1204 will work in 2000.
November 28, 2011 at 5:57 am
GilaMonster (9/21/2011)
ps. (9/16/2011)
also, once any data/log file reaches a particular size, it wont free up space on it's own.
Errr, what???
Doesn't matter how large a log gets, assuming nothing is preventing...
September 21, 2011 at 8:35 am
Once a file reaches to a particular size, say 10 GB; even though the used space in the file is few MBs, the physical file size will remain at 10...
September 21, 2011 at 8:32 am
I imported the access db in a staging database. From there all conversions were smooth. database didnt have huge number of records so used normal select into statement with conditions...
September 21, 2011 at 7:55 am
Transactional Replication is the closest you can think of implementing at this stage.
You can also wait for some time before new version of sql server is released where in you...
September 17, 2011 at 8:59 pm
shatrughna (9/17/2011)
Hi,Perhaps some of your queries making lock on table.
Run SP_LOCK and check lock status of your database.
Cant be sure that entire table is locked. It can even be a...
September 17, 2011 at 12:37 pm
Tom.Thomson (9/17/2011)
use master
go
begin
declare @crlf varchar(2)=char(13)+char(10)
declare @sql varchar(max) = ''
select @sql = @sql+'use '+name+@crlf+@command+@crlf+'go'+@crlf
from master.sys.databases
where source_database_id is null and is_in_standby=0 and is_read_only=0
and name not...
September 17, 2011 at 12:27 pm
do you have nightly maintainence jobs? index defrag/dbcc checkdb? are they scheduled to run in parallel? they can consume good amount of tempdb. also, once any data/log file reaches a...
September 16, 2011 at 6:09 am
Also, as you mentioned, rebuild all indexes after the activity to remove index fragmentation. This also updates statistics.
September 16, 2011 at 5:51 am
Daniel Smith-480684 (9/16/2011)
September 16, 2011 at 5:50 am
Daniel Smith-480684 (9/16/2011)
The situation at my current workplace is we have...
September 16, 2011 at 5:27 am
you will need to install 2 instances on the cluster with one of the databases on each instance and run both instances on seperate nodes (active/active).
Get help of experts in...
September 16, 2011 at 2:29 am
Viewing 15 posts - 31 through 45 (of 1,539 total)