Viewing 15 posts - 42,046 through 42,060 (of 49,562 total)
The tran log's not encrypted, but it's not designed to be human-readable. As far as I know, there are no official documents that are publicly released describing the data in...
January 1, 2009 at 5:35 am
RBarryYoung (12/31/2008)
The irony of course is that if SUM(..) OVER(..) allowed ORDER BY, 2/3rds of the uses for it (the Update pseudo-cursor) would disappear.
Apparently (and this is not confirmed), that's...
January 1, 2009 at 5:15 am
homebrew01 (12/31/2008)
December 31, 2008 at 8:27 am
bhimrajg (12/31/2008)
Ok....Here is simple query :
Is that the select inside one of the udfs?
What about the other udf?
And Please check the execution plan
Right click the exec plan, select save...
December 31, 2008 at 8:20 am
Perry Whittle (12/31/2008)
December 31, 2008 at 8:08 am
bhimrajg (12/31/2008)
I have uploded the execution plan below
You can zip it and attach it to your post here.
December 31, 2008 at 8:01 am
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
Viewing 15 posts - 42,046 through 42,060 (of 49,562 total)