Viewing 15 posts - 47,086 through 47,100 (of 49,552 total)
Scott Duncan (3/26/2008)
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
March 27, 2008 at 1:00 am
Looks like you may have duplicate jobs. The code you posted that runs 1pm does all that the integrity check and optimisations do. You may be able to disable one...
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
March 26, 2008 at 11:59 pm
Do you mean the profiler trace? Or something else?
If you select save to file, you can have the profiler trace written anywhere. If you don't, I think it just goes...
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
March 26, 2008 at 11:49 pm
I'll second Kyle's advice. The only time you should consider shrinking a transaction log is if it's grown excessivly large due to some long running transaction.
In general, what you want...
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
March 26, 2008 at 11:43 pm
blahknow (3/26/2008)
Hi Gail,You've got 3213 points, how did you get it, from another forum ?
Points are given for writing posts (1 per post writen) and for answering the Question...
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
March 26, 2008 at 11:34 pm
Is the category group stored anywhere? If not, have you considered creating a table for the cateory group and adding a foreign key to the InventoryCategory table?
It will make queries...
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
March 26, 2008 at 11:26 pm
Those are table variables. Unlike temp tables, the name that they are given in code has no relation to the name assigned in TempDB.
It's also possible that temp tables created...
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
March 26, 2008 at 11:24 pm
What's wrong with just this?
select object_name(a.id),a.name,b.name,a.length
from syscolumns a,systypes b
where a.type = b.type
and a.usertype = b.usertype
order by object_name(a.id)
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
March 26, 2008 at 6:03 am
kgunnarsson (3/26/2008)
but if you do a full backup before the truncation
I was under the asumption that this could be avoided by doing full backup and transaction log backup before...
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
March 26, 2008 at 4:43 am
What you're seeing is an automatic statistics update. Nothing to be concerned about.
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
March 26, 2008 at 4:28 am
kgunnarsson (3/25/2008)
backup log 'database' with truncate_only
Just bear in mind that a log truncation breaks the log chain. You will not be able to restore the database to a time after...
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
March 26, 2008 at 4:21 am
Without data I can't test, but your version does look like it should work. I would recommend seperate procs for the cases where the parameters are null, to avoid potential...
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
March 26, 2008 at 2:16 am
How has the column been encrypted?
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
March 26, 2008 at 1:20 am
Where does that information you want in the CategoryGroup come from?
Please read the following on how to post problems for the fastest answers.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
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
March 26, 2008 at 1:14 am
What recovery mode is your database in? If full, do you have regular log backups running?
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
March 26, 2008 at 1:07 am
Viewing 15 posts - 47,086 through 47,100 (of 49,552 total)