Viewing 15 posts - 3,661 through 3,675 (of 49,571 total)
jasona.work (2/3/2016)
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/
February 3, 2016 at 11:55 am
Can you give some context? Where are you seeing cached_pages_count?
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,...
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...
February 3, 2016 at 6:11 am
You can't put include columns in clustered indexes or constraints.
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...
February 3, 2016 at 5:44 am
jasona.work (2/3/2016)
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...
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...
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...
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...
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
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...
February 3, 2016 at 4:49 am
Please post the deadlock graph (either the text form or attach the XML file)
February 3, 2016 at 4:37 am
Viewing 15 posts - 3,661 through 3,675 (of 49,571 total)