Viewing 15 posts - 46 through 60 (of 469 total)
Why pay for a separate tool when you paid for a product that has a feature you need.
Having said that, any specific Encryption method are you looking at which TDE...
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 19, 2010 at 1:43 pm
One of the big financial clients who interviewed me in the past used NetApp. It seems NetApp is good with clients having huge storage needs. I would say get 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."
January 19, 2010 at 1:39 pm
I had a similar issue once with SQL server starting before the disks on which the data files were accessible. A reboot did the trick and also I ran dbcc...
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 19, 2010 at 1:33 pm
klineandking (1/19/2010)
Good morning people
Very good morning 😉
my questions is about reorganizing or rebuilding indexes online vs offline, i do not know what this actually means or how its done
1.Index...
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 19, 2010 at 9:49 am
You can set up alerts for any failed jobs and get notified by email.
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 19, 2010 at 9:42 am
That's correct. You need to identify your facts and dimensions. I guess a Star Schema would be your best bet, as it is the simplest style of dw schema.
You 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."
January 19, 2010 at 9:37 am
re: #5 - a cube is not necessarily 3 dimensional, it's dimensionality is dictated by the number of dimensions included, so it could be much higher than 3. People often...
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 19, 2010 at 9:31 am
Make sure all the services are running properly. Also a DBCC check on the important databases would be good. Suggest reading this article
HTH...
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 19, 2010 at 9:08 am
Dee Dee-422077 (1/19/2010)
Hi all,The part that I am totally confuse is: How can I start with the multidimension when I only have the
transactional database?
You can create a Datawarehouse...
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 19, 2010 at 8:46 am
Can you post the sample query that you are using for this?
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 19, 2010 at 8:30 am
Just take out the GO in the query and you should be fine. I have checked it to work correctly without GO.
print '-- dbcc check all databases Except TMEPDB on...
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 19, 2010 at 8:23 am
I do not think the forum is having connectivity issues of any kind. Could this be related to your browser then?..
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 19, 2010 at 8:01 am
You can save the package at the end of the import export wizard in case you intend to use it later on.
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 19, 2010 at 7:42 am
Alerts for services
failed logins
Connectivity issues
tempdb growth etc...
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 19, 2010 at 7:38 am
Create job - Alert-LoginFailureDetected
This job executes the stored procedure 'usp_AlertLoginFailed' when the alert is triggered. After calling the stored procedure, the variable @SendAlert returns the value 'YES' when an e-mail...
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 18, 2010 at 7:24 am
Viewing 15 posts - 46 through 60 (of 469 total)