Viewing 15 posts - 31,576 through 31,590 (of 49,552 total)
Also check that you aren't enabling implicit transactions as a connection option and that there's no other wrapping transaction (no begin transaction statements that don't have an associated commit)
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 29, 2010 at 4:54 am
Then take the reference to the snapshotdate out of that query entirely. You should be able to read the rest of the columns. Once you;ve got that, you can decide...
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 29, 2010 at 4:52 am
Tom.Thomson (7/28/2010)
GilaMonster (7/28/2010)
So far this week I've seen two different people advocating backing the log up...
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 29, 2010 at 2:47 am
Please post new questions in a new thread. Thanks.
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 29, 2010 at 2:45 am
RichardDouglas (7/28/2010)
Yes it's true, I've had it mentioned to me several times by an MCM that as of 2005 transaction logs will not break the log chain. Nice feature.
Transaction log...
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 29, 2010 at 2:43 am
Could you please edit that and use the [ quote ] blocks? It's very hard to read who said 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 29, 2010 at 2:41 am
Sounds like someone's written a custom DDL trigger, either as a database-level trigger in the DB you're recreating or as a server-level trigger.
It's not a built-in object, it's something specific...
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 28, 2010 at 2:17 pm
Please note. 7 year old thread
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 28, 2010 at 1:14 pm
Nope. That's about as good as it'll get. any tuning will depend on indexes.
http://sqlinthewild.co.za/index.php/2010/02/18/not-exists-vs-not-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
July 28, 2010 at 1:09 pm
The Dixie Flatline (7/28/2010)
Can I borrow a cup of reality?
<checks around kitchen> Sorry. Fresh out. Think I used the last of it at a client 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 28, 2010 at 1:07 pm
jeff.mason (7/28/2010)
You would in that command do the clustered index first, and then that would rebuild the non-clustered indexes after.
On SQL 2005+ rebuilding the cluster does not rebuild nonclustered indexes....
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 28, 2010 at 12:23 pm
Well one part of that is easy to answer. When to use db_owner: never. It's far too high a permission level for an application. Someone with that can do *anything*...
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 28, 2010 at 12:21 pm
Lynn Pettis (7/28/2010)
[Must have missed those, good thing too! 😛
I'm sure I can fine one of the links at least. It was the 'recover data with no backup' thread that...
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 28, 2010 at 10:34 am
CirquedeSQLeil (7/28/2010)
You jest, but there was an answer in the forums again this week advocating the dropping of the log file.
The one I went ballistic over or another?
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 28, 2010 at 10:33 am
bitbucket-25253 (7/28/2010)
Are the OPs getting bummer and dumber or just lazy and lazier
Yes.
There have been some really 'entertaining' questions lately. There have been some 'entertaining' replies too.
So far this week...
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 28, 2010 at 9:54 am
Viewing 15 posts - 31,576 through 31,590 (of 49,552 total)