Viewing 15 posts - 46 through 60 (of 1,068 total)
shohelr2003 (11/27/2012)
There is no log backup in our plan. If transaction log grows larger, we just shrink the log file to 1 MB.
You can consider to change the recovery...
November 27, 2012 at 2:41 am
Check the setup log and Windows event log. You might find details if any thing failed during setup.
October 25, 2012 at 10:06 am
Looks like you have installed SP on one of the nodes in the cluster.
I think installing SP on other other node would fix the issue.
October 25, 2012 at 9:27 am
Do you get any error message?
Do you have permission to access the distributor?
October 25, 2012 at 8:36 am
stillconfused (10/25/2012)
...I want this job to be completed at any cost every time.
...
You can try this idea:
Make sure that no other session is using this database.
Take the database to...
October 25, 2012 at 8:29 am
sunny.tjk (10/18/2012)
So, indexes can be applied only on columns with integer values?
If it were so, SQL Server would not have allowed you to create index on char type column.
October 18, 2012 at 5:44 am
sunny.tjk (10/10/2012)
So, can I create separate NC indexes on OFFR_TYPE_CD and CRETD_DT columns
No. Single composite index is better.
also can I create a composite index on [LKUP_ID] and [ATTR_VAL]...
October 10, 2012 at 11:29 pm
USE MSDB before running the above...
use msdb;
go
exec msdb..sp_addrolemember @rolename = 'DatabaseMailUserRole'
,@membername = '<myuser>';
October 8, 2012 at 3:55 am
Does SQL Server service account has write access the new path?
October 8, 2012 at 3:49 am
50GB is not large. You should be able to handle it just like any other smaller DB.
Integrity check is a must for all DBs whether small or large.
October 8, 2012 at 3:45 am
If it is on remote server, I guess query should be as follows:
SELECT 1
FROM RemoteServerName.EWH_Staging.dbo.STAGE_REMP_VCC_Distinct vcc
September 28, 2012 at 6:17 am
wedgemail (9/28/2012)
First thing I think is EWH_Staging has been dropped. No EWH_Staging ever existed on the local server
Check whether table/view called STAGE_REMP_VCC_Distinct exists in the database EWH_Staging.
September 28, 2012 at 5:57 am
vijayarani87.s (9/28/2012)
I never used any of this in my project.
You might have used them unknowingly!
For example, when you created a Primary Key constraint, by default it creates a clustered...
September 28, 2012 at 2:34 am
neellotus07 (9/27/2012)
After this i running query "Select * from "Tbl_Inv" then it taking 1.24 minutes but before this it was taking 2.53 minutes to complete
Why are you SELECTing all the...
September 27, 2012 at 6:17 am
Viewing 15 posts - 46 through 60 (of 1,068 total)