Viewing 15 posts - 5,566 through 5,580 (of 59,072 total)
I have to agree with Brian... what is the problem with using something that guarantees you won't have a problem with concurrency such as an IDENTITY column or a SEQUENCE? ...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 25, 2021 at 11:50 pm
Heh... and I strongly recommend that you don't give up the Adjacency List model because of how incredibly easy it is to maintain. Use it to drive the creation of...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 25, 2021 at 8:35 pm
If tempdb is growing every time you run this package - that indicates another process somewhere that is shrinking the files. You should not be shrinking the files...reset the...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 25, 2021 at 8:15 pm
I've been in the world of data almost as long, Joe. Everything you say is true but your posts aren't changing any of that. You need to understand that the...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 25, 2021 at 7:49 pm
Please see the folllowing 2 articles... there's no need for such things to be slow.
If you keep the "Adjacency List" going, you'll be able to easily maintain things...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 25, 2021 at 5:43 pm
The picture you posted is not a table by definition. It's got duplicate rows! You have no key or constraints. The strings you posted are not how we represent...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 25, 2021 at 4:38 pm
Sorry... erroneous post removed.
--Jeff Moden
Change is inevitable... Change for the better is not.
February 25, 2021 at 4:17 pm
Sorry... erroneous post removed.
--Jeff Moden
Change is inevitable... Change for the better is not.
February 25, 2021 at 4:17 pm
Sorry... erroneous post removed.
--Jeff Moden
Change is inevitable... Change for the better is not.
February 25, 2021 at 4:17 pm
Just be careful what you use the Developers Edition for. If the databases on your SQL Express system are production databases in any way, shape, or form, it's a flagrant...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 25, 2021 at 4:09 pm
From the Article:
I've seen friends at Microsoft change departments, products, etc. every year or two.
Actually, that explains a lot. While it may keep people from getting "bored" or "stagnant", it...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 25, 2021 at 4:02 pm
I do not consider "2359 to 2359" a valid case, as that might imply it may also span multiple days
Ordinarily, I'd agree but to consider the span of multiple...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 25, 2021 at 12:38 pm
Removed... near duplicate post.
--Jeff Moden
Change is inevitable... Change for the better is not.
February 25, 2021 at 12:35 pm
Just to continue, if you limit things to the original problem, solving the "spans midnight" problem is almost trivial. You just have to know the "gazintas". 😀 In this case,...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 25, 2021 at 2:12 am
Except - you have to execute SQLCMD from *something*. That would be either a DOS command window or Powershell - so if you are going to be using Powershell,...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 23, 2021 at 11:27 pm
Viewing 15 posts - 5,566 through 5,580 (of 59,072 total)