Viewing 15 posts - 19,261 through 19,275 (of 49,552 total)
Jeff Moden (4/9/2012)
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
April 9, 2012 at 7:45 am
Ensure that the SQL Server service account has permissions to the location the backup file will be written.
That's not a SQL permission error, it's a windows permission error.
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
April 9, 2012 at 7:44 am
Otherwise the database role for backups is db_backupoperator.It grants BACKUP DATABASE, BACKUP LOG, CHECKPOINT in that database.
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
April 9, 2012 at 6:15 am
The first thing is to specify the columns in the select as well as the insert. You have this:
INSERT INTO trainingHist(training_Type, completed_Date, Expiry_Date, Qualified_Unqualified, training_No, staff_No)
Select * FROM deleted;
Rather than...
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
April 9, 2012 at 6:12 am
S_Kumar_S (4/9/2012)
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
April 9, 2012 at 5:09 am
S_Kumar_S (4/9/2012)
You mean to say even if there are objects with no stats e.g. table variables ni proc, still both estimated and actual plan will be same?
I remember somewhere I...
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
April 9, 2012 at 5:06 am
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
April 9, 2012 at 3:17 am
S_Kumar_S (4/9/2012)
Well , I understand that Estimated execution plan might be giving just "estimates" but actual execution plans should have more accuracy.
Nope. Common misconception.
The only difference between an estimated plan...
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
April 9, 2012 at 3:12 am
Please note: 3 year old thread.
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
April 9, 2012 at 3:07 am
Depends on your design.
In some designs created date = modified date means that the record has not been modified since creation. In others modified date = null means that 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
April 8, 2012 at 4:35 pm
sqldba108 (4/8/2012)
- Pages Scanned................................: 8
And that is why rebuilding has no effect. Rebuilding has just about no effect on indexes of a couple of extents or smaller, and the rough...
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
April 8, 2012 at 4:33 pm
Define 'does not work' please.
Throws an error?
Inserts wrong data?
Inserts no data?
Transforms the server into a pool of molten metal?
Something else?
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
April 8, 2012 at 4:03 pm
No such table as updated.
In an update trigger the new values are in inserted and the old values in deleted.
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
April 8, 2012 at 12:28 pm
How big's the table? How many pages?
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
April 8, 2012 at 12:27 pm
Because you've been changing the recovery model of the DB and you're grouping by the recovery model and the backup type. Thought you wanted the latest log backup, not 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
April 8, 2012 at 4:59 am
Viewing 15 posts - 19,261 through 19,275 (of 49,552 total)