Viewing 15 posts - 121 through 135 (of 314 total)
Perry Whittle (3/2/2015)
New Born DBA (3/2/2015)
Restored with recoveryThe secondary database must be restored with either NORECOVERY or STANDBY.
1 more question I have regarding the log shipping.
This is how the primary...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
March 2, 2015 at 10:11 am
Let me try that and if I run into any issues, I will just reply to this thread again.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
March 2, 2015 at 9:55 am
Restored with recovery
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
March 2, 2015 at 8:58 am
Already created a view from tables
Create View [dbo].[HistInfo] AS
SELECT [UniqueID]
,[Company]
,[CustID]
,[CustomerName]
...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
February 19, 2015 at 1:46 pm
Grant Fritchey (2/18/2015)
Then, you need to break down HA...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
February 18, 2015 at 11:24 am
ScottPletcher (2/4/2015)
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
February 4, 2015 at 12:56 pm
ScottPletcher (2/4/2015)
New Born DBA (2/4/2015)
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
February 4, 2015 at 12:17 pm
FYI--When you run this SQL Statement, there are 207,716 records. 1 more thing I also have to mention is that column C1000020534 has only 1 value "Case" and C1000020523 has...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
February 4, 2015 at 11:03 am
This particular SQL Statement runs around 200,000 times a day, goes through millions of logical reads and when I look at the execution plan, it shows that creating a non-clustered...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
February 4, 2015 at 10:56 am
Lowell (2/4/2015)
CREATE...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
February 4, 2015 at 10:34 am
MiguelSQL (1/28/2015)
I had to do something similar. it was a nightmare!
1- make sure it's on...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
January 28, 2015 at 3:21 pm
Try this 🙂
http://blog.sql-assistance.com/index.php/rule-restart-computer-failed-when
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
January 28, 2015 at 1:00 pm
Please see the attachment for a little update on the blocking.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
January 7, 2015 at 12:27 pm
GilaMonster (1/7/2015)
New Born DBA (1/7/2015)
Tuesday, it got executed around 6400 times and cumulative wait time was about 18:00 minutes (LCK_M_X).
So on average each update waited 15ms for a lock. Is...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
January 7, 2015 at 8:52 am
I also ran this script to find waits. Please see the attachment, result from the script.
WITH [Waits] AS
(SELECT
[wait_type],
...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
December 16, 2014 at 9:08 am
Viewing 15 posts - 121 through 135 (of 314 total)