Viewing 15 posts - 2,446 through 2,460 (of 7,168 total)
Agreed, not about shooting the test writer but about the nonsensical options. You literally have to rule out all the real choices based on how ambiguous they are. "Compare and...
January 10, 2013 at 8:35 am
GilaMonster (1/10/2013)
opc.three (1/10/2013)
. Online index rebuilds do not block anything regardless of the isolation level.
Kinda...
Online index rebuilds are mostly online. They take a short-lived IX lock at the beginning (which...
January 10, 2013 at 8:31 am
Anytime, good luck. If you have a moment to circle back, I would be interested to hear about where you landed, and how you got there. Of course if you...
January 10, 2013 at 8:13 am
A better option would be to call the web service from your application code and submit the resulting XML to the stored procedure for further use and inspection, i.e. do...
January 10, 2013 at 7:42 am
Philip-1144230 (1/10/2013)
Disregard the previous question, answer is located here:Would you consider SSIS to be a better practice?
I would not put much stock in that post. The suggestion that macros are...
January 10, 2013 at 7:39 am
Sure. I developed the C# code I posted inside an SSIS Script Task. You'll just need to add a reference to Microsoft.Office.Interop.Excel.dll in the Script Task VSTA Project (what opens...
January 10, 2013 at 7:31 am
To access a Java web service you would have to use SQLCLR but why would you want to do that from inside your database engine? What are you trying to...
January 10, 2013 at 7:21 am
rocks (1/10/2013)
so In Snapshot , even i SP runs under transactions to read write, reporting SP's which are select script only will not get affected.
Correct. Writers do not block...
January 10, 2013 at 7:06 am
Not at all. My response was admittedly a bit Spartan.
Office objects are designed to be used on a client system, not a server, and they are notorious for having memory...
January 10, 2013 at 7:01 am
mpradeep23 (1/10/2013)
CDC works if tables are in different instances of sql sever?thank s
pradeep
Sure, CDC is an option but if you do not need a record of all historical data changes...
January 10, 2013 at 6:39 am
Philip-1144230 (1/10/2013)
Thanks for the reply.
This sparked anther thought that I would like to run by you and anyone else who might have more insight into CLR Procedures.
Would it be...
January 10, 2013 at 6:22 am
Related post. Direct replies here:
http://www.sqlservercentral.com/Forums/Topic1405106-146-1.aspx
January 10, 2013 at 6:02 am
What you see with the DMVs is the input buffer, i.e. the last batch. If you did not have a Trace or Extended Events session running then the information is...
January 10, 2013 at 5:45 am
Looks like A and B are polar opposites, as are C and D, so if only one choice could be correct then I would also go with E.
January 10, 2013 at 5:21 am
C# is not an option :crying:
Here is a mockup of some code for a Script Task that reads a Worksheet row-by-row and accesses the Hyperlinks collection for each row. I...
January 10, 2013 at 5:15 am
Viewing 15 posts - 2,446 through 2,460 (of 7,168 total)