Viewing 15 posts - 2,101 through 2,115 (of 2,462 total)
Rob44 (3/8/2010)
Let's suppose the command returns 0! What's the next step if the rebuild of the index in the maintenance plan is unsuccessful?
We can give manual run to ALTER INDEX...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 10, 2010 at 6:22 am
Jeff Moden (3/9/2010)
See the following:
Very nice post
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 10, 2010 at 3:42 am
pshaship (3/9/2010)
Declare @DBName varchar(50)
Set @DBName = 'YOURDBNAME'
Select Db_name(ps.database_id) as DBName,object_name(ps.object_id) as TableName,I.name as IndexName
,sum(isnull(ps.avg_record_size_in_bytes,0) * isnull(ps.record_count,0)) as IndexSizeBytes
...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 10, 2010 at 3:37 am
try this DECLARE @Ranges_1 TABLE (
[ctr] int identity ,
[Id] int NOT NULL,
[varchar](3) NOT NULL,
[dos] int NOT NULL,
[paid] float NOT NULL
)
INSERT INTO @Ranges_1 VALUES (1, '123', '20', '10.75');
INSERT INTO @Ranges_1...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 10, 2010 at 3:26 am
Saravanan_tvr (3/10/2010)
Select sum(stock1),
(Select sum(stock2),item_no from table1
where date = '2010-01-02' group by item_no) as [stock on hand],
item_no...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 10, 2010 at 2:59 am
sinamora (3/9/2010)
12 3 ...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 10, 2010 at 2:52 am
You should need to review the error log file...if any database in recovery mode then you might get this error. if you can post the error log file where you...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 9, 2010 at 10:52 pm
Post your table and index definition along with exec. plan
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 9, 2010 at 10:51 pm
Read below post
http://technet.microsoft.com/en-us/library/ms191284.aspx
And why we require to do it
http://support.microsoft.com/kb/873235
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 8, 2010 at 7:47 am
ajarman (3/8/2010)
the job failed with 'unable to connect to SQL server...'.In the SQL error logfile I see:-
Are other jobs running fine ?
can u using the same (this job's)account for...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 8, 2010 at 7:36 am
Thanks:-)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 8, 2010 at 12:34 am
arr.nagaraj (3/7/2010)
As a quick fix, you can use the fourth option 'Be made using this security context' and provide a user id and password of a account in server2.
can you...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 8, 2010 at 12:07 am
Run your job with the same accounts which is being used to run sql server agent.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 7, 2010 at 11:05 pm
YOu should post Sql server 2008 related question on sql server 2008 tabs.this is for sql server 2005 😛
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 5, 2010 at 7:50 am
saranram_forum (5/11/2009)
I got error "A critical error occurred:instance failure" while i entered next button.
Which next button ? when u got this error ?
what were you trying to do this...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 5, 2010 at 7:48 am
Viewing 15 posts - 2,101 through 2,115 (of 2,462 total)