Viewing 15 posts - 76 through 90 (of 122 total)
Having a company laptop has revolutionised my work.
It's a decent i7 Thinkpad with (only) 8GB ram and SSD disk, and plenty speedy. We have a Cisco VPN which connects automatically...
August 12, 2020 at 2:28 pm
I've no experience with TFS (fortunately?), but have you had a poke around in Maintenance Plans and SSIS? Has it done something there to handle backups, which might give you...
August 8, 2020 at 8:45 am
smattiko83 wrote:Thanks again for all your help. Did the sample look ok?
A cursory glance says it looks fine. I didn't do a deep dive on it.
I'm shocked!! A CURSORy...
August 5, 2020 at 9:12 am
Jason, Jeff I like that 🙂
I need to use tally tables more, ever since I found out about them, but have been dallying with my tallying, as we're...
July 23, 2020 at 8:32 am
Jason, Jeff I like that 🙂
I need to use tally tables more, ever since I found out about them, but have been dallying with my tallying, as we're getting all...
July 22, 2020 at 8:55 pm
Not a complete answer to the OP's question, because it doesn't need the "IsWeekend" field or take into account Holidays, but I thought I'd join the discussion with this, if...
July 22, 2020 at 8:52 am
Shame. I guess converting a lot of those would be a huge development task 🙁
July 20, 2020 at 1:05 pm
Just an idea (caveat, not had the time it would need to totally get my head around all that code....) would the end use allow you refactor as a stored...
July 17, 2020 at 3:57 pm
Yup, of course NULL does not equal NULL, but the fldinfo cannot be NULL (confirmed by OP).
So presumably @Parameter is optional and can be NULL. In which case...
July 14, 2020 at 11:34 am
Using
WHERE @parameter IS NULL OR fldinfo = @parameter
You are comparing against a single value
It's not the same query as the one the OP posted. NULL does not equal...
July 14, 2020 at 8:49 am
Luis
You have the same column on the left and right of the equality
WHERE fldinfo=ISNULL(@parameter,fldinfo)
If @parameter is null it's comparing every row to itself.
Using
WHERE @parameter IS NULL OR fldinfo = @parameter
You...
July 13, 2020 at 1:09 pm
Luis
I see Scott beat me to it 🙂
That's what I was going to suggest if you came back and said the parameter was optional. I'm guessing you meant optional rather...
July 13, 2020 at 8:06 am
Apologies if you have already checked the obvious, but you haven't mentioned it. Is the SQL version the /only/ difference?
Is tempDB configured the same on both servers: separate, faster storage,...
July 12, 2020 at 10:11 am
What are you trying to achieve?
Is @parameter an optional parameter? Is tblInfo.fldinfo a NULLable column? Both?
Certain functions on the right side of the equality do not necessarily always impact performance.
For...
July 12, 2020 at 10:01 am
kcecil,
Thank you for taking the time to wade through that and reply.
That nice simple approach to the problem as a whole has merit, if I'd thought of that at an...
July 10, 2020 at 3:12 pm
Viewing 15 posts - 76 through 90 (of 122 total)