Viewing 15 posts - 47,341 through 47,355 (of 49,552 total)
One this that may make a small difference, you don't need a distinct in a subquery used in an IN clasue.
Can you post the schema of the tables 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
February 19, 2008 at 2:43 am
Reindex completely rebuilds the index, removing fragmentation at all levels.
Index Defrag shuffles the leaf pages into order, removing fragmentation at the leaf levels, but potentially leaving fragmentation at the other...
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
February 19, 2008 at 12:35 am
There are thee types of 'temp' tables, all stored in the tempDB database.
Global Temp Tables.
Created by CREATE TABLE ##MyTempTable AS ...
They are visible to all sessions. If not explicitly dropped,...
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
February 18, 2008 at 1:12 am
Haven't heard of this happening before.
Can you post the trigger code, the table schema and the insert statement that you tried?
What's the version of your SQL server? What SP?
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
February 17, 2008 at 11:53 pm
Really strange.
Can you run a checkdb on the database, just to make sure that there's no corruption lurking. You can also try rebuilding the indexes on those tables
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
February 17, 2008 at 10:55 pm
What is sccm 2007, and why does it need full, unrestricted access to your SQL Server?
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
February 15, 2008 at 1:45 am
Are you running SQL 2000 or 2005?
In 2005, DBCC PinTable is a no-op. It's deprecated and ignored.
Not sure, in 2000, how to find pinned tables, but if 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
February 15, 2008 at 12:08 am
I would store it in an int field as the number of minutes. The presentation as hours and minutes can be sone on querying, either in a proc or on...
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
February 14, 2008 at 12:27 pm
2 recommendations, one request.
I strongly recommend the following two books
Guru's guide to SQL Server architecture and internals by Ken Henderson. It was written for SQL 2000, but is still...
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
February 14, 2008 at 12:26 pm
What were they blocking on?
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
February 14, 2008 at 11:11 am
Never seen that myself. Shouldn't be possible.
Post queries 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
February 14, 2008 at 11:11 am
Try print for debug then. Assign a local var in the trigger and print that. If the print prints nothing, then there's something else wrong.
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
February 14, 2008 at 11:05 am
I don't know exactly what the notifications are for. It's for a trading system, so I will guess that its to tell the front end that a price/rate has changed.
Not...
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
February 14, 2008 at 11:01 am
Steve Jones - Editor (2/14/2008)
Lock Pages in Memory not assigned?
Standard Edition. IIRC, Lock pages is only honoured on Enterprise.
I'd still call PSS. I don't know anyone who can read stackdumps...
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
February 14, 2008 at 10:57 am
Run a profiler trace against the server. Someone or something is changing the recovery mode. It doesn't change on its own.
Trace to disk and load the trace into SQL once...
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
February 14, 2008 at 10:54 am
Viewing 15 posts - 47,341 through 47,355 (of 49,552 total)