Viewing 15 posts - 61 through 75 (of 9,643 total)
Is that the plan from DEV or production? Honestly there isn't a lot to see in that pan because everything is going across a linked server. There are a number...
September 15, 2017 at 12:47 pm
No worries. The estimated execution plan(s) would be fine. This article explains how to create the execution plan and then you can just save it as a .sqlplan...
September 15, 2017 at 12:39 pm
Could be a server setting, but most likely it is because of different statistics. Update stats on the dev server and see what happens.
If you post the plans...
September 15, 2017 at 12:18 pm
My recommendation is always to have the application handle encryption and decryption. If you use encryption builtin to SQL Server it makes it easier for people with access to the...
September 8, 2017 at 12:38 pm
Have you run a trace/XE session on the SQL Server to ensure that the query performance when called from SSRS is still as fast as SSMS? If you've never read...
July 10, 2017 at 11:26 am
I'm considering doing...
April 24, 2017 at 8:12 am
April 24, 2017 at 7:57 am
Ha ha. I clicked on Latest Posts and this showed up and it is 16 years old and I replied.
April 5, 2017 at 8:33 am
I think all you need is to add cs-username to the SELECT and add a GROUP BY cs-username. Like this:
SELECT
[cs-username],
SUM(CASE WHEN...
April 5, 2017 at 8:30 am
I have dealt with this in the past. If you use the transaction handling in SSIS as you have tried, it requires that DTC be running and configured correctly. The...
April 5, 2017 at 8:23 am
My rule of thumb for creating a constraint vs an index is the purpose of the object. If the main purpose is to enforce a business key (uniqueness) I create...
April 5, 2017 at 8:15 am
Hey, long-time no hear from.
Any chance you could normalize the structure so the Yes/No columns are in a separate or separate table(s). Maybe even an EAV table,...
December 13, 2016 at 10:37 am
Gary Varga (12/5/2016)
December 5, 2016 at 6:57 am
Steve Jones - SSC Editor (11/22/2016)
My son completed his Board of Review last night to earn his Eagle Scout rank. It's been a...
November 22, 2016 at 2:50 pm
jasona.work (11/2/2016)
Luis Cazares (11/2/2016)
That said, can...
November 2, 2016 at 12:11 pm
Viewing 15 posts - 61 through 75 (of 9,643 total)