Viewing 15 posts - 44,356 through 44,370 (of 49,552 total)
How are you trying to rebuild master?
What does the summary.txt file that the error message references contain?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 21, 2008 at 2:59 am
Well, the as shouldn't be there, you need to alias the open query, the statement within openquery needs to be in quotes, the column sAMAccountName needs to be added to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 21, 2008 at 2:57 am
sandhyarao49 (9/20/2008)
It would be great if you provide the repro steps for the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 20, 2008 at 10:27 am
DDL rights means that the users will be able to truncate the table, not delete from it (unless they also have delete rights from elsewhere)
Do they really need ddl rights?...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 20, 2008 at 10:26 am
Shrink with the truncate_only command will release unused space at the end of the file to the file system. If the free space within the file is scattered around, as...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 20, 2008 at 10:24 am
Steve Jones - Editor (9/20/2008)
Please don't cross post. Answered here: http://www.sqlservercentral.com/Forums/Topic572937-146-1.aspx
Umm.. recursive link. Did you mean here -
http://www.sqlservercentral.com/Forums/Topic572938-359-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 20, 2008 at 7:04 am
Mirroring is more an 'automated' logshipping than it is similar to replication.
Replication (transactional) will give you a second server that's fully usable (read and write) that is slightly behind the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 20, 2008 at 7:03 am
Run profiler for a while and look for queries that have very high CPU usage. Take the top 3 or so and see if you can optimise them. That may...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 20, 2008 at 2:45 am
If you switch to simple recovery, you will no longer be able to run log backups.
Check your log backup job, make sure that no one's added the 'WITH NO_TRUNCATE' clause...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 20, 2008 at 2:43 am
The backup is the size (more or less) of the data in the database, not the file size of the databases. It means that your DBs have some space free...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 20, 2008 at 2:29 am
Why don't you use temp tables, then you will have no such worries. Also means that your users won't need create table rights in your database.
CREATE TABLE #TableName ...
...
DROP TABLE...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 20, 2008 at 2:28 am
Duplicate post. No replies to this thread please. Direct replies to:
http://www.sqlservercentral.com/Forums/Topic572937-146-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 20, 2008 at 2:27 am
Have a look at database mirroring. It looks, from your requirements, that it would be a closer fit than replication
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 20, 2008 at 2:25 am
MANU (9/19/2008)
Try comparing physical and logical reads on both system by turning on statistics for I/O.SET statistics io on
MJ
And statistics time. I'd like to see where the time difference appears.
if...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 20, 2008 at 2:21 am
webrunner (9/19/2008)
(Someone might unwittingly think the tempdb is just a backup and may delete it accidentally.)
If SQL's running, the files can't be deleted as SQL will have them...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 19, 2008 at 3:26 pm
Viewing 15 posts - 44,356 through 44,370 (of 49,552 total)