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...
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...
July 21, 2014 at 6:21 pm
Michael L John (7/17/2014)
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...
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,...
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...
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...
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...
July 15, 2014 at 9:02 am
anthony.green (7/15/2014)
July 15, 2014 at 8:56 am
Luis Cazares (7/14/2014)
The leading...
July 14, 2014 at 3:35 pm
Igor Micev (7/14/2014)
We don't know what indexes you have added,...
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...
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,...
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...
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...
July 1, 2014 at 10:30 am
Viewing 15 posts - 166 through 180 (of 312 total)