Gail Shaw

Forum Replies Created

Viewing 15 posts - 10,276 through 10,290 (of 49,552 total)

RE: Better Writing

djackson 22568 (1/23/2014)
Jim P. (1/23/2014)
Steve Jones - SSC Editor (1/22/2014)
If I make mistakes most days, then I'd like to hear about it, though I'd prefer the common courtesy of sending...
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

January 23, 2014 at 2:44 pm

#1682946
RE: Reducing deadlocks with update query hint or other method...

Dennis Post (1/23/2014)
It's been a week now.
NOLOCK hint did the trick.
No more deadlocks with this process.
No dirty read issues.
If you have nolock, then you have the potential for dirty...
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

January 23, 2014 at 6:25 am

#1682747
RE: Are the posted questions getting worse?

Whoops... http://www.sqlservercentral.com/Forums/Topic1533954-391-1.aspx
Anyone with TDE experience that can assist?
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

January 23, 2014 at 4:16 am

#1682703
RE: Detached DB After Dropping Certificate - Now I can't attached it

arrjay (1/23/2014)
Thanks for this. If I have dropped the certificate, would it be possible to then unencrypt the databases which are still attached to the server?
No idea....
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

January 23, 2014 at 4:15 am

#1682702
RE: Transaction log backup is too large

THE-FHA (1/23/2014)
Hi,
Could index fragmentation have also have an impact on this problem?
No. The size of the log backups is a function of the changes to the database over the period...
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

January 23, 2014 at 3:33 am

#1682691
RE: Detached DB After Dropping Certificate - Now I can't attached it

Was the database encrypted with transparent database encryption? If so, then without the certificate you won't be able to reattach the DB. Deleting the certificate would not have unencrypted 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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

January 23, 2014 at 3:30 am

#1682690
RE: Rank over with Clustered Index

lianvh 89542 (1/23/2014)
Thank you for the feedback. I am sorry for expressing myself incorrectly. Business wanted the data on screen more precisely ordered. It was up to Dev and 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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

January 23, 2014 at 3:26 am

#1682688
RE: System.OutOfMemory error

Again, your client application is running out of memory, probably due to the large result set. This is not a SQL Server error message, it's coming from whatever .net client...
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

January 23, 2014 at 3:24 am

#1682687
RE: SQL Server Logs

You can prevent all failed logins from writing to the log, but not one specifically
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

January 23, 2014 at 2:50 am

#1682671
RE: Transaction log backup is too large

If the log backups are too large, either reduce the amount of changes happening in the DB (usually not practical) or take log backups more often.
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

January 23, 2014 at 2:49 am

#1682670
RE: System.OutOfMemory error

You're running the client application out of memory. That's not a SQL Server error message.
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

January 23, 2014 at 2:48 am

#1682669
RE: What do you use to find out what's slowing down your instance right now

sql-lover (1/22/2014)
WHERE session_Id > 50 -- Ignore system spids.
Careful, spid < 50 indicating a system process hasn't been true since SQL 2000.
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

January 23, 2014 at 2:47 am

#1682668
RE: SEQUENCE vs GUID across tables - uniqueness?

JustMarie (1/22/2014)
GilaMonster - I'm talking about the 2012 SEQUENCE object type.
In that case, Kraig's comments on contention don't apply, he was talking about the practice of creating a table usually...
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

January 23, 2014 at 2:46 am

#1682667
RE: Rank over with Clustered Index

lianvh 89542 (1/23/2014)
Thank you for the feedback. There was a business requirement for the concatenated clustered index.
Why? Business requirements shouldn't specify the indexing locations and types, that's a technical detail,...
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

January 23, 2014 at 2:44 am

#1682666
RE: Better Writing

steve.neumann (1/22/2014)
this article made me laugh. there is rarely a day where you do not have some sort of grammatical mistake etc. there's even one here...
..."and possibly impress someone else...
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

January 23, 2014 at 2:42 am

#1682665

Viewing 15 posts - 10,276 through 10,290 (of 49,552 total)