Viewing 15 posts - 34,291 through 34,305 (of 49,552 total)
milzs (2/1/2010)
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...
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/
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...
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...
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...
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...
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...
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...
February 1, 2010 at 9:20 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...
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...
January 31, 2010 at 10:04 pm
Biz (1/31/2010)
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...
January 31, 2010 at 9:56 pm
STherrien-978820 (1/31/2010)
January 31, 2010 at 9:42 pm
Viewing 15 posts - 34,291 through 34,305 (of 49,552 total)