Viewing 15 posts - 346 through 360 (of 2,462 total)
another alternative would be use of profiler with event like sp:stmtstart and sp_stmtcompted this will give you cpu, IO , memory usage
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 1, 2013 at 2:34 am
chauhan_5041 (1/31/2013)
I am new SQL DBA can you please give contact number or net address so time to time I will ask our personal question with him.
personal contact or...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 1, 2013 at 12:25 am
chauhan_5041 (1/31/2013)
any body tell me that what is daily / weekly / monthly activity of perfect DBA regarding Index performance.
see this link you will get enough material...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 1, 2013 at 12:21 am
jdbrown239 (1/31/2013)
I have sql 2005 standard edition on windows server 2003.
are you using 32 bit server ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 1, 2013 at 12:17 am
you can use LEFT JOIN also like
declare @t table (id int , addr nvarchar(20))
declare @t1 table (id int , addr nvarchar(20))
insert into @t
select 1, 'sdAD' UNION
select 2,...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 1, 2013 at 12:16 am
pretea (1/31/2013)
Do I just execute the stored procedure in sql job or whole script..
better use "usp_long_running_jobs" SP in job as step.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 31, 2013 at 11:33 pm
a lots of facitor,
1) are you taking backup on local drive or on network ?
2) how fast is the disk and is this is dedicated or not ?...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 31, 2013 at 11:20 pm
SQL MOD (1/31/2013)
So as i can outline : tuning indexes is nothing that you can automize...right?
Yes
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 31, 2013 at 4:52 am
maida_rh (1/31/2013)
I tryed TRUNCATE on table but still the same error of PK violation during import/Export.
So it means your source table contains duplicate data ? do you have same...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 31, 2013 at 3:52 am
maida_rh (1/31/2013)
Pk_violation when i tried to import data from current updated source database todestination database.
still you are not clear here , are you populating tables on destination ...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 31, 2013 at 3:32 am
maida_rh (1/31/2013)
yes,through backup file
then how come PK violation ? restore backup do data copy of exact the content in backup , there cant be PK violation
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 31, 2013 at 2:31 am
ChrisM@Work (1/31/2013)
MAX() OVER (PARTITION BY...) might be more appropriate.
New to me 🙂
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 31, 2013 at 1:12 am
maida_rh (1/31/2013)
I tryed the import but got error:
Violation...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 31, 2013 at 1:05 am
Using ROW_NUMBER() with PARTITION .See http://msdn.microsoft.com/en-us/library/ms186734.aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 31, 2013 at 12:24 am
maida_rh (1/30/2013)
Now i need to update database,For know ,I am...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 31, 2013 at 12:06 am
Viewing 15 posts - 346 through 360 (of 2,462 total)