Viewing 15 posts - 2,311 through 2,325 (of 22,202 total)
This is why we should comment our source code and version control checkins - so those who follow us can better understand why we did things...
October 28, 2019 at 3:51 pm
This is why we should comment our source code and version control checkins - so those who follow us can better understand why we did things the way we...
October 28, 2019 at 1:50 pm
erm…. I picked up on one word - "weekend"
so is there any possibility that it's a rebuild index with "Sort in tempdb" option enabled... we all know which jobs...
October 28, 2019 at 1:45 pm
Sounds like you're probably OK. Update the statistics after a data load like this.
October 28, 2019 at 11:29 am
This is flat out a coding and design issue. The code could be simply bad. Or, it could be doing things that aren't using the appropriate data structures, indexes, etc.....
October 28, 2019 at 11:29 am
Sub queries come in several stripes. Correlated sub-queries (which I shy away from)
SELECT
(SELECT b.cola FROM tableb AS b
WHERE b.ID = a.id)
FROM tablea AS a
WHERE a.otherid = 42;
Or, as a table...
October 9, 2019 at 11:43 am
Create specific logins as owners for the databases. Just as in the other question you asked, least privilege principle should always apply. Setting 'sa' as owner potentially opens things up...
October 9, 2019 at 11:36 am
Agreed with @NorthernSoul.
If you mean how do you set up administrator privileges, I'd suggest that each instance has a different login than the underlying OS. Least privilege principle should...
October 9, 2019 at 11:33 am
Isn’t it a kinda shame to have such queries exposed on a specialised site of SQL Server professionals?
Could we form a group of volunteers who could fix this...
October 4, 2019 at 8:17 am
I wonder if more of us ought to be using UTC or at least datetimeoffset for applications. There are more and more that are crossing time zones and it...
October 2, 2019 at 3:39 pm
What is the chance of getting an SQL Saturday in Birmingham, AL? There are a lot of us over here
Just gotta find a volunteer to do the organizing and...
October 1, 2019 at 8:20 pm
Whoa! That sure reads like a bit of a mess. I hope they can straighten it out. I can't say I'm a fan of SE, but I'm not actively opposed...
October 1, 2019 at 3:47 pm
What the heck is a FULLZ? Are dead FULLZ better than live FULLZ? Inquiring minds.
September 27, 2019 at 1:47 pm
Even if we do a virtual SQLSaturday, I'm positive the local events would continue. While a lot of people want to have big events with a host of international speakers,...
September 27, 2019 at 1:44 pm
PASS hosts a whole bunch of different virtual events year round, 24 Hours of PASS and the PASS Marathons. Plus there are the virtual chapters that meet...
September 27, 2019 at 1:40 pm
Viewing 15 posts - 2,311 through 2,325 (of 22,202 total)