Viewing 15 posts - 61 through 75 (of 123 total)
Much better would have been to create an SSMS server group(s) with all the relevant servers in it(them), then fire off the script for a given server group(s) whenever...
"Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
— Samuel Johnson
I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?
September 17, 2020 at 9:22 am
+1 for an interim table. I use a similar concept for sending emails, it was not feasible to do in the application due to reasons I won't go into.
If it's...
"Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
— Samuel Johnson
I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?
September 7, 2020 at 1:07 pm
I love the grainy pictures of problems, I send my solutions back in pictures with even lower resolution! Heh maybe I'm just old and cranky but I get a...
"Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
— Samuel Johnson
I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?
September 1, 2020 at 8:05 pm
They say that helping others can also improve one's own learning. Partly for that reason, partly altruistic and partly as another avenue to pick up useful tips, I joined a...
"Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
— Samuel Johnson
I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?
September 1, 2020 at 7:39 pm
Not sure if this has been done, but I thought I'd have a little fun on a rare day off:
The MSSQL DBA's Prayer:
Our Master, which art in DataCenter
Two-part be thy...
"Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
— Samuel Johnson
I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?
August 21, 2020 at 12:43 pm
Imagine the lady in Poltergeist: ALL ARE WELCOME!
Come on in. The water is fine. This is just the local water cooler (bubbler/fountain/whatever your local vernacular is for a central...
"Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
— Samuel Johnson
I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?
August 21, 2020 at 12:10 pm
Personally, I'm a bit sad (and also kind of excited I guess) that the days of SSRS are numbered for me - got to start from scratch and learn PowerBI...
"Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
— Samuel Johnson
I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?
August 21, 2020 at 10:42 am
As a (mostly) lurker on this esteemed forum for around five years, I've only recently come across this thread.
I've not managed to consume all 4000+ pages to find...
"Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
— Samuel Johnson
I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?
August 21, 2020 at 10:22 am
Thank you Jeff & Jeffrey for your helpful replies. I have sorted it now
Sadly my skills to SQL are not great so I find it easier to do these...
"Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
— Samuel Johnson
I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?
August 21, 2020 at 9:41 am
As a (mostly) lurker on this esteemed forum for around five years, I've only recently come across this thread.
I've not managed to consume all 4000+ pages to find the answer,...
"Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
— Samuel Johnson
I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?
August 21, 2020 at 9:33 am
@JeffModen - although your code works in SQL Server, it will not work in an expression in an SSRS report.
Missed the fact that this was an SSRS forum. ...
"Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
— Samuel Johnson
I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?
August 21, 2020 at 9:25 am
Thanks, I also heard complex logic should handle in business layer not on database layer. Is that just some people's preference?
In my opinion that's a big "it depends"! 🙂
Some...
"Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
— Samuel Johnson
I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?
August 20, 2020 at 4:07 pm
Thanks much, it makes sense to me.
The project was a big one and a complicated one. And an entire project team with several good developers and BA and Project...
"Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
— Samuel Johnson
I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?
August 17, 2020 at 4:00 pm
At the risk of sounding like a crazy stalker, I'm glad I started "following" you on this forum Jeff, I can usually guarantee that a thread you pop up on...
"Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
— Samuel Johnson
I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?
August 17, 2020 at 11:17 am
Thanks. This overnight update process is a part of a big project we had and hired several contract developers and project team. The web service/applications does very complicated process...
"Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
— Samuel Johnson
I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?
August 15, 2020 at 8:59 am
Viewing 15 posts - 61 through 75 (of 123 total)