Viewing 15 posts - 121 through 135 (of 469 total)
But I don't think using a Trigger to fire upon Zero database activity would be a perfect solution too, as sometimes there may not be an activity for a certain...
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 8, 2010 at 8:58 am
Is the 60b database on the same server as the 40GB db? as the time could vary depending on the server configuration on which the database resides.
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 8, 2010 at 8:09 am
shondelle (1/8/2010)
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 8, 2010 at 8:00 am
Jonathan Kehayias (1/5/2010)
Krasavita (1/5/2010)
Is there any documentations that I can find out on that. What should I run to see how much memory used for all instanses.Thank you
Which specific part...
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 8, 2010 at 7:53 am
homebrew01 (1/7/2010)
Oksana March (1/7/2010)
Personally, I hate it when someone tells me to Google something. Everyone knows that option is there, so it's like they don't want to answer the question.
I...
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 8, 2010 at 7:48 am
Steve Jones - Editor (1/8/2010)
Roy Ernest (1/8/2010)
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 8, 2010 at 7:36 am
You can use Setup to uninstall SQL Server Reporting Services or remove specific components. Both the Installation Wizard and command line setup can be used to remove or modify an...
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 8, 2010 at 7:32 am
CirquedeSQLeil (1/6/2010)
Dave Ballantyne (1/6/2010)
GilaMonster (1/6/2010)
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 8, 2010 at 7:27 am
GRE-452109 (1/7/2010)
The_SQL_DBA (1/7/2010)
Oksana March (1/7/2010)
Bru Medishetty (1/7/2010)
The_SQL_DBA (1/7/2010)
Bru Medishetty (1/7/2010)
Krasavita (1/7/2010)
How many db can we have per server and how much memory in total can I have?Thank you
You can start...
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 7, 2010 at 3:40 pm
You might need to detach the database and then reattach with the .mdf that you have.
EXEC sp_detach_db 'dbname'
EXEC sp_attach_single_file_db @dbname = 'dbname',
@physname = N'C:\dbfile.mdf';
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 7, 2010 at 3:36 pm
Oksana March (1/7/2010)
Bru Medishetty (1/7/2010)
The_SQL_DBA (1/7/2010)
Bru Medishetty (1/7/2010)
Krasavita (1/7/2010)
How many db can we have per server and how much memory in total can I have?Thank you
You can start creating databases...
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 7, 2010 at 3:24 pm
cherie j sheriff-437357 (1/7/2010)
I am absolutely more interested in databases. Then Programming after that. Networking itself doesn't hold much appeal to me.
Is that the networking from Facebook or...
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 7, 2010 at 3:17 pm
Personally I don't like programming much, but in my career I have seen some pretty decent women programmers...I don't mean pretty by looks btw 😉
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 7, 2010 at 3:16 pm
Bru Medishetty (1/7/2010)
ALZDBA (1/7/2010)
GSquared (1/7/2010)
Krasavita (1/7/2010)
How many db can we have per server and how much memory in total can I have?Thank you
Servers usually aren't all that loud, but the...
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 7, 2010 at 2:44 pm
I had this issue too. Even though being an admin on SQL Server, I couln't stop/start or restart sql server from the client so I had to remote into the...
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 7, 2010 at 1:53 pm
Viewing 15 posts - 121 through 135 (of 469 total)