Viewing 15 posts - 166 through 180 (of 312 total)
Jeff Moden (7/21/2014)Read about what? If it's not about SQL Server, T-SQL, or setting up one of the "silly" experiments you were talking about, etc, etc, then you're not...
"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]
July 21, 2014 at 9:55 pm
GilaMonster (7/21/2014)
Do you have scheduled test restores? Agent alerts? Job failure alerts?
We do get alerts time to time but its mostly because space issues or sometimes network issues. (its rare)
Have...
"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]
July 21, 2014 at 6:21 pm
Michael L John (7/17/2014)
"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]
July 17, 2014 at 2:19 pm
Michael L John (7/17/2014)
Uh, when you say "8GB is assigned to this DB", how are you determining that? Do you mean this INSTANCE?
Sorry my bad. 8GB is assigned to...
"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]
July 17, 2014 at 12:45 pm
Since the DB is only 10 GB, you may not see a need for more indexes. At this size, unless you have a server with 512 mb of RAM,...
"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]
July 17, 2014 at 12:03 pm
Keep an eye on a good maintenance as well: Statistics update, control of fragmentation, low wait stats and etc...
How often you think I should update statistics? Do I do it...
"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]
July 15, 2014 at 10:15 am
Can you post the output of the below when running it inside the databases context.
SELECT type_desc FROM sys.objects WHERE name = 'T659'
I feel like an idiot now. I should have...
"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]
July 15, 2014 at 9:08 am
It seems that you have a clustered index on B270.C1. Do you? you didn't post the indexes and tables definitions.
You could probably reduce the logical reads by using non-clustered index...
"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]
July 15, 2014 at 9:02 am
anthony.green (7/15/2014)
"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]
July 15, 2014 at 8:56 am
Luis Cazares (7/14/2014)
The leading...
"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]
July 14, 2014 at 3:35 pm
Igor Micev (7/14/2014)
We don't know what indexes you have added,...
"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]
July 14, 2014 at 2:59 pm
george sibbald (7/2/2014)change the sa password (to something strong) and then disable it. There should not be a need to use sa. If people really need sysadmin grant it to...
"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]
July 2, 2014 at 9:21 am
Jeff Moden (7/1/2014)This is one of many reasons why it's important that only DBAs can do backups, which normally means that only DBAs have SA privs.
I completely agree with you,...
"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]
July 1, 2014 at 11:17 am
Grant Fritchey (7/1/2014) The other book (not free I'm afraid) is all about query tuning.
I don't mind buying the book. As my father always say, you never waste money 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]
July 1, 2014 at 10:56 am
Alan.B (7/1/2014)
You can get this information from msdb.dbo.backupset
SELECT name,description,
user_name,
database_creation_date,
backup_start_date,
backup_finish_date,
backup_size,
database_name,
server_name,
machine_name
FROM msdb.dbo.backupset
Thanks. It gave me all the details.
I also right clicked on the backup set -->properties and then details which also...
"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]
July 1, 2014 at 10:30 am
Viewing 15 posts - 166 through 180 (of 312 total)