Viewing 15 posts - 13,981 through 13,995 (of 49,552 total)
karthik M (3/8/2013)
Why does it matter which one SQL uses?
I am asking "Out of Curiosity" to know the algorithm used by the engine.
So download the public symbols, attach a...
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
March 8, 2013 at 4:48 am
UncleBoris (3/7/2013)
Very happy to be corrected but is it true that the Log Chain is only interrupted by the full backup IF the backup regime does Differential backups?
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
March 8, 2013 at 3:12 am
Mismatched brackets in the inner WHERE clause. Opened here and not closed (AccountNumber IN ('PARISH')
This is syntactically valid
SELECT ToBeActionedBy ,
...
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
March 8, 2013 at 3:07 am
sys.dm_os_wait_stats
CXPACKET is at the top (15%), followed by...
SP_SERVER_DIAGNOSTICS_SLEEP
XE_TIMER_EVENT
HADR_FILESTREAM_IOMGR_IOCOMPLETION
DIRTY_PAGE_POLL
BROKER_EVENTHANDLER
XE_DISPATCHER_WAIT
LOGMGR_QUEUE
Most of those are meaningless waits, background processes that are supposed to be waiting. That list says nothing of any value.
CheckDB is not...
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
March 8, 2013 at 2:59 am
karthik M (3/8/2013)
My question is simple, is there any alogrithm used for ORDER BY...
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
March 8, 2013 at 2:54 am
PiMané (3/7/2013)
If the number of files for tempdb is related with the number of CORES why doesn't the rule apply for database files?
Because you're not continually (as in many times...
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
March 8, 2013 at 2:51 am
Sean Lange (3/7/2013)
It seems that Gail beat me to it. 😀
I think yours is a bit simpler than mine.
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
March 7, 2013 at 2:38 pm
mtnclimberutah (3/7/2013)
Hmmm that's crappy. The two files are suppose to be addressed as one sequential topology, but evidently are not.
They are. SQL will use one, then 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
March 7, 2013 at 1:56 pm
A little complex, but...
CREATE TABLE #score (
StudentID INT IDENTITY(1, 1)
...
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
March 7, 2013 at 1:53 pm
opc.three (3/7/2013)
Instead, have them look into enabling READ_COMMITTED_SNAPSHOT mode at the database level.
Or ALLOW_SNAPSHOT_ISOLATION and SET TRANSACTION ISOLATION LEVEL SNAPSHOT
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
March 7, 2013 at 1:08 pm
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1428198-291-1.aspx
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
March 7, 2013 at 1:01 pm
Adam_Smasher (3/7/2013)
So, SPID4 is reporting the problem, not necessarily the cause of the problem?
Correct.
The slow IOs is telling you that in the last hour, there were x number of IO...
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
March 7, 2013 at 1:01 pm
Computed column, absolutely. No need for a trigger here.
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
March 7, 2013 at 12:27 pm
where RegionName = @Region
Where the split up region name is the same as the original concatenated list? Don't think that's quite what you want....
How are the split up region and...
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
March 7, 2013 at 12:23 pm
System process.
It's session_id 4 and the s marks it as a system process. So spid 56s would be some system process running on session_id 56
p.s. Session_id 4 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
March 7, 2013 at 12:03 pm
Viewing 15 posts - 13,981 through 13,995 (of 49,552 total)