Did you make it beyond the phone interview?

Since you are learning and are on SQL 2008 I would recommend acquainting yourself with the MERGE statement. INSERT...SELECT is fine, but MERGE is much more versatile and intuitive (in...

MartJ (12/19/2012)

---

Hi all

I have a similar issue so I though a more in depth description may help vineetbhargav too.

I have a proc that is used in a report. The report...

The restore command has to be executed...

I just tried it but the autogrow events themselves do not collect anything for us to see in the TextData column. The most targetted way to figure this out would...

At times, depending on the isolation level or table hints (which the reporting engine sometimes provides), multiple locks will be opened for a single query. Post-processing to roll these multiple...

The server executing the SSIS Package must have all dependent software installed to support the running of the package. So, even if a package resides on a different server from...

You cannot retrieve the password in clear text from SQL Server once it has been set in case that is what you are asking.

To get a 'create login' statement...

I hope people aren't having to use DBCC CHECKCONSTRAINTS all that often 😉

DBCC CHECKIDENT is one that comes to mind that I have...

bugg (12/14/2012)

---

opc.three (12/13/2012)

---

Connection from their IP? I thought you said you were connecting to a remote MySQL server. From a network security perspective only an outgoing connection from the server...

peter-661823 (12/14/2012)

---

Thanks again for answer

I understand your way to set autogrow "grow by Megabytes", I think I will do this in future too. But this does not solve the reason...

Connection from their IP? I thought you said you were connecting to a remote MySQL server. From a network security perspective only an outgoing connection from the server running your...

Store the filename in a variable and append the value in a new column to your pipeline using the Derived Column Transformation.

A Transformation Script Component in your Data Flow Task should work fine. This article explains the technique well in that it creates two output streams, one for rows containing numeric...

But you do have access to read the SQL that is run. You can setup an Extended Events session or a Server-side Trace to capture all SQL statements issued against...