Viewing 15 posts - 5,686 through 5,700 (of 59,068 total)
Good article and thank you for taking the time to write and publish it.
As a bit of a sidebar, though, I just go to "Source Control" and grab a copy...
February 3, 2021 at 12:50 am
As Yogi Berra is quoted as saying, "When you come to a fork in the road, take it". There is absolutely no reason why you can't build "the art" into...
February 3, 2021 at 12:17 am
And it's more than data analysts. So this is worthy of a larger discussion of what is and what is not of interest to this group. Let's scope it.
Heh......
February 2, 2021 at 7:24 pm
@stevenb,
I like it... a LOT! Nicely done!
February 2, 2021 at 2:32 am
Heh... you need better DBAs. To be honest, though, I feel your pain. The DBAs I've had to work with in the past made sucking sounds in the areas you...
February 2, 2021 at 1:59 am
Correct me if I'm wrong, please... [Paleo-Server\SQLServerZaloha] is the instance name, correct? That's not a login.
If, like most people do, the owner of the databases is the disabled "sa" user,...
February 1, 2021 at 11:26 pm
IIRC, PagedMemorySize is how much room there is in the "page file". If you overrun memory, applications will start to swap stuff in and out of the page file as...
February 1, 2021 at 11:21 pm
Glenn Barry has a cool set of diagnostic scripts by SQL Server Edition at the following URL...
https://www.sqlskills.com/blogs/glenn/category/dmv-queries/
Since you posted on a 2017 forum, you should find his 2017 version...
February 1, 2021 at 11:10 pm
SQL does serve the business. Not always so for IT, especially the one's that are saying "NO" to Statisticians and others without providing help. I get they don't want a...
February 1, 2021 at 10:20 pm
In-person events require a venue, which must be reserved months ahead of time. What is currently "legal" now could be deemed by the local government as "ill-legal" at the drop...
February 1, 2021 at 7:44 pm
Exactly , thats what you are looking at.
How's that? I see two columns with you trying to create a clustered index on one table... I don't see two tables...
February 1, 2021 at 7:14 pm
If you're going to go through all that, why are you upgrading to a version of SQL Server that's coming up on being half a decade old already? Why not...
February 1, 2021 at 5:31 am
My personal opinion is that this has all the ear-markings of a classic invoice/invoice detail or work-order/work-order detail problem and should be handled as two individual tables rather than 1......
February 1, 2021 at 5:10 am
The "forum etiquette" which Joe refers to can be found at the first link in my signature line below. It will usually help you get a good, coded answer much...
January 31, 2021 at 8:48 pm
Dear Joe... the Op had nothing to do with the creation of these tables. It's a homework problem. Please track down the instructor and vet on them. 😉
January 31, 2021 at 7:26 pm
Viewing 15 posts - 5,686 through 5,700 (of 59,068 total)