Viewing 15 posts - 31,741 through 31,755 (of 49,552 total)
david.c.holley (7/19/2010)
When your working with a trigger that first on Update as opposed to After Update?
Not quite sure what you mean, but there's only two types of DML triggers...
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
July 20, 2010 at 2:10 am
None whatsoever. When it comes to triggers, FOR and AFTER are synonyms.
CREATE TRIGGER ...
FOR INSERT
means exactly the same as
CREATE TRIGGER ...
AFTER INSERT
The trigger runs after the firing action, within...
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
July 19, 2010 at 2:26 pm
Unfortunately not. There's no backward compat option with SSIS, no save as, no downgrade. If you're deploying to a SQL 2005 server, you need to write your package in BIDS...
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
July 19, 2010 at 9:55 am
Dfalir (7/19/2010)
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
July 19, 2010 at 7:55 am
Dfalir (7/19/2010)
Do you by your experience consider this as an extremely unlikely event, ever to take place?
It's certainly possible. Which is why the recommended practice is to test backups by...
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
July 19, 2010 at 6:03 am
Richard Banks (7/19/2010)
The database im currently looking at is in simple recovery mode, which according to the article is bad.
Well depends. If something happens to the database will...
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
July 19, 2010 at 5:18 am
Dfalir (7/19/2010)
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
July 19, 2010 at 5:16 am
Henrico Bekker (7/19/2010)
Full Backup included the Databases as well as the log.
Just enough of the log to be able to restore the database in a consistent state. Full backup does...
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
July 19, 2010 at 5:15 am
Henrico Bekker (7/19/2010)
No, you cant, you will confuse SQL and your LSN sequence.The Maint1 log backups will fail if you do a second full backup in between.
Log backups won't fail....
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
July 19, 2010 at 4:43 am
Richard Banks (7/19/2010)
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
July 19, 2010 at 4:40 am
It's not that the transaction 'partially commits'. All a transaction assures you (other than locking) is that if the commit transaction never runs, the entire thing will roll back.
What can...
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
July 19, 2010 at 4:38 am
Sagar Sawant (7/19/2010)
If you declare table variable instead of using #test table. You will get the result i.e. it's not allocating resources in tempdb.
Common myth, completely wrong.
Temp table and 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
July 19, 2010 at 4:32 am
Only data/schema modifications are logged.
Take a look through this article - http://www.sqlservercentral.com/articles/64582/
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
July 19, 2010 at 4:19 am
For starters...
CREATE TRIGGER RecordUpdate
ON Rooms
AFTER INSERT, UPDATE -- catch new inserts and modifications
AS
BEGIN
UPDATE Rooms
SET modified_date = getdate() -- modified now
WHERE...
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
July 19, 2010 at 3:54 am
Yes! Absolutely.
What happens if the drive that the master database file is on fails? Without backups you;ve lost all your logins, linked servers, server-level security, etc. If something happens 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
July 19, 2010 at 3:50 am
Viewing 15 posts - 31,741 through 31,755 (of 49,552 total)