Viewing 15 posts - 331 through 345 (of 5,842 total)
Break your query down to find issues like this. Start with the table that you filter on. Make sure it gives expected results. Join in one table to it, make...
March 20, 2017 at 12:26 pm
Note that it is pretty silly to REBUILD indexes and then update statistics on them! With REBUILD you get 100%-scan stats, the best you can have. With update stats unless...
March 20, 2017 at 11:23 am
I don't think that TOP 1 does what you think it does.
It does exactly...
March 20, 2017 at 9:37 am
March 19, 2017 at 11:15 am
March 17, 2017 at 8:24 pm
If you need to keep a relatively few of the billion+ rows in the combined tables I like the idea of quiescing the database, copying off what you need in...
March 17, 2017 at 11:19 am
March 16, 2017 at 1:22 pm
Use sp_whoisactive to see what is happening in real time. Review the 30-day blog post series that Adam Machanic has on SQLBlog.com about how to use it. For example, if...
March 16, 2017 at 8:30 am
March 16, 2017 at 8:26 am
Since you didn't do anything other than reboot (such as add an index, update statistics, etc) then it is almost certainly a parameter sniffing issue. Adding to this likely hood...
March 14, 2017 at 11:56 am
March 10, 2017 at 3:33 pm
Thank you, but I am still unsure how to move the SKU's with an 11 digit length to a temp table.
Did you set up a quick demo...
March 9, 2017 at 12:16 pm
March 9, 2017 at 12:15 pm
select * from Inventory
where Dept_ID = '1123'Department...
March 8, 2017 at 4:45 pm
Viewing 15 posts - 331 through 345 (of 5,842 total)