Viewing 15 posts - 586 through 600 (of 1,583 total)
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 31, 2013 at 12:49 pm
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 31, 2013 at 10:37 am
"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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 30, 2013 at 2:20 pm
ScottPletcher (8/30/2013)
MyDoggieJessie (8/30/2013)
It may "bypass" the locking of the records it's ready but it does not improve performance or reduce any overhead one bit.
LOL. That's self-contradictory --...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 30, 2013 at 2:14 pm
It may "bypass" the locking of the records it's ready but it does not improve performance or reduce any overhead one bit.
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 30, 2013 at 1:30 pm
+1 @sean-2
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 30, 2013 at 11:10 am
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,...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 29, 2013 at 1:56 pm
Guras (8/29/2013)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 29, 2013 at 1:29 pm
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 29, 2013 at 1:03 pm
Unless there's a reason you can't, please attach what you've accomplished so far - and we can go from there?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 29, 2013 at 11:02 am
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 29, 2013 at 10:56 am
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 29, 2013 at 10:51 am
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 29, 2013 at 10:27 am
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 29, 2013 at 10:20 am
Have you checked to verify the linked server referenced in the stack dump? Could be an issue there (security/external to the linked server) and whenever this query gets run,...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 29, 2013 at 10:12 am
Viewing 15 posts - 586 through 600 (of 1,583 total)