Viewing 15 posts - 151 through 165 (of 469 total)
Thanks for the response..i will look into the log shipping option.
would there be a need for an additional license for the active node sql installation?
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."
November 5, 2009 at 10:26 am
Is you current Cluster an Active Active or Active Passive?
How about the new node that you want to add? Will it be an Active node or Passive node?
If it is...
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."
November 5, 2009 at 9:51 am
1.Depending on the company Policy, it is better to have an approval from the management for any such change.
2. Always have a Rollback plan handy.
3. Backup and restore works...
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."
November 5, 2009 at 9:33 am
Thanks for the reply. I was able to connect to the Cache as well as destination database. I had to use the ADO.Net source task to view my source data....
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."
November 5, 2009 at 8:37 am
I created a connection manager using ADO.Net connection. When I use the ADO.Net source to read the data, it does not show anything.
In the source I am able to view...
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."
November 3, 2009 at 1:29 pm
Ok Jason: Do they never complain of blocking issues?
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."
April 7, 2009 at 8:49 am
In the worst possible case,lets assume that the 90,000 Select *'s are required. In that case will not be feasible to run them as Stored Procs rather than inline sql's..just...
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."
April 7, 2009 at 8:27 am
A best practice is to be on a Build version that has been tested to be more stable like SP4 for SQL 2000 or SP2 for 2005 ( I believe...
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."
April 7, 2009 at 7:57 am
CH&HU (4/7/2009)
Backup schedule is at every 12hrs , so it will work at 12am hopefully.
I am assuming this is the Full backup schedule. What about the transaction log backups?
For...
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."
April 7, 2009 at 7:41 am
I normally prefer mm/dd/yyyy way but most of the date fields here at my current job are varchar as 'yyyymmdd' and sometimes I get to work with real datetime fields..
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."
March 4, 2009 at 12:29 pm
CallEntry is a datetime field..but all the previous scripts on this topic couldn't fetch the result set.
Till now I had an inline as below
select * from CallerDetail
where CallEntry between...
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."
March 4, 2009 at 11:45 am
Wow Lynn this works like a charm..just that I had to take out the -1 and make it a zero as I want to run this the same day..
But this...
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."
March 4, 2009 at 11:27 am
Today I am trying to run this query for today..
I want to hard code the time but the date should be retrieved from getdate().
The field takes input as mm/dd/yyyy...
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."
March 4, 2009 at 11:12 am
Well thanks for the above script but heres the thing...
I am getting the output as 2009-03-04 07:00:00.000
but my callentry gives me empty data with the above result set
for it to...
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."
March 4, 2009 at 10:01 am
Thanks Dugi..the script runs well but the CallEntry input needs to have the day also in the format m/dd/yyyy hh:mm:ss to be able to return the correct records where...
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."
March 4, 2009 at 7:43 am
Viewing 15 posts - 151 through 165 (of 469 total)