Viewing 15 posts - 25,546 through 25,560 (of 49,552 total)
Ninja's_RGR'us (6/13/2011)
GilaMonster (6/13/2011)
Another tidbit. Naming of transactions is purely for documentation (with one rare exception). It doesn't affect what and how things are committed or rolled back.
Ok I gotta know,...
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
June 13, 2011 at 8:53 am
No, if a clustered index scan is shown a clustered index (table) scan was used. Could it be that the second time the data was in cache and hence 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
June 13, 2011 at 8:51 am
The first few here probably. They're not beginner-level though.
http://www.sqlskills.com/T_MCMVideos.asp
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
June 13, 2011 at 8:50 am
Another tidbit. Naming of transactions is purely for documentation (with one rare exception). It doesn't affect what and how things are committed or rolled back.
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
June 13, 2011 at 8:49 am
Thanks Brian.
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
June 13, 2011 at 8:07 am
jcrawf02 (6/13/2011)
SQLRNNR (6/13/2011)
GilaMonster (6/13/2011)
Anyone noticed that we now have pretty pictures as well as alphabet soup? http://www.sqlservercentral.com/Forums/Topic1123813-359-1.aspx
Yeah - not too sure what to think of it - much the same...
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
June 13, 2011 at 8:05 am
Stop restoring backups.
However that's stupid, seeing as the machine is a log shipping secondary.
Again I'm going to ask, is there a problem you're trying to solve here?
You will...
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
June 13, 2011 at 5:47 am
Couple other points.
Services (like IIS) shouldn't use NT AUTHORITY\SYSTEM (localsystem) as that means they only have permission locally. It's probably a default installation setting, but it's a bad one. 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
June 13, 2011 at 5:45 am
The lazywriter is supposed to sleep a lot. That's why it's called lazy. 😉 There are a fair few wait types that should just be ignored.
As for the OLEDB wait,...
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
June 13, 2011 at 5:35 am
Please don't cross post. It just wastes people's time and fragments replies
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1124167-1550-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
June 13, 2011 at 5:31 am
Anyone noticed that we now have pretty pictures as well as alphabet soup? http://www.sqlservercentral.com/Forums/Topic1123813-359-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
June 13, 2011 at 4:23 am
The NT AUTHORITY\ANONYMOUS LOGON should not be confused with NT AUTHORITY\SYSTEM.
NT AUTHORITY\SYSTEM represents the system of the host machine and is the one that typically has sysadmin rights in...
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
June 13, 2011 at 4:20 am
There's always some latency. It's unavoidable if you're talking about getting data to another instance in a form that can be queried. How much is another matter.
Is the second server...
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
June 13, 2011 at 4:07 am
sqlnaive (6/13/2011)
1. Difference between db_datareader/writer and db_datadenyreader/writer. If a user has granted both, what permission level will be in effect ?
The first Grants the permissions. The second Denies the permissions....
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
June 13, 2011 at 4:03 am
http://www.microsoft.com/learning/en/us/certification/cert-sql-server.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
June 12, 2011 at 3:07 pm
Viewing 15 posts - 25,546 through 25,560 (of 49,552 total)