Viewing 15 posts - 8,521 through 8,535 (of 59,078 total)
Dr. Codd defined a surrogate key as being generated by the database engine and never exposed to the users. What he had in mind would be more like a...
October 16, 2019 at 11:35 pm
When you're doing an "Upsert". That is, you're checking to see if rows already exist or not to know whether you have to do an INSERT or an UPDATE.
October 15, 2019 at 9:05 pm
Thanks Michael, both the reasons you mentioned are valid for SQL Accounts but Service Account and Admin Accounts are strictly with DBAs and Windows Admins.
If you're sharing...
October 15, 2019 at 2:12 pm
What is simplest way to go about gathering business requirements and determining database schemas?
Create a functional flow diagram.
October 14, 2019 at 11:23 pm
We went through that same issue because they went cheap on the RO node storage. They also forgot to do things like change the settings for parallelism, etc.
October 14, 2019 at 1:49 pm
Thanks Michael, both the reasons you mentioned are valid for SQL Accounts but Service Account and Admin Accounts are strictly with DBAs and Windows Admins.
If you're sharing the passwords...
October 13, 2019 at 4:08 pm
Maybe you can simply modify the vendor's purge job by adding OUTPUT/INTO to their deletes to write to your archive tables. It would save you from reinventing the wheel.
Be advised...
October 13, 2019 at 5:03 am
Step #1 is to identify WHY you think you want to partition a table. So WHY do you want to partition whatever table you're working with? What are some of...
October 13, 2019 at 4:47 am
Sounds like a stupid question but what condition are the index and column statistics in?
October 13, 2019 at 4:44 am
Thanks, glad you like it
I think a large part of why I like it is because it's at a really back-to-the-basics level but also has a mention of performance...
October 11, 2019 at 1:47 am
Post removed... it's just not worth it anymore.
October 11, 2019 at 1:16 am
Great introduction to a very useful feature, Steve. Thanks for taking the time to write it up and post it.
October 10, 2019 at 5:35 pm
Why would I take up an ANSI/ISO standard with Microsoft? I don't think you understand how international standards are set. Vendors can take part in the committees, but they...
October 9, 2019 at 11:09 pm
Columns have no order within the row the table by definition. Likewise, rows within a table have no order.
You know, if any of that were true, we wouldn't...
October 9, 2019 at 10:23 pm
>> Actually, the format YYYYMMDD is perfectly acceptable under ISO. I don't know why Celko insists on repeating his false claim over and over about YYYY-MM-DD despite being told...
October 9, 2019 at 10:09 pm
Viewing 15 posts - 8,521 through 8,535 (of 59,078 total)