Viewing 15 posts - 28,036 through 28,050 (of 49,552 total)
jcrawf02 (1/31/2011)
GilaMonster (1/31/2011)
WayneS (1/31/2011)
So... what's your favorite data modeling tool?Pencil and paper (or marker and whiteboard).
Personally, I prefer using Grant
Those international phone bills just add up too fast. And he's...
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 31, 2011 at 12:52 pm
WayneS (1/31/2011)
So... what's your favorite data modeling tool?
Pencil and paper (or marker and whiteboard).
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 31, 2011 at 12:06 pm
Looking at the errors, that's reasonable, they appear to be nonclustered index-related errors. Worth noting that rebuilding indexes is not a general solution.
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 31, 2011 at 10:02 am
For the first one
SELECT name FROM sysobjects WHERE id = 324208951
Of course, if there's any metadata damage, the table may not be identifiable.
For the second one (Data row (1:2569152:49) identified...
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 31, 2011 at 8:33 am
mtillman-921105 (1/31/2011)
Apparently, SQL will use memory instead when it can. If so, that's an intelligent design since of course writing to disk is slower than using memory.
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
January 31, 2011 at 8:27 am
My guess, you're seeing Sch-M/Sch-S deadlock. Everything takes a schema stability (nolock or no nolock), and truncate table is classified a DDL and I believe that it wants a Sch-M...
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 31, 2011 at 7:45 am
No further replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1056151-5-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
January 31, 2011 at 6:46 am
Brandie Tarvin (1/31/2011)
If the poster said that, I don't blame you for slapping down. The question is, how diplomatic were you?
He was pretty diplomatic about it. Far more diplomatic 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
January 31, 2011 at 6:38 am
Brandie Tarvin (1/31/2011)
Wouldn't the security log give that information?
It might, though depending what else is on the box there may be too much noise in there to make sense.
If SQL...
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 31, 2011 at 6:27 am
db_datareader, db_datawriter roles and then grant execute on the schema that the procedures are in. If it's the dbo schema, then...
GRANT EXECUTE ON SCHEMA::dbo TO <username>
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 31, 2011 at 6:24 am
Brandie Tarvin (1/31/2011)
Box Admin and SQL Server admin are not the same thing.
They are if SQL is running in single user mode. Challenge appears to be to find what app...
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 31, 2011 at 6:20 am
To answer that we're going to need to see the deadlock graph.
Turn traceflag 1222 on. That will write a deadlock graph into the error log when a deadlock is encountered....
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 31, 2011 at 5:43 am
With replication you'll have the publisher and subscriber along with a distributor to keep track of things. Simplest is if any changes made to the subscriber don't have to 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
January 31, 2011 at 5:42 am
Nested transactions are a lie.
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 31, 2011 at 4:42 am
Abrar Ahmad_ (1/31/2011)
1. Do creating statistics on each column is feasible?
No. Turn autocreate on and let SQL decide which columns it wants stats on. There are few good reasons for...
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 31, 2011 at 2:57 am
Viewing 15 posts - 28,036 through 28,050 (of 49,552 total)