Viewing 15 posts - 32,866 through 32,880 (of 49,552 total)
I'm feeling just a little bit sarcastic this friday night...
http://www.sqlservercentral.com/Forums/Topic922329-146-1.aspx
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
May 14, 2010 at 3:26 pm
Would you like fries with that?
This editorial from yesterday may be of interest. http://www.sqlservercentral.com/articles/Editorial/70267/
We're happy to help, but not to do the entire job for you. In addition, this...
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
May 14, 2010 at 3:25 pm
FelixG (5/14/2010)
having in consideration that log contains all the transactions since last differential backup....
but it won't.
If he had not truncated the log, it would, and then it would...
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
May 14, 2010 at 2:56 pm
No.
The key fact here is this:
his database was set for full recovery mode and he truncated the log daily after the differential backup as the TL (naturally) was growing...
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
May 14, 2010 at 2:06 pm
What are objects 226099846 and 210099789?
SELECT object_name(226099846)
SELECT object_name(210099789)
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
May 14, 2010 at 1:36 pm
That error's not repairable. This is a 2005 server? CheckDB has been succeeding until recently? I ask, cause this is usually the result of someone doing ad-hoc direct updates 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
May 14, 2010 at 1:31 pm
Stefan_G (5/14/2010)
If you think the optimizer chose the wrong plan you can force it to always uses a loop join by using a hint.
However a loop join to join 16...
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
May 14, 2010 at 11:26 am
This works for me
DECLARE @table sysname, @where VARCHAR(100), @sql NVARCHAR(500), @record_count INT
SET @table = 'sysobjects'
SET @Where = 'xtype = ''u'''
-- Do the work to get the record count from 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
May 14, 2010 at 9:40 am
Stefan Krzywicki (5/14/2010)
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
May 14, 2010 at 7:26 am
Chris Morris-439714 (5/14/2010)
Anybody with the initials JC is doomed to have uncompetitive people skills but this guy really takes the biscuit.
Apparently he's actually a very nice guy and 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
May 14, 2010 at 7:18 am
I would suggest contacting Microsoft's customer support. I have no idea what's happening, I asked a few others if they had any idea, also nothing.
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
May 14, 2010 at 7:12 am
You're updating the entire table, hence the entire table will be locked for the duration of the update statement.
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
May 14, 2010 at 5:55 am
Shivrudra (5/14/2010)
1.Auto committed
2. Need to be committed with commit command after transaction.
3.Each DML must be preceded with BEGIN TRANSACTION
4 None...
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
May 14, 2010 at 5:08 am
Do you think that EXEC and CAST (@var AS varchar) are allowed?
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
May 14, 2010 at 3:38 am
I would suggest some work on the search and on the organisation of the articles and scripts. To be honest, the site's search seems almost useless, I get better 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
May 14, 2010 at 3:11 am
Viewing 15 posts - 32,866 through 32,880 (of 49,552 total)