Well, if you only have a couple dozen nails to drive and...

Sergiy (3/12/2013)

---

Silly idea, I recon, but would not hurt to try:

SELECT DT.*, T.COLText_10

FROM (

SELECT

COLMAIN_ID, COL1, COL2, COL3, COL4,

COL5, COL6, COL7, COL8, COL9,

COL11, COL12, COL13, COL14,

COL15,...

Adam Bean (3/14/2013)

---

Thanks for the responses, definitely great suggestions and gives me more ideas to work with.

Currently though, thanks to a friend of mine, I began playing with column store...

I wouldn't exactly call myself a 733t execution plan analyst (and I tremble to even post on a thread where Grant Fritchey has...

colin.Leversuch-Roberts (3/11/2013)

---

well it sounds like an io wait .. use the function sys.fn_virtualfilestats to see what's going on initially.

the partial script you've pasted doesn't look like it's written for...

brownph99 (3/10/2013)

---

I'm working with both a Vendor's DB and a purge script they've provided, and I need some outside opinions.

This purge runs incredibly long, especially on our SAN. Our first...

Sharon S (3/8/2013)

---

Hi all,

I am trying to create the Expression equivalent of the following query:

SELECT count(TasksName)

FROM [db].[dbo].[testdetails]

where TopLevelProjectName = '40 Project Folder'

and TasksName = 'Project Info'

I basically need a...

Code-1029433 (3/6/2013)

---

Hi Guys,

We have a 3rd party developing our data warehouse, and we do the SSRS devevelopment in house via BIDS and report builder. The DW devlopers want...

Jeff Moden (3/12/2013)

---

jcrawf02 (3/12/2013)

---

WayneS (3/11/2013)

---

Jeff Moden (3/10/2013)

---

Nah... I've gone wireless....

Raghavendra Mudugal (3/11/2013)

---

honza.mf (3/11/2013)

---

wolfkillj (3/11/2013)

---

I think Microsoft made its explanation of how the cutoff year functions more confusing by using the word "century". In my mind, and I suspect many...

krishnasavalia (3/10/2013)

---

HI Guys,

I came to a situation where I have to load XML file in SQL server tables. I have worked in past to load XML using node method but...

demonfox (3/11/2013)

---

Inscrutable , is that the right word :ermm:

well, as explained in...

Jeff Moden (3/10/2013)

---

Stefan Krzywicki (3/9/2013)

---

Jeff Moden (3/8/2013)

---

Matt Miller (#4) (3/8/2013)

---

Jeff Moden (3/7/2013)

---

Revenant (3/4/2013)

---

Evil Kraig F (3/4/2013)

---

Revenant (3/4/2013)

---

I always find it frustrating when someone asks me or someone else to do...

Jeff Moden (3/10/2013)

---

Matt Miller (#4) (3/9/2013)

---

Jeff Moden (3/8/2013)

---

Matt Miller (#4) (3/8/2013)

---

Jeff Moden (3/7/2013)

---

Revenant (3/4/2013)

---

Evil Kraig F (3/4/2013)

---

Revenant (3/4/2013)

---

I always find it frustrating when someone asks me or someone else to...

Lynn Pettis (3/10/2013)

---

GilaMonster (3/10/2013)

---

Since it's the msdb job tables, it's a bit of a stretch to say we don't have data. That said, that had a feel of 'do this...