Viewing 15 posts - 31,066 through 31,080 (of 49,552 total)
As posted http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=149244, you almost certainly have an orphaned login. Common when restoring a DB on a different instance. Hit google (or your favourite search engine) and search on that...
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
August 24, 2010 at 4:38 pm
Alvin Ramard (8/24/2010)
Don't you use a triangular join to join 3 tables? 😛
That means you'll need a CROSS JOIN for 4 tables. :hehe:
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
August 24, 2010 at 3:29 pm
jpSQLDude (8/24/2010)
such as integrity check, rebuild indexes, reorganize indexes, update statistics,
Yeah, that'll cause the log growth. Any reason why you're doing redundant work? Reorganise after rebuild of indexes is a...
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
August 24, 2010 at 10:38 am
Index rebuild job?
How often are the tran log backups and how long did the full backup take?
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
August 24, 2010 at 9:43 am
First things first...
cast(convert(varchar, a.datefield, 101) as smalldatetime) between 'date1' and 'date2'
That is not SARGable. No indexes on the date columns will help here. What's the reason behind that conversion?
Start with...
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
August 24, 2010 at 8:58 am
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
August 24, 2010 at 8:30 am
tt-615680 (8/24/2010)
BACKUP LOG 'Databasename'WITH
TRUNCATE_ONLY
Why?
If you need point-in-time recovery, then you need log backups. If you don't need point in time recovery,...
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
August 24, 2010 at 8:24 am
tt-615680 (8/24/2010)
the only job that runs every half hour throughout the day is the "Truncate Transaction log" job
Truncate or back up? If truncate, why?
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
August 24, 2010 at 7:49 am
Uninstall SQL. Configure the windows clustering, reinstall SQL as a clustered instance.
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
August 24, 2010 at 7:47 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic973949-391-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
August 24, 2010 at 7:46 am
This is a MS SQL Server site. You'll probably get better and faster answers if you ask on a MySQL forum. Try http://www.dbforums.com or http://forums.mysql.com
p.s. crossposting is frowned on here...
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
August 24, 2010 at 7:45 am
This is a MS SQL Server site. You'll probably get better and faster answers if you ask on a MySQL forum. Try http://www.dbforums.com or http://forums.mysql.com
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
August 24, 2010 at 7:43 am
This series may be worth a look - http://www.sqlservercentral.com/articles/Indexing/68439/
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
August 23, 2010 at 11:23 pm
An insert/update trigger should work.
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
August 23, 2010 at 11:22 pm
bassem_farouk (8/23/2010)
any way to physically reduce the log file?
Why do you need to?
The log should be sized for your workload and log backup frequency and left alone.
Please read through this...
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
August 23, 2010 at 11:22 pm
Viewing 15 posts - 31,066 through 31,080 (of 49,552 total)