Viewing 15 posts - 5,551 through 5,565 (of 59,068 total)
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...
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...
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...
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...
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...
February 25, 2021 at 4:38 pm
Sorry... erroneous post removed.
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...
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...
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...
February 25, 2021 at 12:38 pm
Removed... near duplicate post.
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,...
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,...
February 23, 2021 at 11:27 pm
I work on SQL server 2012 I need to search on table partswithcompany that
have 40 million rows .
when make select SearchParts, CompanyId from partswithcompany where CompanyId=1234 and SearchParts='A5ghf7598fdmlcpghjk'
it is...
February 23, 2021 at 4:21 pm
Viewing 15 posts - 5,551 through 5,565 (of 59,068 total)