Viewing 15 posts - 1,861 through 1,875 (of 2,462 total)
These kind of task generally done in off peak hours with the proper intimation to users
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 19, 2010 at 3:18 am
put the database in SINGLEUSER mode and then do the alteration
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 19, 2010 at 2:18 am
Apart from DTA, did you see the execution plan and found anything which disturbs the performance like table spool/lookup etc ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 19, 2010 at 2:07 am
i think, you can explicitly map that user with that table.try it
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 19, 2010 at 12:21 am
Ryan D. (4/16/2010)
I dont see how to setup for a tsql step.
create a proxy account and used that account in job.is that what your are looking for ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 18, 2010 at 1:41 am
Need a lot of patience to study your SMALL queries. but you can do one thing. put the result( same data ) of above queries on let say two...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 16, 2010 at 8:21 am
clive-421796 (4/15/2010)
myProc should run in a loop while the date is between '2010-01-06' and '2010-01-25'.
if there is Date range then
below should work
CREATE PROCEDURE proc_student
@Start_Date datetime,
@end_date...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 16, 2010 at 8:12 am
Duran (4/15/2010)
I have a question regarding indexing, is it good practice to have a clustered and non-clustered index on the same column?
i am taking your question other way. just...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 16, 2010 at 7:50 am
Enable DatabaseMail on the SQL Server Agent -> properties -> Alert System (check the checkbox), and then restart SQL Server Agent.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 16, 2010 at 7:32 am
sohaib.nomani (4/8/2010)
use mastergo
SELECT sid FROM dbo.sysxlogins WHERE name = 'sa'
2.0xFFBC9E1A55F9934EA4AFDEAE8AF9771C
I didnt understand how redundant logins exists in msdb ? two Sa account is very weird thing.Try exec...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 16, 2010 at 4:02 am
You should have been posted this issue in sql 2008 section to get faster(any) response.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 16, 2010 at 3:47 am
Lynn Pettis (4/14/2010)
If the new location (MOVE clauses in the RESTORE DATABASE) are fixed, you really don't need dynamic sql to accomplish the RESTORE.
Nice thinking Lynn
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 16, 2010 at 3:43 am
This Sp will give you details of every database use aaa
GO
create PROCEDURE [dbo].[sp_SDS]
@TargetDatabase sysname = NULL, -- NULL: all dbs
@Level...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 16, 2010 at 3:38 am
Viewing 15 posts - 1,861 through 1,875 (of 2,462 total)