Viewing 15 posts - 241 through 255 (of 1,999 total)
Updating a view isn't updating a join. In fact, I'm not sure how you update a join because you can't. Updating a view is using the fact that a...
February 24, 2020 at 1:51 pm
no idea
the wording on the Microsoft website it ambiguous, I haven't checked your version number, but who doesn't win for a service pack?
I'm guessing that your company is using web...
February 24, 2020 at 11:56 am
question, why update the view? - in the last example you only touch one table - keep it simple don't use unnecessary joins... even better - forget the view and...
February 24, 2020 at 11:39 am
web edition doesn't support it
QL Server 2016 (13.x) SP1 (or later), any edition. For SQL Server 2014 (12.x) and SQL Server 2016 (13.x) RTM (pre-SP1) you need Enterprise, Developer, or...
February 24, 2020 at 11:34 am
I just re-read this ….. "only use numerical types for maths"??????? how about a foreign key to person.status - if there are only 3 statuses then tinyint…. massive...
February 24, 2020 at 10:06 am
Staging tables - always...
but i'm sure Joe celko could help you out on the ISO standards for field lengths of things like names(seriously who has a varchar(80) name)
Joe...
February 24, 2020 at 9:47 am
yes he can be slightly "pernickety"... 🙂 but he does have a good knowledge of standards (that I ignore) 🙂
February 24, 2020 at 9:42 am
I would compare the contents to other similar data that you might have elsewhere, for consistency. For example if you are using varchar(80) for names of people or places,...
February 24, 2020 at 9:08 am
I'm going to be very kind, a lot of people would have shouted.
I/O is input/output (sometimes refered to as Inbound / Outbound)
throughput means how much traffic you get....
February 24, 2020 at 9:00 am
One thing I've noticed since Google went on its personalization kick a few years back is that my results often don't look like your results.
I was wondering why...
February 24, 2020 at 8:50 am
I fell foul of this recently and jeff's trick cured my issue.. worth a try and although it's not required by ansi 92 syntax it is a good practice to...
February 21, 2020 at 4:36 pm
Great ideas and much appreciated...having the articles in place prevents the dropping of tables. Not knowing which table is going to get dropped is the issue there...then when a...
February 21, 2020 at 4:20 pm
OK - what if there are 200 tables(I made that number up) that need replicating? wow, sql agent is going to get busy and run out of threads quite soon...
February 21, 2020 at 4:17 pm
the only piece of advice I can give you is don't use varchar for a date field, don't use float for anything and think about the maximum size of any...
February 21, 2020 at 3:54 pm
run a quick dbcc opentran against that database - then figure out what that spid is doing
it might not be as bad as john says. it could be a tiny...
February 21, 2020 at 3:49 pm
Viewing 15 posts - 241 through 255 (of 1,999 total)