Viewing 15 posts - 45,706 through 45,720 (of 49,552 total)
shahbaz.oradba (7/14/2008)
take backup of T log with this option.WITH TRUNCATE_ONLY
In simple recovery mode (which the OP's database is in), the log automatically truncates on checkpoint. Hence there is no...
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 15, 2008 at 1:18 am
shahbaz.oradba (7/14/2008)
Hi,how can we know that particular query is taking long time and we have to optimize that,and i heared that query optimization through sqlserver profiler degrades the perfomance.?
Sorry, 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
July 15, 2008 at 1:13 am
brdudley (7/14/2008)
There is a slight difference in that the Where clause is evaluated after the Joins have happened.
Order of clauses depends on the plan the opimiser chooses. Sometimes 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
July 15, 2008 at 12:06 am
shahbaz.oradba (7/14/2008)
your backup startegy should be
Backup strategies vary based on the size of the system, the available space for backups, the time allowed for restore and a number of other...
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 14, 2008 at 11:54 pm
Perry Whittle (7/14/2008)
this shrinking malarky has been done to death all over the forum:D
I know. That's why I wrote the blog post in the first place, so I didn't have...
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 14, 2008 at 11:48 pm
Generally, if you're deleting up to half the table (maybe even more) it's faster to save the rows you want, then trunate the table than to run the delete.
Less impact...
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 14, 2008 at 11:47 pm
David Griffiths (7/14/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
July 14, 2008 at 11:45 pm
JeeKay (7/14/2008)
DO you have the different types of Isolation Levels in SQL 2 K like 2005 ? I was not aware. I will try to do some reading 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
July 14, 2008 at 11:28 pm
Have you tried SQL Profiler?
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 14, 2008 at 8:17 am
Guru (7/14/2008)
this sufficient for my hardware configuration plz any one to suggest me.
Depends what you're going to do with it.
I would strongly suggest a RAID array 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
July 14, 2008 at 8:15 am
Could you perhaps post the schema of the two Job tables and the definitions of the indexes that these example queries use?
What are the execution times of these selects and...
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 14, 2008 at 8:00 am
Post the table design, index definitions and some of the queries that deadlock with each other?
Have you considered snapshot isolation level?
A single table design is bad, but it might be...
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 14, 2008 at 7:59 am
Could you describe the ETL process a bit more please?
You may find it more efficient to copy the rows you want to keep to a temp table, truncate 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
July 14, 2008 at 7:58 am
Cursors = really, really bad idea
Could you describe what happens in a little more detail please?
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 14, 2008 at 7:45 am
Make sure you are not connected to the database you are trying to restore.
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 14, 2008 at 7:41 am
Viewing 15 posts - 45,706 through 45,720 (of 49,552 total)