Viewing 15 posts - 6,151 through 6,165 (of 22,211 total)
Don't get too hung up on the "narrow" aspect of what makes a good index key. Instead of "narrow" think "as narrow as practical." Then, suddenly, your key structure is...
May 6, 2015 at 10:14 am
You're getting an RID lookup because the nonclustered index isn't covering and you don't have a clustered index. The BMK that you're referencing is the storage location within the heap...
May 6, 2015 at 9:58 am
And rereading, You just won't be able to treat the MDF file the way you treated Access files through the Jet engine. It's utterly different. SQL Server is a service...
May 6, 2015 at 9:41 am
You can't "Open" an MDF file. You absolutely need to do the ATTACH process. But, instead of fighting with the GUI, let's go to the file.
I'm assuming that the original...
May 6, 2015 at 9:39 am
Sounds likely.
Just so you know, the causality tracking adds an additional value to the events. If any set of events are linked, they'll all have the same value, so you...
May 6, 2015 at 6:19 am
Joy Smith San (5/5/2015)
Snapshot of the disks is being done by respective team I believe.
So are you saying, we don't need database backups from sql server instance if the...
May 6, 2015 at 4:06 am
When in doubt, refer back to this book by Denny Cherry. Here's an article talking about it too. Read #7. With an AD account, you can set the minimum possible...
May 6, 2015 at 3:58 am
You don't need this:
ALTER DATABASE MyDatabase
SET ALLOW_SNAPSHOT_ISOLATION ON
That's a different kind of snapshot isolation that is controlled by each connection and transaction. Read_Committed_Snapshot should be sufficient. You're probably best setting...
May 6, 2015 at 3:52 am
Nice attempt at your first blog post.
Unfortunately, there are a few questionable suggestions in there.
For example, what's the difference between these two queries:
SELECT * FROM Sales.SalesOrderHeader AS soh
LEFT JOIN Sales.SalesOrderDetail...
May 5, 2015 at 5:24 pm
I'd set up an extended event session and include causality tracking. I'll bet this is part of some extended transaction and just evidencing the deadlock in a funny way.
May 5, 2015 at 5:10 pm
The Repeatable Read isolation level is much more restrictive, holding locks until a transaction is committed so that others cannot modify data, so yeah, that's absolutely going to lead to...
May 5, 2015 at 4:27 pm
That's weird. What's the isolation level on the connections do you know?
Sorry I don't have better info. This one looks really odd.
Nice job on the PR.
May 5, 2015 at 10:56 am
Yeah, those discrepancies can make you nuts. I usually don't even attempt to resolve them and just say "This one is different than that one" and keep going. Makes my...
May 5, 2015 at 10:11 am
Hey Jared!
I'm not sure. Are these statements part of a larger batch? Do you have triggers on the system? How about CDC or Audit? It seems like something other than...
May 5, 2015 at 10:04 am
Viewing 15 posts - 6,151 through 6,165 (of 22,211 total)