Its very hard to say without actually seeing what is happening at the specific time on the server.

However it sounds potentially like you have blocking occurring which is holding up...

itumelengd (10/5/2015)

---

The code below might help:

CREATE TABLE #Temp

(

[Column A] VARCHAR(10),

[Column B] VARCHAR(5),

[Column C] VARCHAR(10)

)

INSERT INTO #Temp VALUES

('XXXXXXXXXX','64856','Test001'),

('XXXXXXXXXX','64857','Test002')

SELECT [Column A] AS ColumnA

,[Column B] AS ColumnB

...

Having done some testing this is definitely outside my level of knowledge with XML. Hopefully someone else can post up a solution.

XML is not a strength of mine but I think this is possible using the FOR XML EXPLICIT command

https://technet.microsoft.com/en-us/library/aa226532(v=sql.80).aspx

I don't have time to try and do this with your...

You have given far too little information to go on, if you can post up the schema and sample data from your table it would help someone give you a...

The 40-463 training kit book is adequate to get through the exam, make sure you lookup the corrections for the book though.

As long as you have a good understanding of...

I meant to add, that realistically if you want to pass the exam and more importantly know the functionality inside out you have to be prepared to give up...

The 70-464 exam is a fairly tricky exam, without breaching the the NDA its the format of the questions I found difficult rather than the actual question being asked.

What I...

Having you checked to see where the SPID's originate from, this query will identify that.

select Spid, Status, last_batch, hostname, program_name, nt_domain, nt_username, login_time

from sysprocesses

WHERE DBID = DB_ID('msdb')

We have an organisational structure that's a bit of a combination of Grant and Jeff's replies.

The DBA team has 4 levels outside management:

*Associate DBA

*DBA

*Senior DBA

*Principal DBA

We have one DBA team...

There is a few free ebooks and links to books that can be bought here on sqlservercentral:

http://www.sqlservercentral.com/Books/

And the MCSA books are readily available on line in the likes of amazon...

^^ As above.

I would also add that studying the SQL 2012 MCSA materials is a good idea as well as this covers the basics of SQL server and gets you...

ITU_dk2012 (9/1/2015)

---

@Ed Wagner

Thank you so much for the link.

@mmiski

I am not using any linked servers so not sure what to use. I recall that I have used OPENROWSET before but...

We have this from time to time and its due to the file save format being in Unicode rather than ANSI or vice versa.

Its been a while since I done this, but create your excel file from a excel template. This thread pretty much explains it all:

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/c55a7763-630e-4fcf-9b70-b1fdab82d623/writing-ssis-package-to-load-data-in-new-excel-file-every-time-it-runs?forum=sqlintegrationservices