Viewing 15 posts - 1,546 through 1,560 (of 2,462 total)
Use PIVOT TABLE approach
USE DOMAIN_DBA
GO
DECLARE @t TABLE (EMP_ID int , Contact_type nvarchar(50), Contact_Number nvarchar(300))
INSERT INTO @t
SELECT 1 ,'Home' ,'92 - 51 - 225478'
UNION SELECT 1, 'Cell', '92 - 131...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 14, 2010 at 12:02 am
post your query
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 13, 2010 at 11:26 pm
duplicate post http://www.sqlservercentral.com/Forums/Topic952011-338-1.aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 13, 2010 at 11:21 pm
refer this link http://technet.microsoft.com/en-us/library/cc966392.aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 13, 2010 at 10:57 pm
Dont cross post , its simply wastage of time
reply on this http://www.sqlservercentral.com/Forums/Topic950491-145-1.aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 13, 2010 at 5:43 am
i think there is some access restriction, copy that backup file to the local drive of server (where your want to restore it) then do the restoration.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 13, 2010 at 4:41 am
Replace your DTEXEC.exe 64 bit with the DTEXEC.exe(32bit). but i am not sure about the impact it will cause.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 13, 2010 at 4:01 am
Jason Shadonix (7/9/2010)
I also set the MAXDOP option to 1 to "slow it down" a little bit to help mirroring keep up.
Whats the benefit you got with it...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 9, 2010 at 7:09 am
Check the page count , if it is near about 1000 as gail suggest, there would be no impact of defragmentation.
select object_name(object_id),page_count,* from sys.dm_db_index_physical_stats (22,null,null,null,null)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 9, 2010 at 6:43 am
The reason to stop mirroring is : if i rebuild the indexs of larger tables, log will grow tramendously.and same size (log) will be replicated to report node also. so...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 8, 2010 at 9:55 pm
My take would be like this :
1. disable the mirroring ,
2. do the index rebuild/reorgnize
3. restore latest backup and log backup on OLAP node
4. shrinking...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 7, 2010 at 7:07 am
thabang.mogano (7/7/2010)
so, would using the #table be better than using the table variable?
Depends
Temp tables
Behave just like normal tables, but are created in the TempDB database. They persist until dropped,...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 7, 2010 at 6:03 am
I still stuck with his problem , please help me
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 7, 2010 at 4:17 am
If updation has happened, following query should give same output for both selected columns
SELECT P.Specialty , T.Specialty
FROM SomeTable P
LEFT JOIN temp T
ON P.id = T.id
WHERE P.Specialty...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 6, 2010 at 11:58 pm
select object_name(constid),object_name(id),* from sys.sysconstraints
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 6, 2010 at 10:28 pm
Viewing 15 posts - 1,546 through 1,560 (of 2,462 total)