Viewing 15 posts - 3,706 through 3,720 (of 7,609 total)
October 23, 2017 at 8:02 am
It always comes to that. "and worry about performance later". While I whole heartedly...
October 23, 2017 at 7:43 am
Weird. When a Merge Join is appropriate, it should typically be the fastest type of join. Make sure the query actually does have good row estimates. Also, if you rebuilt...
October 18, 2017 at 12:11 pm
I'd be inclined to just do this:
SELECT @RunDay = CONVERT(CHAR(2), SomeDate, 1)
FROM #TestTable;
October 12, 2017 at 3:28 pm
Interesting on the smaller ones. Probably just SQL generating a non-optimal query plan. You can probably resolve that; worst case, you'd have to use a "hint" to force SQL to...
October 11, 2017 at 11:24 am
That makes sense, sorry about the rant. It's just that I've seen far too many database "designs" where every table got an identity clustering key slapped on it before the...
October 11, 2017 at 8:08 am
It would very likely help performance. Certainly if:
1) you created a nonclustered columnstore index that covered the query entirely.
Or
2) the total rows you're retrieving were not a...
October 10, 2017 at 4:03 pm
October 10, 2017 at 1:14 pm
October 10, 2017 at 11:46 am
declare @name varchar(10) = 'Server';SELECT TOP (LEN(@name)) SUBSTRING(@name, ROW_NUMBER() OVER(ORDER BY (SELECT NULL)), 1)
FROM sys.all_objects;
This...
October 5, 2017 at 8:03 am
October 4, 2017 at 2:06 pm
Never use ISNULL in a WHERE clause: not only is it unsargable [not relevant in this particular case], but it can also make the code harder to understand. The code...
October 4, 2017 at 1:54 pm
The single most important thing is to do a logical data model before doing a physical database model.
Hints:
1) Google "logical data modeling".
2) Fillfactor, indexes...
October 3, 2017 at 2:42 pm
Viewing 15 posts - 3,706 through 3,720 (of 7,609 total)