Viewing 15 posts - 166 through 180 (of 309 total)
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
T501 (frightening naming convention by the way).
I have no idea why we can't follow a proper guideline on how to name the table, but I usually keep my mouth shut:(
If...
June 30, 2014 at 1:46 pm
I Just became a SQL Server DBA about 8 months ago but don't have any other DBA in the company who I can talk to :ermm: Until last week, we...
June 30, 2014 at 11:20 am
Viewing 15 posts - 166 through 180 (of 309 total)