Viewing 15 posts - 3,661 through 3,675 (of 49,552 total)
jasona.work (2/3/2016)
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
February 3, 2016 at 1:56 pm
sql.queries (2/3/2016)
Is this a good option to filter the table?
It'll work. The performance will be erratic and horrible, but it'll work.
https://www.simple-talk.com/sql/t-sql-programming/how-to-confuse-the-sql-server-query-optimizer/
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
February 3, 2016 at 11:55 am
Can you give some context? Where are you seeing cached_pages_count?
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
February 3, 2016 at 6:52 am
So you meant to say it is better to create a Clustered index on that particular column?
No. If I'd meant to say that, I'd have said that.
If TrackID is unique,...
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
February 3, 2016 at 6:17 am
Well, if you want to go and create extra nonclustered indexes, then whether you put include columns or not would depend on what purpose you're creating them for. I can't...
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
February 3, 2016 at 6:11 am
You can't put include columns in clustered indexes or constraints.
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
February 3, 2016 at 6:08 am
Brandie Tarvin (2/3/2016)
But when I tried escaping the underscores in my code, I got no results at all.
WHERE Column LIKE '%/_%' ESCAPE '/'
That would find anything with an _ 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
February 3, 2016 at 5:44 am
jasona.work (2/3/2016)
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
February 3, 2016 at 5:41 am
Yes, I just did.
You at the very least need a transaction around the whole thing, and a updlock hint on the query which fetches the current max value from 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
February 3, 2016 at 5:40 am
Rowlock's not going to help at all. You at the very least need a transaction around the whole thing, and a updlock hint on the query which fetches the current...
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
February 3, 2016 at 5:28 am
Yup, you're getting full table scans each time you run that update, because without any indexes at all, SQL has to scan the table because it's got no other access...
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
February 3, 2016 at 5:25 am
If there are no constraints or indexes, how is SQL supposed to figure out that trackID is unique? Without indexes, you're going to be getting full table scans, 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
February 3, 2016 at 5:12 am
Posting the same problem in multiple places just causes confusion.
Thread should probably continue at http://www.sqlservercentral.com/Forums/Topic1757984-392-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
February 3, 2016 at 5:10 am
The trackID is always unique
Is there a unique index or unique constraint on the column? Why does the table not have a clustered index? What indexes does it have?
Can...
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
February 3, 2016 at 4:49 am
Please post the deadlock graph (either the text form or attach the XML file)
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
February 3, 2016 at 4:37 am
Viewing 15 posts - 3,661 through 3,675 (of 49,552 total)