This is why I moved away from SSIS and ACE for spreadsheets with mixed data (ie numeric and alphanumeric) in the same column, unless I can guarantee the...

Bit of a funny one

😎

Extract from the execution plan (input value = 1)

(Scalar Operator(CASE WHEN [@i]=(1) THEN (10.00) ELSE CASE WHEN [@i]=(2) THEN (20.00) ELSE CASE WHEN...

Nothing one cannot do in SQL, but as Phil said, not for the faint-hearted

😎

My thought is that the NP will be packaged in a TCP/IP packet over the network, adds an overhead so it reverts to pure TCP/IP by default, not certain though.

😎

Quick thought, is port 445 open on both servers?

😎

Few thoughts:

1. Strongly recommend that you don't use the TEXT data type, better options are either VARCHAR(MAX) or NVARCHAR(MAX)

2. Using FOR XML PATH() is simpler and more legible than FOR...

3 words that...

hi,

I would like to convert the result of a SELECT FOR XML query into a text field to be able to manipulate the result in my development language.

if there...

Best wishes Steve and hopefully a speedy recovery for your daughter

😎

Happy new year guys and girls

😎

Think it is time for a "Sneaker" network connection, walk over to the box, unplug the network cables, disable the SQL Server Agent and then carry out Frederico's suggestion on...

I have an SQL server which I need to get admin access to.

Logged on as administrator to the server I attempt to start in single user (-m) mode. However...

Eirikur - Sure I've attached the plan running at Level 100.

This area of SQL, I am very much still learning. I can spot some stuff, but I'm still...

I have a stored procedure that run a number of update statements using table function to select 10% of the records based on the year the data was collected.

I’m...

That feeling when you want to point out that someone isn't correct about what they said, but you don't want to derail a topic and /...