Forum Replies Created
Viewing 15 posts - 19,156 through 19,170 (of 49,552 total)
-
RE: Best Practices for "Layered" security
Read up on ownership chains.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Are the posted questions getting worse?
Can a sysadmin help out here (regular questioner) http://www.sqlservercentral.com/Forums/Topic1282732-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 recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: windows update
Most larger companies will have some form of automated patch management and/or a local patch 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 recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Are the posted questions getting worse?
Lynn Pettis (4/12/2012)
GilaMonster (4/12/2012)
Just for a permanent record...Right, now to clean the whiteboard off and make more lists.
So, that means your the expert in all those areas, right?
Ex-spurt? No, 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 recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Are the posted questions getting worse?
Just for a permanent record...
Right, now to clean the whiteboard off and make more lists.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Are the posted questions getting worse?
Lynn Pettis (4/12/2012)
I know, I'll go 12 hours or so tomorrow without even looking at the forums. Should be easy since I'll be driving to Prescott, AZ tomorrow. ...Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Database mirroring in Express edition
No.
The only role within database mirroring that Express can do is the witness role.
Standard edition for sync mirroring. Enterprise for sync and async.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Database Connection Interrupted .Please attempt to restart the application.
That's not a database error, it's an error from the application. I'd guess that the application lost connection for some reason (cluster failover will do that, as will many network...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Are the posted questions getting worse?
GSquared (4/12/2012)
Or do you have something more specific in mind?Today's example:
SELECT <stuff> FROM
Table1
inner join (SELECT <more stuff> INTO #Temp FROM AnotherTable) ON <join clause>
inner join (....repeat several more subqueries...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Are the posted questions getting worse?
Lynn Pettis (4/12/2012)
GilaMonster (4/12/2012)
I'm getting very frustrated (and very saddened) by the (apparently) increasing number of people who seem to feel that writing T-SQL is about throwing code segments together...Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Need desperate help with SQL Server
Please read through this - Managing Transaction Logs[/url]
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Are the posted questions getting worse?
Steve Jones - SSC Editor (4/12/2012)
Today is a day I am tempted to throw one of them off the roof.Photos of the aftermath are required. :hehe:
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Are the posted questions getting worse?
I'm getting very frustrated (and very saddened) by the (apparently) increasing number of people who seem to feel that writing T-SQL is about throwing code segments together at random apparently...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: How does one force a column (which is not the PK) to be unique?
First thing would be to ask the department how they handle (or would handle) people with duplicate initials.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Faultfinding possible I/O issues
Perfmon is not the place to look, you don't have disk performance problems, you have disk stability problems.
And no, the figure for bytes/write is not milliseconds. It's bytes. It shows...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass
Viewing 15 posts - 19,156 through 19,170 (of 49,552 total)