I've never attempted any certifications and I've never missed out on a job because of it.  I don't see the value, but as a learning tool it is probably...

Nice question, Alessandro.  Proof, yet again, that SQL <> SQL and that the basic training out there isn't working 😉

Dear Steve Jones...

I forget how long it's been since this site was moved to WordPress but it's been a long time.  Those of us long-timers that are left (not many...

Shop size doesn't matter to me.  What matters is the attitudes of management on both the Dev and Database sides of the house and the attitudes of the folks on...

Hi All,

I have couple questions related to Ola Hallengren's maintenance script. If anyone has the answers, please do reply.

1. In which order the rebuild and update stats...

I think that the people who made the decision to move to to the cloud should have the sole responsibility of monitoring the costs to prevent all the "I told...

Ok... I had a look.  First, I've got to say I don't know why supposed scientists are willing to lose data by rounding it. Whatever.

Looking back at this thread, Jonathan...

@ibbo14,

I've grown to trust more in zip files being benign and like them a whole lot better than having to go to some other site to get them.  Still, there...

To be honest, certifications were never relevant to me.  I was considering becoming certified 2 decades ago but then I ran into two people that were working for the same...

Sharing what we think we know with others (external validation) is a good way to learn what we didn't know before. Even the "resident SQL Server expert" in an...

Last but not least... your the one that will need to " 'splain'n'maintain" this... do you understand how it all works?

p.s.  If you need the Sequence Number to restart for each ticket, then just add a PARTITION BY, as follows...

--===== Solution using "Relational Multiplication"
 SELECT  tt....

I have table TicketNumbers

i     TicketNumber  UID

2    10                        09901a22c7c3acc6786847c775f1d113

6    5                          00dad28bef21f916240d6e8c1c1bd67d

12  20                        00dad28bef21f916240d6e8c1c1bd67d

I need to produced 35 rows (UID...

So, the next step is... post the code for the view.

It's an old article that I hadn't seen before.  I like it a lot and just used it instead of me having to do a long winded explanation to someone...

• This reply was modified 1 years, 10 months ago by Jeff Moden.