It is not uncommon that performance changes drastically from day to another in DBMS with a cost-based optimizer. As the data volume grows, the statistics changes, and the optimizer may...

I can confirm what John says. I actually have VS 2005 installed (as well as a few later VS versions), and attempts to connect to SQL 2008 or SQL 2014...

We don't know your exact context for this arrangements, but it sounds like you have users all over the place that connect to your database. Let's make this clear: this...

hello, my application with vb.net connect to database though internet, that why ssms can connect though internet. So, i want increase security. I want to disable connect with ssms though...

Exposing SQL Server on the internet is a bad idea, so that's where you start. As long as you have it exposed, connections through SSMS is possible. There is no...

Batches can be submitted in two ways to SQL Server. When you run a batch of one or more queries from SSMS, that will always result in an SQL:BatchCompleted. That...

This is the solution I posted in the other thread:

-- SQL 2012 and later
; WITH prevs AS (
   SELECT *, LAG(end_date) OVER (ORDER BY START_DATE)...

I believe that I checked the output, but I don't have that query window set up any more. Since I am short on time, could you care to explain that...

-- SQL 2012 and later
; WITH prevs AS (
   SELECT *, LAG(end_date) OVER (ORDER BY START_DATE) AS prev_end_date
   FROM   temp_date
)
UPDATE prevs
SET...

Do you actually have 65GB remaining on the drive to create the file? And, I've got to ask, are you sure the path is correct?

And even if Snargables has 65...

The data type to use for Word or PDF documents is varbinary(MAX), nothing else. While you see text when you look at them in specialised editors (that is, Words and...

You can't. These filters exists only for a specific purpose and you have no access to them. More precisely, they extract all words from the document, so that you search...

Jeff is right on the money. Parsing PDFs or Word documents in SQL is so completely alien that it did even occur to me that you may be considering that....

As I said, the problem was in something you did not tell us about. There was no UNION in what you posted, was there? 🙂

But that is correct, UNION implies...

I guess that pcq0125 want to use Javascript, because he/she is in a browser. You rarely run Powershell from a browser...

I don't do Javascript, so I cannot offer any examples....