Grant Fritchey (3/16/2015)

---

I'd probably reverse build on this. If you need to manipulate files and do t-sql, I'd write it in PowerShell and call the T-SQL from there rather than...

Hi Jeff,

the reason is because I am trying to remove the periods from a filename (or at least replace them) before doing a bulk Import. For me it seems...

Hi,

I would register all of the servers and instances in a central management server rather than use powershell. Once that is done you can run a single script against...

rummings (3/10/2015)

---

We are planning to migrate from a SQL Server 2008 R2 Active\Active two node cluster to a SQL Server 2014 two node cluster using Availability Groups. I have been...

JarJar (3/10/2015)

---

kevaburg (3/10/2015)

---

I am curious. You seem to have made up your mind what works for you so why are you pushing so hard against the advice of People...

I am curious. You seem to have made up your mind what works for you so why are you pushing so hard against the advice of People whose experience...

JarJar (3/10/2015)

---

kevaburg (3/9/2015)

---

"Separation of databases which don't play nice together". The Problem with this Statement is that when you have databases that don't Play well together you Need to...

JarJar (3/10/2015)

---

this pretty much is what i...

Are you running it from the SSMS? If you are check to see if the studio opens by default into SQLCMD.

samira.emami.g (3/8/2015)

---

My Server have Good CUP and Memory

When I Run a Query Cup usage is 30% and query Execution time is 30 Sec

Why Instead Query Execution time Increase SQL Not...

You are installing a patch to the SSMS.....the answer is in your question! 🙂

JarJar (3/9/2015)

---

thanks kevaburg. i'm pretty much clued in to all that. what i don't understand is where the limitations are in Windows Server, if any.

why should I maintain...

Perry Whittle (3/9/2015)

---

first thing I would ask is what is the recovery model in use on the DW database?

I'm sure you've heard a hundred times "don't shrink your transaction logs".

If...

ken.trock (3/9/2015)

---

We also run a DWH with almost all the DBs in simple recovery mode. I run a script like this every night though I don't take the extra check...

Good morning!

This is certainly an interesting topic because in our firm we have two DWHs in place to facilitate a cut-over from one system to the second. The new...