Viewing 15 posts - 511 through 525 (of 1,069 total)
polasabhushan (6/20/2011)
...Fullbackup exists but its still giving above message...
When was the full backup taken? Did anything break LSN?
June 20, 2011 at 5:02 am
Is this database is restored/upgraded from SQL Server 2000? If yes, this is normal.
Run DBCC UPDATEUSAGE. It should fix the issue.
June 20, 2011 at 2:49 am
vinaseetha87 (6/20/2011)
Stored Procedure -How to Pass @SortColumn And @SortOrder
I did not understand your question correctly. Stilly try to reply with.
Syntax:
EXEC dbo.spStoredProcedureName @SortCOlumn = 'ColumnName', @SortOrder = 'SortOrder'
For example:
EXEC dbo.spAddressList @SortCOlumn...
June 20, 2011 at 2:40 am
Reinitialize the subscription. Select the check box Generate new snapshot. That should fix your problem.
June 20, 2011 at 2:34 am
Put 4 DATA files only. Not Tlog files.
TLog is written sequentially. So multiple files will not improve the performance.
Data files are written randomly.
(Don't add more than 8 data files...
June 17, 2011 at 12:18 am
There is no blocking issue. You have data file contention issue.
Go ahead and data files of to tempdb. It does not require restarting the service.
Size of the data files should...
June 16, 2011 at 11:51 pm
sqlnes (6/16/2011)
We have heavy IO on tempdb right now and the size of tempdb grow rapidly. We needed to restart service last to solve locking issue.
Our programmers...
June 16, 2011 at 9:53 pm
Hope this helps you. Note the table size. Char table 200KB, varchar table only 16KB.
create table dbo.tbChar
(
idint identity(1, 1),
Datachar(7000),
);
create table dbo.tbVarChar
(
idint identity(1, 1),
Datavarchar(7000),
);
-- Run the following two lines 20 times
insert...
June 16, 2011 at 5:54 am
Try this:
select * from sys.columns where is_sparse = 1 and OBJECT_NAME(object_id) = '<table>'
June 16, 2011 at 12:58 am
mpalaparthi (6/15/2011)
I dont know where it went wrong.
Please give any suggenstions or...
June 16, 2011 at 12:48 am
nsaireddymca (6/15/2011)
some people told when ever we are using char data type memory will be wasted
Not always.
For example,
Customer_Id CHAR(9)
'030902001'
'040507002'
:
there is no wastage here as the data has fixed...
June 15, 2011 at 11:39 pm
sunshine-587009 (6/15/2011)
I'm running the below t-sql, found on microsoft's website, from a job to run on all servers and databases.However, I get the following issues:
1. I only get...
June 15, 2011 at 11:13 pm
azhar.iqbal499 (6/15/2011)
Q No 2:- what would be the effects on publisher if I Insert new data in table at subscriber in transactional replication.
No effect on publisher.
But, if you insert...
June 15, 2011 at 11:04 pm
vinod.saraswat (6/9/2011)
Also looking for suggetion how to manage the index creation in such scenario with optimum time on such large size table.
One suggestion is , create nonclustered indexes...
June 10, 2011 at 1:47 am
vinod.saraswat (6/9/2011)
My question is why the same process is blocking itself.
This can happen when the server has more than one processor and the process is running parallelly on many...
June 10, 2011 at 1:42 am
Viewing 15 posts - 511 through 525 (of 1,069 total)