Viewing 15 posts - 181 through 195 (of 469 total)
ALTER INDEX ALL ON Production.Product
REBUILD WITH (FILLFACTOR = 80, SORT_IN_TEMPDB = ON,
STATISTICS_NORECOMPUTE = ON);
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 12, 2009 at 11:09 am
Well its fine if you click them until you are not able to open them. I reckon when we click on a database file be it mdf,ndf or ldf it...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 11, 2009 at 1:54 pm
Explain just files?
Also, if you say just files do you mean you are able to open them?
At last see the properties of the database to check the file names whether...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 11, 2009 at 1:02 pm
I would check the stored procedure that the reports run on. See if there is any blocking or you could try to look at the code of the sp and...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 11, 2009 at 12:40 pm
Did you configure DB Mail to use an SMTP server when creating the profile?
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 11, 2009 at 10:54 am
Thasos Perifimou (2/11/2009)
Will this affect our log shipping?
Answer is NO, but-->
The bulk-logged recovery model increases the risk of data loss for these bulk-copy operations, because bulk logging operations prevents recapturing...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 11, 2009 at 10:42 am
Why do you need to reindex everyday, that too entire database?
Anyways you can switch to bulk logged recovery before you begin reindex and once you are done switch it back...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 11, 2009 at 8:02 am
beerampradeep (2/11/2009)
what is the use of logshiping , replication and DTS.
You can always start with google and also bol. As and when you get issues with the setup you...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 11, 2009 at 6:33 am
ichbinraj (2/10/2009)
We have recommendations from team- lead to increase the datafiles in db ...he suggested us to maintain ratio 2:1 (datafiles :Processors )
Does he intend to mean that 2:1 ratio...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 10, 2009 at 2:19 pm
ichbinraj (2/10/2009)
if I add file according to your specification do I need to restart the MS SQL server ?
As a DBA always learn to say No and please Question as...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 10, 2009 at 2:16 pm
ichbinraj (2/10/2009)
I have 2TB database in production which has 1 MDF file ,2NDF files i am Planning to add one more datafile with out any down time...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 10, 2009 at 1:56 pm
gupta1282 (2/10/2009)
Could you provide me some onlie...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 10, 2009 at 9:24 am
You can use MyReports folder to allow users to manage their own content.MyReports is disabled by default. One MyReports folder is created for each user. One user doesn't have access...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 9, 2009 at 2:51 pm
Access to the folder only
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 9, 2009 at 1:42 pm
I would check the terminal services connectivity to the rebooted system. Also to check how long your server that was rebooted takes to come back online.
You can ping the server...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 9, 2009 at 9:58 am
Viewing 15 posts - 181 through 195 (of 469 total)