Viewing 15 posts - 226 through 240 (of 469 total)
Is this an Active-Active cluster or Active-Passive?
You must assign the resources from Cluster manager and then specify the possible owners. Make sure the node you have SQL running on can...
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 4, 2009 at 9:03 am
Why open a cursor when you can do it in a simple way..try this..
alter database [db_name] set SINGLE_USER with rollback immediate
go
alter database [db_name] set MULTI_USER with rollback immediate
go
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 4, 2009 at 8:55 am
The results returned by sp_spaceused cannot be relied as perfect. Run DBCC updateusage (yourdatabase) with no_infomsgs,all_errormsgs and check what is the free space again.
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 4, 2009 at 8:50 am
What activity is it? with that I mean to ask if its a query or SP or job that is taking too long all of a sudden..
Also as Gail said...
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."
January 23, 2009 at 1:37 pm
nitin.saha (1/23/2009)
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."
January 23, 2009 at 1:34 pm
Well, it being an interview question you have to answer this in a stipulated amount of time, the answer could be as:
1. If report is not working then run profiler...
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."
January 23, 2009 at 1:31 pm
Running CHECKDB is fine, to avoid performance issues I would be glad to do it on a test box, by grabbing a copy of the production backup. But even with...
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."
January 22, 2009 at 3:08 pm
If you wanna corrupt it time and again after you try repairing then backup the clean database before you start corrupting it..
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."
January 22, 2009 at 2:16 pm
Thanks Paul for your insight, also thanks Gail for your suggestions.
Apparently I got rid of all the errors from CheckDB by running repair with allow data loss statement. Also there...
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."
January 22, 2009 at 2:11 pm
Run profiler and check for events like SP:starting ,SP:Recompile,SP:stmtcompleted and SQL:Batchstarting while running this report.
Not to mention the code for this SP can also be checked by viewing the execution...
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."
January 22, 2009 at 11:46 am
One way to investigate, is to run the SQL Server Profiler with the default template. If you see an Audit Login event, then there is a new connection.
If you see...
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."
January 21, 2009 at 1:35 pm
My advice would be to go for a Windows 2003 Cluster, which is more stable and easy to install. What are your options- Inplace upgrade or side by side?
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."
January 14, 2009 at 10:15 am
The user who creates the database is set to as the owner of the database, which you can see in the options tab of properties...and yes, it can be changed...
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."
January 14, 2009 at 10:10 am
AndyG (1/14/2009)
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."
January 14, 2009 at 9:50 am
Looks to be a problem with your disk, check and see if it needs to be defragmented.
Also what RAID array is it? If so how many spindles is it made...
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."
January 13, 2009 at 10:34 pm
Viewing 15 posts - 226 through 240 (of 469 total)