Viewing 15 posts - 1 through 15 (of 171 total)
Stopped using the import wizard back in SQL 2005, when they BROKE the text qualifier. It worked in SQL 2000, was broken in 2005, I stopped testing for it in...
July 16, 2021 at 5:30 pm
Freezing the header of a table is simple for the online version of an SSRS report, but freezing the header of a spreadsheet exported from an SSRS report appears...
March 12, 2021 at 5:16 pm
Appreciate you pointing out the correct way to do this Ginger. My users also thank you.
Curious what the 'keep header visible while scrolling' row and column checkboxes are for. Since...
March 12, 2021 at 5:08 pm
First off, thanks for the article. Please continue to contribute and don't let my post discourage you.
I dove head-first into this statement when it first came on the scene. Spent...
February 12, 2021 at 10:25 pm
Omg who adds a db with logical filename master. Thx for the hint towards TF 902.
Why is it even allowed?
July 27, 2020 at 3:06 pm
I would use SYSDATETIME() instead of GETDATE() in examples as a better choice these days
I've never used sysdatetime. I'm genuinely curious why you recommend this.
February 27, 2020 at 2:39 pm
>> I've only been in IT for 15 years and at the ripe age of 48, I know that's a very short time for many of you,.
LOL! I have...
January 9, 2020 at 1:25 pm
I've only been in IT for 15 years and at the ripe age of 48, I know that's a very short time for many of you, but I've learned way...
January 7, 2020 at 8:02 pm
OK let me in on the alliteration joke
Oh, I just found Jeff's response to be "poetic" so I alliteratively responded to keep mine poetic too. Don't worry, I won't...
November 27, 2019 at 9:07 pm
Hoo boy... This has the propensity to rival the robust rhetoric between bombastic blatherskites on bankers rounding or nulls.
Well, you placed this poetic perfection like a placard to polarize the...
November 25, 2019 at 5:45 pm
If you change UNION to UNION ALL for each one in the original query, it comes back as an even better query plan than the one DesNorton proposes.
Good eye. ...
November 16, 2019 at 8:05 pm
One takeaway I had from your post is that you use tables in another DB and reference them in the main DB via synonym. We have a web...
October 30, 2019 at 10:19 pm
It took 40 people more than 10 days to get us back into business by reloading 3 weeks of files in the correct order, doing the processing on them,...
October 29, 2019 at 7:09 pm
After getting a terrible keyboard layout on my current laptop, I'll never buy another one without first paying attention to EVERY key. I didn't notice this before buying a Lenovo...
October 18, 2019 at 4:30 pm
I have been using the Lenovo ThinkPad W510 for a long time with 32 GB RAM, afterwards I went with the ThinkPad P51 and 64 GB RAM. Didn't take...
October 18, 2019 at 4:03 pm