dianerstein 8713 (12/7/2016)

---

In a t-sql 2012 column I have a column called test1 defines as (varchar(10),not null) in a table called tab. The values in this column look like '16-17'...

You may well have this solved by now, but I thought I'd chime in and provide the connection between a query to figure out the...

getalok_akg (12/7/2016)

---

Hello All,

We are working into database migration project. There is requirement to migration sub-set of database into production without any down time .Also we have to migrate data and...

river1 (12/6/2016)

---

Hello,

I need to be able to test something (which will change some data on the big databases) and after revert it back to the normal state.

What is better option...

sqlguy-736318 (12/6/2016)

---

I'm trying to understand relative sizing for design conversation purposes. For example, in this context, would it be reasonable to state that?:

* Selecting 1 row from 1 table...

eshaw (12/6/2016)

---

Good day gurus!!!

I have a string in a varchar(max) field where I need to extract out only certain values. How would I go about getting everything out of...

Thanks Jeff for that rather good article. I learn something new every day, and love the learning!

As painful as that is, a book in any body cavity is going to be more painful and for a lot longer than it takes to waste your time. ...

sqlguy-736318 (12/5/2016)

---

I'm trying to get a better understanding of relative performance expectations for different types of queries. For example, given a typical SS configuration, what type of response time...

I'm not really seeing what your objective means in real-world terms. You seem to want some kind of bridge between your dimension table and your fact table, but...

sarah.hampson (12/6/2016)

---

Hi

Can anyone help please - I have a report that has two sub reports, the second sub-report needs to toggle images depending on the parameter value of the...

I may not agree with Mr. Celko's perspective, but I do think that if you have enough columns, you'll eventually have a "scale" problem. I'm...

r5d4 (12/6/2016)

---

I'm working in an environment where some very wide tables are present (400+ columns).

Whilst long term I will be restructuring these and applying some normalization, I need to...

Jeff Moden (12/5/2016)

---

sgmunson (12/5/2016)

---

Jeff Moden (12/5/2016)

---

sgmunson (12/5/2016)

---

Jeff Moden (12/5/2016)

---

Lynn Pettis (12/5/2016)

---

Jeff Moden (12/3/2016)

---

As you can see, the neat thing about...

Jeff Moden (12/5/2016)

---

sgmunson (12/5/2016)

---

Jeff Moden (12/5/2016)

---

Lynn Pettis (12/5/2016)

---

Jeff Moden (12/3/2016)

---

As you can see, the neat thing about nice simple answers...