Viewing 15 posts - 28,456 through 28,470 (of 49,552 total)
Craig Farrell (1/14/2011)
GilaMonster (1/14/2011)
Index on row_id and it should be OK, though not great performance.
select *
from Table_1 a
inner join Table_1 b on a.rowid =...
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
January 14, 2011 at 1:04 pm
What were the ALTER DATABASE statments that you issued?
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
January 14, 2011 at 12:51 pm
This should do the same.
Index on row_id and it should be OK, though not great performance.
select *
from Table_1 a
inner join Table_1 b on a.rowid = b.rowid - 1
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
January 14, 2011 at 12:48 pm
I'd have to check, but I doubt I still have the code and screenshots available if it is the wrong 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
January 14, 2011 at 12:27 pm
There is one and only one connection available in that state. You have to be certain that you get it.
Make sure SQL Agent is stopped, sharepoint is stopped, anything 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
January 14, 2011 at 12:26 pm
Start SQL from the command line with the flags -f -T3608
sqlservr.exe -f -T3608
That will start SQL in restricted mode, won't recover any databases. You'll be able to get one connection,...
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
January 14, 2011 at 9:10 am
Pleasure.
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
January 14, 2011 at 8:35 am
Please run the following and post the full and complete results
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
Do you have a clean backup (one without corruption)?
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
January 14, 2011 at 8:18 am
The transaction log is not an audit log. It's there for recoverability, integrity and consistency. None of those require knowing login names, host machines or application names of a session...
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
January 14, 2011 at 8:16 am
Grant Fritchey (1/14/2011)
Gotta be a difference in the stats. Should be evident by having different execution plans.
Or there's a row-estimation error somewhere, the plans are the same but the actual...
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
January 14, 2011 at 8:08 am
Shrink doesn't compress the database. It just releases unused space to the file system. It also will not change the size of a backup, as backups only contain the data...
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
January 14, 2011 at 12:47 am
How do you define 'out of order'? Lower date for higher identity value? Remember tables don't have a defined order.
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
January 14, 2011 at 12:43 am
It won't be fragmentation of any form. Logical reads = reads from memory.
Post the two stats IO outputs and the two execution plans (as .sqlplan files) 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
January 14, 2011 at 12:41 am
As in 2 or 3 standalone (not clustered) instances on a single machine? Yes, they can even be completely different versions.
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
January 14, 2011 at 12:40 am
If you need the exact test of the queries, you'll need a server-side trace. It will be a lot of data. I have a system that produces 1GB of trace...
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
January 14, 2011 at 12:21 am
Viewing 15 posts - 28,456 through 28,470 (of 49,552 total)