Viewing 15 posts - 301 through 315 (of 1,109 total)
Lionel E. Nzenze (3/27/2008)
Do a Full backup 1x a week (say Saturday night). Then do Differential Backups Daily (if you must) and caryy on with the Log backups as normal.
Just...
March 27, 2008 at 5:22 am
Ahmad Osama (3/26/2008)
Hello! everyone 🙂Please help me to solve this .... how I should compare Convergys and Congys or similar type of strings...
Regards,
Ahmad
Well, one way to compare them is to...
March 26, 2008 at 8:31 am
Jeff is right, if you want point-in-time recovery you will need Full recovery mode.
Concerning whether you can decrease the frequency of full backups, test, test, test, test! Imagine you...
March 26, 2008 at 7:54 am
karthikeyan (3/26/2008)
I have to tune a SP which has more than 3000 lines.
...
My Questions:
1) Can we use more CASE statement in a single SELECT ? will it affect the...
March 26, 2008 at 6:55 am
Anchelin (3/26/2008)
I have a 1 TB database, recovery set to Bulk-Logged. I did a full backup of the database and applied log backups every 30 mins.
My question/concern is, is...
March 26, 2008 at 5:58 am
SriSun (3/25/2008)
This is one of the example code.
create table dbo.employee(ename nvarchar(32))
insert dbo.employee values('Sri')
insert dbo.employee values('Mike')
declare @tablename nvarchar(128), @column_name nvarchar(32), @value nvarchar(32)
declare @emp_status...
March 25, 2008 at 10:10 am
shikha.ssrivasatav (3/25/2008)
hi friends :),can u help me about partial database recovery?
how to perform this and what is this with example?
thanks,
Shikha Srivastava
Books online has a good description of this http://msdn2.microsoft.com/en-us/library/ms177425.aspx
Basically you...
March 25, 2008 at 5:51 am
mjsteele (3/20/2008)
Andras your solution worked. Thank you so much and I am sorry I doubted it at first.
No worries 🙂 I'm glad that your problem is now resolved,
Regards,
...
March 20, 2008 at 9:58 am
Matt Miller (3/20/2008)
Or - DBCC shrink to a size smaller than the initial size you wish. THEN issue the ALTER DATABASE command. No database service restart needed.
Matt is...
March 20, 2008 at 8:51 am
Just one more comment, you cannot set the initial size of tempdb to be smaller than the size of your model database, so if you have modified the size of...
March 20, 2008 at 8:28 am
mjsteele (3/20/2008)
No it deals with SIZE, which is different than INTIAL SIZE.
🙂 Well, one more try:
Management Studio will ignore your attempt to set the size of tempdb to an initial...
March 20, 2008 at 8:21 am
mjsteele (3/20/2008)
March 20, 2008 at 8:02 am
Read http://support.microsoft.com/kb/307487
It lists three was to lower the configured size of tempdb (and it explains this better than I could in a post response 🙂
Regards,
Andras
March 20, 2008 at 7:44 am
SriSun (3/20/2008)
I have two parameters
@param1 = dbname.username.table_name
@param2= value
Is there any way that I pass these two parameters to a function and return a bit value either...
March 20, 2008 at 7:40 am
How much data do you have in your table/view? Are your statistics up to date? If use an index hint in your query, does it speed up your query?
Regards,
...
March 20, 2008 at 5:19 am
Viewing 15 posts - 301 through 315 (of 1,109 total)