Viewing 15 posts - 76 through 90 (of 2,462 total)
try this
INSERT INTO Company2.dbo.CUSTVEND
SELECT *
,CASE WHEN DIVISION='DIV1' THEN 'DIV2' END
FROM Company1.dbo.CUSTVEND c1
WHERE not exists (SELECT 1 FROM Company2.dbo.CUSTVEND c2
...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 28, 2013 at 4:27 am
What dioes this returns exec usp_Main_TEST @CustID = '123'
Actually your no. of columns return from Sp are nto matching with temp table coluimns count ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 28, 2013 at 4:24 am
Does the testing script has similar exec plan in both the environment ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 28, 2013 at 4:11 am
aeri_q (10/26/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 28, 2013 at 3:02 am
PearlJammer1 (10/27/2013)
will the new columns get replicated?
No
PearlJammer1 (10/27/2013)
do we need to create a new initial snapshot of the publication?
Yes. Transactional replication only replicate DML operation. see http://technet.microsoft.com/en-us/library/ms151706(v=sql.105).aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 28, 2013 at 2:24 am
Worth reading here http://www.dbsophic.com/SQL-Server-Articles/sql-server-logical-reads-what-they-really-tell.html
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 25, 2013 at 6:58 am
Francis,
Can ypu try one more thing ?
start the profiler and look for "Sort Warning" option and see if its is coming when you execute the SP ?...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 25, 2013 at 6:33 am
SscLover (10/25/2013)
yes server memory is one of aspect...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 25, 2013 at 5:48 am
Francis Kioko (10/24/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 25, 2013 at 4:05 am
ElijahE (10/24/2013)
Adding a clustered index fixed it. After adding the clustered index on those two columns the query returns in 0 seconds.
it will actually it must be ....
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 25, 2013 at 2:04 am
Francis Kioko (10/24/2013)
When i set the Max memory setting to anything below this value the query executes in less than 2 secs.
i dont think reducing memory can ...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 24, 2013 at 7:09 am
Sanjay Thakur-488205 (10/23/2013)
Kindly advice the same How to remove/ Delete Transaction Log from SQL Server 2008 R2. as previously we are using SQL Server 2000 Detach database and remove log...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 24, 2013 at 4:43 am
INdexes is definitely a MUST thing here or everywhere .
other thing can below will return the same data too ?
;WITH e_Dupe AS
(
SELECT mcrn
,mpidm
FROM Registration_loaderr
WHERE error_check = '142285'
GROUP BY...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 24, 2013 at 4:25 am
Sqlsavy (10/24/2013)
When I restart SQL server will it pickup new location (B)...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 24, 2013 at 4:09 am
declare @updatedef table ( id int identity, tablename varchar(30), columnname varchar(50), Status_fl bit)
declare @max-2 int ,@cnt int ,@lstr varchar(200),@tablename varchar(30),@columnname varchar(50)
set nocount on
insert into @updatedef (tablename,columnname,Status_fl )
select 'emp',...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 24, 2013 at 3:59 am
Viewing 15 posts - 76 through 90 (of 2,462 total)