Steve JP (4/24/2015)

---

There is a senior who wants to replace all the inline sql statements with sprocs. Well fine, the application will stop looping through 1000 inline statements and now...

If users demand access to the 'SA' account, then give it to them.

But first get rid of the default 'SA' and then create a new one having only the permissions...

If a database architect, IT support, executive, or BI developer needs eleveated permissions to troubleshoot performance issues or run ah-hoc queries in production, you can setup something like a power...

I think every DBA should sit down with the application development team at least once a year and...

For many of us, the role hasn't changed, it's just been defined using a new acronym, which makes it a lot easier if someone asked what we do.

DevOps, I...

Charles Kincaid (4/22/2015)

---

Eric:

In Japan would that be floor 4, and for the same reason?

Jeff:

Are you older than me? I guess that it could happen.

Also don't mess with disabled folks....

lptech (4/22/2015)

---

Simply not allowing access would put the person using the duress password at risk of serious injury or death. The duress code would have to lock down the building,...

ScottPletcher (4/22/2015)

---

Eric M Russell (4/22/2015)

---

ScottPletcher (4/22/2015)

---

With an existing table, you already know what the length of the columns will be, whether varchar or not. The formula provides you with...

ScottPletcher (4/22/2015)

---

With an existing table, you already know what the length of the columns will be, whether varchar or not. The formula provides you with the additional overhead SQL...

lptech (4/22/2015)

---

In the Charlie Hebdo attack, the terrorists forced an employee at gunpoint to swipe her card to get into the building. So a duress password on top of the...

LearnSQL!!! (4/22/2015)

---

Hello,

What is the best way to forecast\estimate space for non-clustered index on a table?

Example :

Table name : Test123

Row : 170000000

Reserved : 18000000 KB

Data : 70000000 KB

Index: 40000000...

Really, Google itself is just a massive honeypot used by marketing dicks to brand us and retail our browsing habits.

jay-h (4/22/2015)

---

Eric M Russell (4/22/2015)

---

...However, the actual error message is a shill. If the perp tabs over to Google and searches on "Error: 8514294078", now their IP address (and maybe...

Wayne West (4/22/2015)

---

Law enforcement has a honeypot...

There is no need for sp_executesql.

This should work as is.

SET @AlterSQL = 'ALTER TABLE ' + @DestinationTableName

+ ' ADD ' + @TempColumn + ' int;'

EXEC (@AlterSQL)...