Viewing 15 posts - 1,861 through 1,875 (of 5,356 total)
This might give you a start:
http://www.sql-server-performance.com/query_execution_plan_analysis.asp
November 11, 2004 at 1:08 am
You can set your recovery model to bulk-logged during import. That way only the fact is recorded in the log, not each simgle operation. Right after the import, you can...
November 11, 2004 at 1:05 am
On your error handling question, you might want to read this:
http://www.sommarskog.se/error-handling-II.html
http://www.sommarskog.se/error-handling-I.html
November 11, 2004 at 12:39 am
Create a view on getdate() and use it in the function.
Be careful with this advise!
See http://www.insidesql.de/content/view/100/ on what can happen.
November 10, 2004 at 11:26 pm
Hey, sounds really good. ![]()
We should think of starting some "classic" off-topic threads again. ![]()
November 9, 2004 at 7:24 am
That times are gone! ![]()
http://www.insidesql.de/component/option,com_bookmarks/Itemid,42/catid,1/
( if you don't mind, Adam)
You need to scroll down a bit.
November 9, 2004 at 4:15 am
Sounds like a good idea. And while you're at it, please take also care of these:
sp_MShelpcolumns
sp_MStablekeys
sp_MStablechecks
sp_MShelpindex
sp_MShelpfulltextscript
sp_MSobjectprivs
I would like a copy ![]()
November 9, 2004 at 3:26 am
Please don't cross post. Leave the answers here:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=145361
November 9, 2004 at 3:23 am
Nice one. However I am missing a statement somewhere that your script makes calls to undocumented (=unsupported) procedures. You should be able to achieve the same using the documented sp_fkeys...
November 9, 2004 at 3:16 am
Okay, I think you have a logical error here. It seems that you call the sp which sets the IDENTITY_INSERT to on. And then do the INSERT, but not inside...
November 9, 2004 at 2:15 am
You might be better off asking such question to merely Oracle related sites such as
http://asktom.oracle.com/pls/ask/f?p=4950:1:5641538977840182319:RESET::1 or
November 9, 2004 at 1:35 am
You can find it also explained here http://www.sqldts.com/default.aspx?212 along with a wrapper procedure to change multiple packages at a time.
Patrick,
long time no see. When I look at your postcount, it...
November 9, 2004 at 1:24 am
However, a PK (composite or not) is created as a clustered index by default in EM - unless you have already defined another index on the table as clustered.
Well, not...
November 9, 2004 at 12:58 am
Viewing 15 posts - 1,861 through 1,875 (of 5,356 total)