Viewing 15 posts - 136 through 150 (of 1,838 total)
...To many, many developers RDBMS are a temporary expediency which will soon be soon replaced by something "faster, easier, and better." The opinion of non-Sql devs about Sql (in...
February 2, 2020 at 1:56 pm
In my limited experience as a DBA, some developers aren't happy until they can access anything they want in any production environment
I have gone through this and the question to...
February 1, 2020 at 12:34 pm
Yes, a client program will handle executing a stored procedure that returns multiple result sets differently than running a script that has multiple queries in it. I'm unaware if TOAD...
January 31, 2020 at 9:02 pm
I will raise a large JD and coke to the late, great Lemmy every now and then.
Indeed!!! I still can't believe they got overlooked on the HoF this...
January 31, 2020 at 8:23 pm
You say you are "pulling info out for a report". A report is different than what John describes as "displaying them on a screen". What is actually running the stored...
January 31, 2020 at 7:50 pm
Sounds like a nightmare to me. With that many moving parts, maintaining it all and coordinating which changes need to be synchronized to which other environments and which...
January 31, 2020 at 7:32 pm
what everyone else said - plus in some of the teams we have a database per change request being done.
one of our teams has almost always over 100 active...
January 31, 2020 at 7:24 pm
in Management Studio, hitting the Execute button, (or F5 on keyboard) will run all the statements in the current tab. If you only want to run one statement, you have...
January 30, 2020 at 7:15 pm
...I am convinced that this is a personality type issue. Really good DBAs almost always have this very annoying attitude. Members of the development team--something very different from that...
I...
January 30, 2020 at 4:51 pm
I don't think it's so much of a manual vs. automation issue. Wherever I've been a DBA I've tried to automate as much as possible so that I could eventually...
January 30, 2020 at 4:46 pm
The disks would be considered a resource of the cluster, so a separate non-clustered instance or a separate cluster would need separate disk space. Were they trying to setup an...
January 27, 2020 at 10:12 pm
If you think granting db_owner to someone is excessive, then you probably shouldn't be granting them SecurityAdmin role at the instance level. Microsoft's documentation on that says it should be...
January 24, 2020 at 8:18 pm
In today's meeting of the entire IT staff, we were discussing how interruptions prevent us from getting projects completed.
My boss, using me as an example, stated that I...
January 24, 2020 at 2:44 pm
According to Microsoft's Agent roles documentation, ReaderRole should be enough for them to be able to view history:
If all they need is ability to view history, and not the...
January 23, 2020 at 9:05 pm
You had better not be suggesting a NOLOCK hint on my lawn. That's a sure fire way to get the dogs called.
Oh no sir, Mr. Fritchey! NOLOCK is like...
January 23, 2020 at 5:32 pm
Viewing 15 posts - 136 through 150 (of 1,838 total)