Viewing 15 posts - 781 through 795 (of 1,065 total)
Mani (8/12/2009)
-T1222 is on our server and I'm getting dead lock graph in error log whenever a dead lock occurs. But how to deal with Blocking?
select * from sys.dm_exec_requests
where blocking_session_id...
August 13, 2009 at 3:18 am
You need to shrink the file using DBCC SHRINKFILE command or the UI.
August 7, 2009 at 4:10 am
Hi Chandu,
I think CHECK constraint checks AFTER insertion of data. If we do row count in the ckeck constraint it will have the new row. See the following example:
CREATE TABLE...
August 7, 2009 at 2:47 am
It (what you did ) is in-place upgrade.
They are not options what you see on the setup screen. They are methods how you upgrade. If you upgrade the existing...
August 6, 2009 at 11:53 pm
Also consider copying the records in smaller batches.
http://sql-server-performance.com/Community/forums/p/11750/11750.aspx
declare @minID intdeclare @maxID int
declare @batchStart int
declare @batchSize int
set @batchSize = 25000
select @minID = min(id), @maxID = max(id)from sourceTable
set @batchStart = @minIDwhile...
August 6, 2009 at 7:02 am
mahesh.vsp (8/5/2009)
Thanks Victor.Is there any query to retreive the whether to know it is an Evaluation and Developer Edition.
select @@version shows whether it is Evaluation or Developer Edition.
select @@version
Microsoft SQL...
August 5, 2009 at 5:36 am
Maintenance Plans are stored in the msdb database. So take backup of msdb database.
August 5, 2009 at 3:50 am
charipg (8/4/2009)
thanks.........a table without primarykey.
i am trying to transactional replicate then it popup error as it is not possible to replicate without primarykey.
can u pls let me know the reason.
The...
August 4, 2009 at 5:31 am
litu deb (7/21/2009)
How to check through TSQL/SSMS which table is not synchronised in transactional replication?
For eaxample: suppose table is not synchronised ,it has 100 rows in publisher but...
July 26, 2009 at 1:18 am
BOL
C2 audit mode saves a large amount of event information to the log file, which can grow quickly. If the data directory in which logs are being saved runs out...
July 23, 2009 at 6:51 am
Have you Enabled C2 audit tracing?
I think C2 audit tracing is enabled and SQL Server is not able to write to it due to lack of disk space or other...
July 23, 2009 at 6:34 am
Glad to know that it works well.
But, I have concerns 🙁
Is it a production server? One should be carefull while issuing KILL command on a production server.
Do you have...
July 23, 2009 at 5:16 am
Best Practice, Books Online, In My Openion.
July 23, 2009 at 4:12 am
Viewing 15 posts - 781 through 795 (of 1,065 total)