Viewing 15 posts - 16 through 30 (of 82 total)
If it is production environment and if you need disaster recovery it is always better practice to keep auto grow property enabled on log file.
If it is Dev or test...
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
June 14, 2010 at 3:26 am
enable the auto growth property of the transaction log, and you should have sufficient space on the drive. hope this will help you.
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
June 14, 2010 at 12:57 am
here is the link 😉
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
June 10, 2010 at 4:24 am
In the management studio, access the login properties of FMUSER under the security and logins folder go to the user mappings tab you can see the actual mappings for the...
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
June 10, 2010 at 4:21 am
People are always willing to respond or help to people who try their best and if the fail to get what they need, I am sorry if I said something...
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
June 10, 2010 at 12:55 am
Try take a look at this article, linked articles in it
http://technet.microsoft.com/en-us/magazine/2009.07.sqlbackup.aspx
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
June 10, 2010 at 12:23 am
I don't know how much more money or anything else an MVP can make, I dont know how it make any difference.
But I am learning a lot and I...
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
June 10, 2010 at 12:21 am
When you create a database it will create a copy of model database with new name and settings what every you set, and whenever a new database is created it...
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
June 8, 2010 at 10:27 pm
Try This
declare @sql2 varchar(8000),
@dbname char(30),
@sql3 varchar(8000),
@sql4...
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
June 8, 2010 at 2:19 am
Try this
SELECT id, so.name, Rows FROM dbo.sysindexes si
INNER JOIN sys.objects so
ON so.[object_id] = si.ID
WHERE si.indid < 2 and so.Type = 'U'
ORDER BY 2
Hay WayneS let me...
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
June 3, 2010 at 2:33 am
It is a warning message, it occurs as row size of your temp table is grater than the size of the maximum row size.
If you can post the temp table...
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
June 3, 2010 at 2:14 am
Nagesh S-432384 (6/3/2010)
Jeff Moden (6/2/2010)
Very cool feedback, Nagesh. Thank you for taking the time.
one more late response Jeff 🙂 I am in IST (in India) so I will be...
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
June 3, 2010 at 2:04 am
If you have done In Place upgrade you cant access, if you have done side by side upgrade then you can.
Nag
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
June 3, 2010 at 1:40 am
Jeff Moden (6/2/2010)
Very cool feedback, Nagesh. Thank you for taking the time.
one more late response Jeff 🙂 I am in IST (in India) so I will be always late...
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
June 3, 2010 at 1:36 am
Viewing 15 posts - 16 through 30 (of 82 total)