Forum Replies Created
Viewing 15 posts - 2,146 through 2,160 (of 59,066 total)
-
Reply To: Create a Job Schedule that runs on the 1st of month only if it falls on a Sunday
I don't believe you need a date table for this. It would just be another thing to worry about. I'd use a method similar to what Ant-Green used.
-
Reply To: Looking for SQL Architect
It'll be interesting how this works out. I know people that claim to have been "working with" SQL Server and they still don't have a good clue, never mind "working...
-
Reply To: Indexes: When Column Selectivity Is Not Always A Requirement
@ Mike Byrd... thank you for the great article. I obviously missed it when it first came out and I'm glad they republish such things to give such articles the...
-
Reply To: Step functions trigger rule
I'd provide an answer but I don't even know how to spell AWS. Hopefully, someone out the will be able to respond.
-
Reply To: Step functions trigger rule
Duplicate posts from only 2 days ago are probably not spam. Lot's of people post to multiple sites. This also doesn't seem (yet) to have the usual qualities of the...
-
Reply To: Are the posted questions getting worse?
Eirikur Eiriksson wrote:Happy new year everyone! 😎 May the source be with you 😉
Same to you, ol' friend. Glad I got to know you and others from this site. Missed seeing...
-
Reply To: Are the posted questions getting worse?
Thanks for the links, Steve. I wouldn't even know where to begin any more.
-
Reply To: No Time for Testing
In honor of this article being republished...
-
Reply To: Are the posted questions getting worse?
Steve Jones - SSC Editor wrote:I think WordPress is great for me. I've used it for my blog and for T-SQL Tuesday. A lot of the admin/back end stuff is pretty simple for me,...
-
Reply To: Is there another way to solve this "group in 5 day spans" problem?
Posting again because the first post of pages > 1 never shows up until a second post on the page is made.
Thanks again, everyone. This has been really interesting and...
-
Reply To: Is there another way to solve this "group in 5 day spans" problem?
@Frederico,
Ok. I'm not sure which part of my brain was missing when it came to that index but that did the trick. It won't touch the QU when it comes...
-
Reply To: Is there another way to solve this "group in 5 day spans" problem?
frederico_fonseca wrote:thanks Jeff.
regarding the "performance and cartesian joins" - splitting the CTE to insert the BASE dates onto a temp table and then joining that temp table onto the main...
-
Reply To: Split One Column into Multiple that uses / as the delimiter
Luv SQL wrote:I've been researching this for over 3 hours and none of the syntax I've found works. I have a column with data that's been merged from various other tables...
Viewing 15 posts - 2,146 through 2,160 (of 59,066 total)