Grant Fritchey (7/8/2016)

---

I'm in agreement with Kevin.

Since the clustered index defines data storage, I recommend that the cluster be the most commonly used path to the storage. If that's the...

Just to totally rule out a...

keymoo (7/7/2016)

---

The folder I am iterating over is a project parameter and works fine (and is a UNC path that is permissioned to my user account and the SQL Server...

wendy elizabeth (7/7/2016)

---

In t-sql 2012, I want to compare the values of 2 columns the values of [Identity].MiddleName to ALF.SPA1_MiddleName. The [Identity].MiddleName will always have the correct name but the...

What is the purpose of console.ReadLine ()? That looks interactive to me.

A bit of a newbie question, but have you confirmed that the SQL Server instance is configured to use mixed mode authentication?

It's probably not finishing because there's a permissions issue somewhere (either in accessing the data or in writing the file).

You don't have to do anything special to make it finish...

The folder to be iterated over can be a package or project parameter. Can you confirm that you are using UNC naming conventions throughout (and not drive letters)?

The file names...

sqld-_-ba (7/6/2016)

---

Hello Fellow DBAs/Developers/Consultants/Managers,

I couldn't find a reliable + recent source for DBA salaries in USA.

If you're interested in this poll, you must select 4 options :

one (and only one)...

It's explained in detail & perhaps that makes it seem a lot. It really isn't.

Basically, you need a variable. You run an execute SQL task and map the results of...

dirkdirden (7/5/2016)

---

I can't seem to figure out how to add a variable that uses a table for its value.

I'd like to use

SELECT DATEADD(HH, -1,MAX(LastModifiedDate)) FROM TicketsTable

As my variable.

Currently I...

Steven.Grzybowski (7/5/2016)

---

Is it possible to open a package in BIDs and then run it programmatically? I have a few packages that can't be run on the server due to...

dndaughtery (7/5/2016)

---

Hey guys, I foresee the possibility of going to Project deployment on my team. The one big red flag that concerns me is that if one of the developers...

Jeff Moden (7/4/2016)

---

Phil Parkin (6/28/2016)

---

Jeff Moden (6/27/2016)

---

jeffe_verde (6/26/2016)

---

The files have data for the Asia-Pacific, EU, and the Americas financial markets (thus the AP, EU, and AM in the file names),...

tindog (7/5/2016)

---

Michael L John (7/5/2016)

---

Can anyone in the U.K. (or is it K minus U these days?) make a recommendation for technical training? We have a colleague in London...