Viewing 15 posts - 40,861 through 40,875 (of 49,571 total)
Ok, that works, but...
Do you really want a second open connection, all the fun of distributed transactions and the like just to avoid a temp table? Plus you'd have to...
February 22, 2009 at 1:31 am
You can't select from a stored procedure. What you'll have to do if you want to go this kind of route is to define temp tables that match the results...
February 21, 2009 at 1:50 pm
You will always have fragmentation, it's unavoidable. Small amounts (like in your example) is not a major concern. It's when inserts are all over the table (like Uniqueidentifier DEFAULT NewID()...
February 21, 2009 at 1:42 pm
Sounds like you have data corruption. Please run the following in the database 'ERP'
DBCC CHECKDB ('ERP') WITH NO_INFOMSGS, ALL_ERRORMSGS
Do you have any idea when this started?
Do you have any backups...
February 21, 2009 at 12:35 pm
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic662081-5-1.aspx
February 21, 2009 at 12:31 pm
allmhuran (2/21/2009)
February 21, 2009 at 12:28 pm
The other point to consider is that the clustered index key, as it is the row's 'identifier' will be in every single nonclustered index. So, by choosing a wide clustering...
February 21, 2009 at 12:16 pm
RBarryYoung (2/21/2009)
February 21, 2009 at 11:09 am
Look up "Orphaned users" in Books Online
February 21, 2009 at 11:06 am
homebrew01 (2/21/2009)
February 21, 2009 at 10:00 am
RBarryYoung (2/21/2009)
Good idea, Gail. A "Slow SQL Server" is really a different problem from a "Slow Query".
I'm thinking of the "Slow Query" scenario here.
You know my checklist: 1) use...
February 21, 2009 at 8:04 am
Ninja's_RGR'us (2/21/2009)
February 21, 2009 at 8:02 am
Kit G (2/21/2009)
February 21, 2009 at 7:41 am
Viewing 15 posts - 40,861 through 40,875 (of 49,571 total)