Viewing 15 posts - 42,181 through 42,195 (of 49,552 total)
Paul (12/22/2008)
I meant that the data is updated so infrequently that I dont think the costs of record locking outweigh the performance gain from ignoring it.
Thing is, if using nolock...
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
December 22, 2008 at 6:15 am
What's 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
December 22, 2008 at 6:14 am
Ok. Is there a question somewhere in that?
If you want assistance in writing the trigger, you're going to have to give a lot more details on what you want to...
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
December 22, 2008 at 5:48 am
ps (12/22/2008)
try reducing the frequency of tran log backups. this will flush out inactive transaction more frequently from the log file.
Other way around. Reducing the frequency of the log backups...
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
December 22, 2008 at 5:43 am
What recovery model and how often are you doing transaction log backups?
What do you mean by "unable to open it"?
Take a read through this - http://www.sqlservercentral.com/articles/64582/
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
December 22, 2008 at 5:28 am
So you've got the SQL service stopped, you've got one command window where you ran sqlservr.exe -m and left it running, and another command window where you're trying to connect...
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
December 22, 2008 at 5:25 am
nitinpatel31 (12/22/2008)
There must be some corruption in Index or Data pages.
If there was corruption of any form the query would not run forever. It would fail with an 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
December 22, 2008 at 5:23 am
subha.v (12/22/2008)
It's still running. Nearly 55 min.
Is it blocked? Is it wating for a resource, if so what's the wait type and wait resource?
How many rows out of the 700000...
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
December 22, 2008 at 5:22 am
Jeff Moden (12/22/2008)
Ohhhhh.... that stuff..... gee... I wonder when they'll come out with an EDI data type? 😛
CREATE TYPE EDI
EXTERNAL NAME EDI.[PointlessClrTypes.EDI] ;
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
December 22, 2008 at 5:21 am
subha.v (12/22/2008)
Select ColB,ColC from table1 where ColD= 123.
How many rows will that return?
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
December 22, 2008 at 3:18 am
Kishore.P (12/22/2008)
> DBCC CHECKTABLE.
> DBCC UPDATEUSAGE ( ), if it is not a production server.
> DBCC CLEANTABLE
Why?
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
December 22, 2008 at 3:06 am
There are no errors there. That's SQL's startup messages. You need to connect to SQL from another command window, using sQLCMD and restore the database.
Does the restore database give...
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
December 22, 2008 at 1:36 am
ps (12/22/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
December 22, 2008 at 1:35 am
They are SQL reserved words. Hence management studio highlights them as such.
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
December 22, 2008 at 12:44 am
TheSQLGuru (12/21/2008)
PLEASE check Books Online before posting questions!
Read the manual? What a radical, way out idea!
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
December 22, 2008 at 12:43 am
Viewing 15 posts - 42,181 through 42,195 (of 49,552 total)