Viewing 15 posts - 5,581 through 5,595 (of 59,072 total)
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...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 23, 2021 at 4:21 pm
Yes. Something is temporarily blocking all those processes and you need to find out what that is.
--Jeff Moden
Change is inevitable... Change for the better is not.
February 23, 2021 at 4:17 pm
The following will work whether the source data is an INT or VARCHAR(). Of course, it has the same caveat that Phil mentioned.
SELECT end_time/100*60 + end_time%100...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 22, 2021 at 11:14 pm
My recommendation would be to contact the people that wrote the "Get-DbaProductKey" PoSh snippet and ask them.
--Jeff Moden
Change is inevitable... Change for the better is not.
February 22, 2021 at 10:49 pm
I work on sql server 2012 . I face issue I can't generate unique Id from merge or concave both columns
Search Parts and Company ID and generated Id must...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 22, 2021 at 10:45 pm
DATEDIFF(minute, CONVERT(varchar,[begin_time],8) , CONVERT(varchar,[end_time],8)) as [duration]
this was not worked for me could you please help above 3 formats how to get duration
What are the original datatypes...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 22, 2021 at 10:00 pm
Just checked with the developer and rows are created all at once with no updates.
Just checked with the developer and rows are created all at once with no...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 22, 2021 at 4:46 pm
This seems like homework. Can you post what you've tried, please?
--Jeff Moden
Change is inevitable... Change for the better is not.
February 22, 2021 at 2:57 pm
Perhaps instead of my proposed solution I should ask the good folk here how do you handle refactoring a table?
My answer is, of course, "It Depends" on what the...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 22, 2021 at 2:54 pm
Just a bit of advice... I know your intentions are honorable but there's no way I'd ever download a copy of a company database to a personal machine, if that's...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 22, 2021 at 1:40 pm
I have an actual TALLY table in my database for Numbers ... is that bad? should I be using a Function?
The use of a physical Tally Table...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 21, 2021 at 7:50 pm
Sending the same message to the WebMaster does the trick, Kristen. I've made the same mistake in the past and, especially because you're able to identify the post, they can...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 21, 2021 at 2:11 pm
If you reread what I wrote, you would see that I don't agree with creating a view for future proofing.
I stated that using a view for refactoring is acceptable...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 21, 2021 at 4:42 am
There are a whole lot of things that SHOULDN'T be done to a table. The fact the matter is, they DO happen in real life, Jeffrey, and you have to...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 21, 2021 at 2:29 am
I would like to compare two files, that should give me. a Match and No Match output in separite tables. Can somebody send ma screenshot/link of such a ssis...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 21, 2021 at 2:14 am
Viewing 15 posts - 5,581 through 5,595 (of 59,072 total)