Viewing 15 posts - 166 through 180 (of 1,068 total)
It is possible with trigger right?
But, warehouse data need not be up-to-date with OLTP data right?
June 19, 2012 at 4:11 am
how to ensure that correct execution plan is created and used every time it executes ?
Add OPTION (HASH JOIN) at the end of the query.
how to check the difference between...
June 19, 2012 at 12:55 am
Ramana P (6/18/2012)
...I have replication in same server with different database,
Why are you replicating in same server with different database?
Have you checked the Replication Monitor? Have you checked the...
June 18, 2012 at 11:23 pm
I think this error message is NOT from replication.
It could be from CDC (change data capture) or some thing like that.
Do some investigation. Check all SQL Agent jobs, triggers, etc....
June 18, 2012 at 4:31 am
No. You cannot move a table between datafiles in a single filegroup.
SQL Server uses proportionate fill algorithm. That is, data would be spread evenly accoss the data files.
June 15, 2012 at 4:48 am
No. You cannot move a table between datafiles in a single filegroup.
SQL Server uses proportionate fill algorithm. That is, data would be spread evenly accoss the data files.
June 15, 2012 at 4:47 am
vaithi.saran846 (6/15/2012)
if i see the job history, first step has taken only 3 seconds, but the second step is keep on running for 14 hours.
I guess, something is blocking...
June 15, 2012 at 4:42 am
Does SQL move whole tables to separate datafiles
No. SQL may move a table to different data files (beloging to same FILEGOUP)
can tables exist in multiple datafiles?
Yes. A table can...
June 15, 2012 at 4:33 am
thamaraiselvan (6/15/2012)
could you explain it more why ?what could be the possible performance impact / gain in this?
AutoClose - Whenever the last user disconnects fron the DB it is closed....
June 15, 2012 at 3:41 am
thamaraiselvan (6/15/2012)
4. auto close - set it as 'TRUE'5. AUTO SHRINK - set it as 'TRUE'
Firstly, set these to FALSE
June 15, 2012 at 3:32 am
miriyalasrihari (6/14/2012)
..then Table3 contains more rows, i need to decrease this, is there any other way?if yes please suggest me..
Why do you need to decrease this?
I would say, don't worry...
June 15, 2012 at 3:28 am
sudhanva (6/15/2012)
We identified that the SSAS Cube size is going to 100GB and Database size would be 500GB. I am curious to know if SQL Server 2008 R2 has the...
June 15, 2012 at 2:56 am
Try this simplied example:
create table Tab1(id int, data char(10))
begin tran
insert into Tab1 values(1, 'One')
select OBJECT_NAME(resource_associated_entity_id) 'ObjectName'
from sys.dm_tran_locks
where resource_type = 'OBJECT'
commit
June 15, 2012 at 1:40 am
It is possible to get this from sys.dm_tran_locks
June 15, 2012 at 12:49 am
SQL Server service should be running under Domain acccount (not local system) to access shared folder.
June 14, 2012 at 3:24 am
Viewing 15 posts - 166 through 180 (of 1,068 total)