It's a little hard to tell just from the graphs if you have an issue or not. Hopefully, if you've got a SAN, you've got a SAN/Storage admin that can...

Let me start out by saying I'm not 100% sure of everything that's going on here. I'm honestly a little bit surprised that the non-digit characters get preserved in the...

A bunch of years ago, I created a terrible stored procedure to allow me to export data from the SQL Server. This is for my own internal use, so it's...

If you have the option of a test environment, or can put in test data, it's easier to figure out what goes where by putting dummy data in the front...

You have to be careful with functions, because there are a lot of ways that you can write a function that will kill your performance. One of the biggest ones...

It's going to be coming from the server that's running the code.
You're telling it to execute the function GETDATE() and send the results of that function to the destination.

There are a couple of options you can try that will let things place nice together.
I'm imagining that what happens is the report ends up taking out a table...

If you're asking what port you're connecting from, the answer is that your computer picks a random port to make the connection to the remote FTP server. When your computer...

I notice in your screenshot that you're missing an equals sign in the middle of your connection string. I'm assuming it's an encrypted string, and probably is not able to...

The MSDN site has some guidelines for things to try.
https://msdn.microsoft.com/en-us/library/ms177445(v=sql.105).aspx
If it were me, the first thing I would do is lower the batch size....

OK, this is a really quick and dirty way that I use to generate CSV files, which Excel will happily open.

They key to this one is that the parameter @NameOfTableToExport...

First things first, this breaks normalization and there are other ways to do it. If you have a one to many relationship with parent to child, you're going to have...

Start with Brent Ozar's worksheet on HA/DR for a starting point of discussion.

http://www.brentozar.com/archive/2014/05/new-high-availability-planning-worksheet/

If you like your job, then the best thing you can do is try to work within the...

I'm not really sure this is possible. The issue is that in a domain with active directory, you have a third server (the domain controller) that validates the user to...

djacobos (9/16/2015)

---

I have SQL Server 2012 Standard installed on Windows Server 2008 R2 Datacenter. SQL is set to allow mix mode sql/windows authentication.

I have a requirement to...