Viewing 15 posts - 34,291 through 34,305 (of 49,552 total)
milzs (2/1/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
February 1, 2010 at 10:59 am
vstitte (2/1/2010)
As for how TOP works. Create a clustered index on Number on this table and then do a Top 3. Let us know what you find.
It may be 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 1, 2010 at 9:49 am
Please post the query, table definitions, index definitions and execution plan as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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 1, 2010 at 9:42 am
george sibbald (2/1/2010)
Gail,what happened to the new years resolution to spend less time on the forums because of workload?
Still top 5 in January with over 700 posts?
Tsk, tsk. 🙂
Haven't had...
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 1, 2010 at 9:41 am
ns_nataly (2/1/2010)
Why not to update this record with another information of the same size:"Maitenance record... Please Ignore" ?
Won't help with the log problem. When a record is updated the old...
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 1, 2010 at 9:37 am
Can you post the actual queries that the reports use? Without seeing those it's not possible to give accurate recomendations. Also, can you post the schema with data types.
As 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
February 1, 2010 at 9:35 am
When a row is deleted, the previous values are written into the transaction log. This cannot be prevented. The log entry will remain in the log, and readable with sufficient...
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 1, 2010 at 9:31 am
Roy Ernest (2/1/2010)
Am I being too rude here?
No. That's about how I'm reacting lately to questions so simple that they could be answered by testing in less time than it...
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 1, 2010 at 9:22 am
ns_nataly (2/1/2010)
Table variables work only for small recordset - for big number of records it is creating normal tempory table in background locking your resources.
No it doesn't. The reason 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
February 1, 2010 at 9:20 am
Glad to hear.
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 1, 2010 at 9:14 am
Bhuvnesh (1/31/2010)
No, query is returning correct results.
It may be now, as written it may not always however. Nolock means to SQL Server 'get me the data fast, I don't...
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 1, 2010 at 9:09 am
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Also, do some investigation yourself and see where in the proc the really slow code is. It's seldom 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 31, 2010 at 10:04 pm
Biz (1/31/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
January 31, 2010 at 9:57 pm
jeff-860557 (1/31/2010)
I'm open to suggestions, but I need an ID field which is guaranteed to be different across two separate dbs.
Two column primary key. ID, ServerName.
No need for a multi-valued...
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, 2010 at 9:56 pm
STherrien-978820 (1/31/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
January 31, 2010 at 9:42 pm
Viewing 15 posts - 34,291 through 34,305 (of 49,552 total)