Viewing 15 posts - 2,776 through 2,790 (of 49,552 total)
A view is a select statement, nothing else. No procedures, no assignments, no parameters, no variables.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 20, 2016 at 2:26 pm
koti.raavi (7/20/2016)
If table variable is storing in tempdb why can't I use them like temp tables?.
Because they're not designed to be used the same way. It's got nothing to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 20, 2016 at 3:31 am
VastSQL (7/20/2016)
GilaMonster (7/20/2016)
Is the CheckDB output in the inital post the pre-repair output (as your post implies) or the post-repair output (what...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 20, 2016 at 3:24 am
You don't need to quote the whole thing again.
Is the CheckDB output in the inital post the pre-repair output (as your post implies) or the post-repair output (what I asked...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 20, 2016 at 2:25 am
Jeff Moden (7/19/2016)
smthembu (7/19/2016)
@Gail, what else to look for?
Can't speak for Gail but my suggestion would be... a small amount of money to at least quadruple memory or spend some...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 20, 2016 at 2:23 am
Is there by any chance a DDL trigger on that instance?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 19, 2016 at 9:00 am
smthembu (7/19/2016)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 19, 2016 at 7:36 am
GilaMonster (7/19/2016)
Sys.dm_exec_requests will frequently show a process as 'self-blocking' when that process runs in parallel (as CheckDB does) and the waits are normal ones to see when running CheckDB.
Was the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 19, 2016 at 7:32 am
Not opening here until late August afaik.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 19, 2016 at 7:21 am
Nothing you've said indicates a problem that needs fixing.
Sys.dm_exec_requests will frequently show a process as 'self-blocking' when that process runs in paralle (as CheckDB does) and the waits are normal...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 19, 2016 at 7:20 am
CAST the output as TIME
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 19, 2016 at 6:38 am
WhiteLotus (7/19/2016)
And also i did telnet from Server A :TELNET SERVERB 5033
5033, or 5023?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 19, 2016 at 6:03 am
Filtered index won't work in this case, as the filter on an index has to be deterministic. Can't filter for timestamp > dateadd(hh,-2,getdate())
Msg 10735, Level 15, State 1, Line 8
Incorrect...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 19, 2016 at 3:26 am
If you are running SQL 2008, then a server-side trace with Audit login success and Audit logout. If you're on 2012 or above, the same thing with Extended Events.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 19, 2016 at 3:02 am
You are updating the clustered index, as the clustered index *is* the table. All of the columns in the table are part of the clustered index (not the key, but...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 19, 2016 at 2:02 am
Viewing 15 posts - 2,776 through 2,790 (of 49,552 total)