Viewing 15 posts - 42,061 through 42,075 (of 49,571 total)
Please post the code for the UDFs, the schema of the tables involved, and the indexes on them.
Oh, and read these two posts as well.
http://sqlinthewild.co.za/index.php/2008/08/12/views-or-functions/
http://scarydba.wordpress.com/2008/08/15/more-on-table-valued-functions/
December 31, 2008 at 7:59 am
Mani (12/31/2008)
after immediately 3 weeks got one more problem that i posted today..and we are decided to take experts opinion before directly contacting to Microsoft support as it is not...
December 31, 2008 at 7:59 am
MANU (12/31/2008)
4.) Rebuild the database log file:dbcc rebuild_log ('dblogfilename','C:\Program Files\Microsoft SQL
Server\MSSQL\Data\ myDatabaseName2_log.LDF')
That should be the absolute last resort when all else has failed, not the first thing to try. Rebuilding...
December 31, 2008 at 7:48 am
Christopher Stobbs (12/31/2008)
December 31, 2008 at 7:45 am
ananda.murugesan (12/31/2008)
Hi Gail,error log we can found that what exact problem for database suspet mode.
Sorry, I don't understand what you're saying
could you tell me, any other...
December 31, 2008 at 7:44 am
Paresh Prajapati (12/31/2008)
I have talk about oldest activate transactions which are remain to close or rollback/committ.
"Remain to close"?
Regardless of how long the transaction has been running, you don't...
December 31, 2008 at 7:41 am
What patches did you install? (kb numbers if possible)
December 31, 2008 at 12:46 am
venkatesh.kuppili (12/30/2008)
i dont know how secured "DecryptByPassphrase" is.. can you please help on this..
Have you read through the section on that function and encryption in general in books Online?
December 31, 2008 at 12:36 am
Be sure to rebuild all of your indexes afterwards. Shrink badly fragments indexes.
December 31, 2008 at 12:33 am
ananda.murugesan (12/30/2008)
can anybody suggestion me, is there any alternative way how do resolve the database suspect condition?
It completely depends on what caused the suspect condition in the first place. The...
December 31, 2008 at 12:30 am
roy.neelanjana (12/30/2008)
·I have worked on SSRS, and SSAS but not in SSIS. In the first test I have got 517. what is the passing percentage for this exam?
You should probably...
December 31, 2008 at 12:29 am
ta.bu.shi.da.yu (12/31/2008)
Surely this would be useful in certain situations? Anyone have any idea why they removed...
December 31, 2008 at 12:26 am
This is all-around some of the worst advice I've seen recently regarding transaction logs in quite a while.
Paresh Prajapati (12/30/2008)
December 31, 2008 at 12:23 am
MANU (12/30/2008)
In which table you find it eventually as I can't see any entries for temp variable in syscacheobjects.
You won't see them in syscacheobjects. That's for execution plans.
select name from...
December 31, 2008 at 12:05 am
DBCC CheckIdent should. I don't know if it's on SQL 7 though. You can use it to check what the current identity seed is, and change if necessary.
December 31, 2008 at 12:01 am
Viewing 15 posts - 42,061 through 42,075 (of 49,571 total)