Assuming your databases are stored on a SAN like most of the people out there, I wouldn't worry that much about fragmentation. Fragmentation really only matters if your disk can...

shorton2 (9/10/2015)

---

So I got close to getting this to work, but still having one last problem...

If I place the excel file literally ON the Windows Server that SQL server is...

shorton2 (9/1/2015)

---

Hi guys, Not sure if I picked the correct sub-forum, please point me if not.

I am in a corporate environment with IT managed SQL servers. "My" 2014 SQL...

You have converted the date to a VARCHAR, so now it's sorting alphabetically instead of by date. In other words, alphabetically would be 1, 11, 12, 2, 3 ...

Easy solution...

I use xp_CmdShell for 2 different things.

One is to export csv reports for end users.

The other one is to export and then FTP files to a third party...

arrjay (2/24/2015)

---

Hi there - I run this code on several environments successfully but when on run it on a different environment it fails.

Its very strange as the user...

Hard to say without seeing the stored procedures, but my first thought is that you have some bad parameter sniffing. There are many posts elsewhere about it if you want...

You have to be careful with something like this. You also have to ask what you want to happen if your change cannot be replicated to Father. Do you want...

mw112009 (1/27/2015)

---

I thought you could only have one clutstered key and that one should be the primary key ? Right/Wrong ?

Sorry, my bad vision, now I see in the image...

drew.georgopulos (1/26/2015)

---

The problem we are trying to solve is how to distinguish one thing from another. It never was an issue because things had been processed in silos, but in...

I think you'd be better off using something like powershell to monitor drive space on a different server. Though I suppose if you wanted to, you could have the SQL...

The first thing I think of is permissions issue. SSIS is probably not running under an account that has permissions to access the file in Sharepoint.

It's been a long time...

sqlmaverick (1/23/2015)

---

Hi, please help me to get below logic in Derived transformation, SSIS.

Logic:ensure the Docket number is 5 digits and populate with leading zeros if not.

I have to check input...

rcharbonneau1 (1/20/2015)

---

I'm using Report Builder 2.0. I have everything working great, but the data is kind of hard to read with the lines being so close together. Each ID has...

ft55 (1/19/2015)

---

Looking on an explanation on the following if possible.

At an O/S level Windows Server 2008 R2 is configured with Region and Language as English (United Kingdom)

At a server Collation...