Viewing 15 posts - 30,871 through 30,885 (of 49,552 total)
Manie Verster (9/8/2010)
What is the ideal free space size in relation to the database size.
There's no one good answer to that. Depends on how large the tables are, how fast...
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
September 8, 2010 at 6:23 am
No indexes whatsoever on the table?
If not, I'd venture a guess that the complete lack of indexes is the reason this query is not optimal.
I suggest that if 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
September 8, 2010 at 5:45 am
Please post new questions in a new thread. Thank you.
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
September 8, 2010 at 5:38 am
WayneS (9/8/2010)
Would this affect the recovery time of the database? Would it affect it to this extent?
Shouldn't and no.
Recovery just needs the active portion of the log, the portion...
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
September 8, 2010 at 5:35 am
The solution to this is odd, but does work.
Create a transactional replication publication and publish a single article.
Stop the log reader
Run sp_repldone
Drop the publication that you just created.
That should remove...
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
September 8, 2010 at 5:18 am
Could be. You need to optimise this and other poorly-performing queries.
If you have no idea where to start, take a look at this 2-part series
If you'd like our help in...
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
September 8, 2010 at 4:27 am
http://msdn.microsoft.com/en-us/library/ms175464%28v=SQL.90%29.aspx
http://msdn.microsoft.com/en-us/library/ms177463%28v=SQL.90%29.aspx
If you're new to SQL, you should be spending a lot of time in the documentation. It will answer many of the questions that you'll 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
September 8, 2010 at 4:12 am
Ok, so it does always have a high reads. Looks like it needs optimising.
I'm not sure I fully understand what you're asking.
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
September 8, 2010 at 4:04 am
Does that particular query always run with that many reads? (There's only one entry for it in the profiler trace)
It was running rapidly in the trace (200ms), so the fact...
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
September 8, 2010 at 3:14 am
Please post table definitions, sample data and expected results as per 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
September 8, 2010 at 1:58 am
There's no good reason for two log files, unless they are on separate drives and there's not enough space for the log on a single drive.
SQL uses its log files...
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
September 8, 2010 at 1:55 am
As I said, poor IO performance (which you confirmed was the case) and log fragmentation are the main causes of long database 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
September 8, 2010 at 1:52 am
stewartc-708166 (9/8/2010)
Microsoft recommends the use of the INFORMATION_SCHEMA views in lieu of system tables
Got a reference that states that?
sys.columns, sys.tables, etc are not system tables. They're catalog views and they...
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
September 8, 2010 at 1:50 am
Doesn't sound like an interview question and, if you look at the second post the OP made, he says that he ran the query and got the results.
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
September 8, 2010 at 1:50 am
luckysql.kinda (9/7/2010)
TryINSERT INTO [Details] ([Location]) VALUES N''@Location
or
INSERT INTO [Details] ([Location]) VALUES N'@Location
Neither will work, as you would know if you'd done a syntax check before posting.
INSERT INTO [Details] ([Location]) VALUES...
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
September 7, 2010 at 11:44 pm
Viewing 15 posts - 30,871 through 30,885 (of 49,552 total)