If you want to concentrate on connections, monitor the performance counter SQLServer: General Statistics – User Connections. For a more sophisticated analysis, you might also include other counters such...

Yes, the 2 is converted into a date - 3rd January 1900, so you'll always get Wednesday for that, no matter what your language settings.

John

Well, it works for me if I convert to nvarchar(23) instead of datetime, and make a couple of other minor tweaks, thus:

set @SQLQuery = 'SELECT RequestDate, IP, RequestID, CustomerID, LoanID,...

Why do you have [font="Courier New"]cast(@RequestDate as datetime)[/font] when @RequestDate is already datetime? Do you not want to cast it to nvarchar(23) or something like that? Better still...

Sounds like a job for the MERGE statement (although make sure you understand the pitfalls before you use it). I can't be any more specific, though, without table DDL...

It's just an alias for the virtual table [font="Courier...

Talib123 (6/10/2016)

---

Sounds more like a political issue rather than technical. It would seem you don't have the authority to govern the server in question.

You need to play a...

With that example there's no difference, so my advice would be to go with what's simplest. But if you were to put the dynamic SQL version into a stored...

Write a script in Powershell (or your favourite scripting language) that will take the most recent file and copy it to its destination. Alternatively, there's probably a task in...

No, I don't think so, unless you've already got something set up to track changes like that.

John

If n is small, it can be more efficient to use char(n). The storage requirement for varchar(n) includes a two-byte overhead to handle the variable length.

John

No, SQL Server Browser is just to resolve instance name to port name on the local computer.

John

In that...

Brilliant! I knew there'd be a better way of doing it. You're returning that final separator, but that can be either ignored or easily got rid of.

John

Yes, with queries, part of the execution time is transmitting and displaying the result set. With maintenance activities, that's a very much small proportion of the work that's done.

John