Will do, and thanks for the quick responses.

Heard back from IT, a new drive should be installed within the next 2-4 hours, then another few hours to get the data...

Found out there is a drive failing in one of the RAID arrays, so IT is looking into having it rebuilt/add a new on in

When that's resolved, my plan is...

Thanks Gail, I will co-ordinate with our Tech Services team and see what they can find at the hardware level, perhaps we've had a drive go bad in our of...

"I don't know why so many want to deny that: THAT'S the main reason NOLOCK is available, to allow one to reduce locking overhead" - I do agree with this...

ScottPletcher (8/30/2013)

---

LOL. That's self-contradictory --...

It may "bypass" the locking of the records it's ready but it does not improve performance or reduce any overhead one bit.

+1 @Sean

And to the OP, if you do post a question without sample data/DDL for the tables needed (etc), at least attach an actual execution plan - as most of...

You get the "squiggly" because your local cache is out-of-date (press Ctrl + Shift + R to refresh it). SSMS isn't yet aware of the recent changes...

Temp tables, CTE,...

Guras (8/29/2013)

---

Thank yoy for the reply, actually this is what I am trying to do. I have bunch of objects that I need to create on multiple databases. I...

Depending on the complexity of your procedure, something like this could work:D-E-C-L-A-R-E @Text varchar(1000)

SELECT @Text = 'IF ''?'' NOT IN(''master'', ''model'', ''msdb'', ''tempdb'') BEGIN USE ? EXEC(''CREATE PROCEDURE YourProc AS...

Unless there's a reason you can't, please attach what you've accomplished so far - and we can go from there?

Yes I could tell from the "AS Expr1" very common when creating a view from the GUI and then looking at the code 🙂 Has the schema on the...

Yes, do a ForEach Loop container, choosing the Foreach File Enumerator - then use a script to detect the size of the file - You'll probably need a variable or...

It's DatabaseName + Schema + Object

i.e. [JBD_V_CH_Info].dbo.TableName

Looks like you have Schema.Table.Column in your query...try:SELECT rpt.LName + ', ' + ISNULL(rpt.FName, ' ') AS clientname

,rpt.Client_ID

,rpt.LName

,rpt.FName

,rpt.AdmitDate

,rpt.DischargeDate

,rpt.Code

,rpt.AbbrName

,rpt.ID AS Expr1

,jbd.ENDTIME

,jbd.poscode

,jbd.dmcode

,jbd.dmabbr

,jbd.posabbr

,jbd.CAD226

,jbd.CAD204

,jbd.CAD205

,jbd.CAD207

,jbd.CAD227

,jbd.FullName

,jbd.BOX

,jbd.OCount

,jbd.SCount

,jbd.[Days Diff]

,jbd.RECORDED_SERVICE_VOIDED_MONIKER

,jbd.datepartofstarttime

,jbd.CLIENT_IDENTIFIER

,jbd.Expr1...

You could tryEXEC sp_trace_event @TraceID, 12, 48, 1

Where @TraceID is the ID of the trace to be modified, and 48 being the column ID for the event itself (in this...