Viewing 15 posts - 556 through 570 (of 59,042 total)
Sharing what we think we know with others (external validation) is a good way to learn what we didn't know before. Even the "resident SQL Server expert" in an...
May 8, 2024 at 12:16 am
Last but not least... your the one that will need to " 'splain'n'maintain" this... do you understand how it all works?
May 7, 2024 at 11:59 pm
p.s. If you need the Sequence Number to restart for each ticket, then just add a PARTITION BY, as follows...
--===== Solution using "Relational Multiplication"
SELECT tt....
May 7, 2024 at 11:56 pm
I have table TicketNumbers
i TicketNumber UID
2 10 09901a22c7c3acc6786847c775f1d113
6 5 00dad28bef21f916240d6e8c1c1bd67d
12 20 00dad28bef21f916240d6e8c1c1bd67d
I need to produced 35 rows (UID...
May 7, 2024 at 11:40 pm
It's an old article that I hadn't seen before. I like it a lot and just used it instead of me having to do a long winded explanation to someone...
May 6, 2024 at 9:17 pm
The update stats job you have running every night isn't a huge problem. The rebuilding of plans is usually not a problem. Having stats rebuild in the middle of the...
May 4, 2024 at 3:54 pm
The square ones didn't complete
https://joeydantoni.com/2016/11/02/circles-and-squares-what-do-they-mean-in-the-query-store/
Interesting... you might want to let joey know. Some people will be able to see the site. I can't because my system has higher...
May 3, 2024 at 3:30 am
My recommendation would be to buy a tool. This site exists based on the generosity of RedGate. Perhaps their monitoring to tool would save you some time, aggravation (now and...
April 29, 2024 at 10:04 pm
Unblocking stuck 2nd page of this thread...
April 29, 2024 at 2:17 am
I can easily make it a csv file for Bulk Insert and YES there will be data on the Insert statements that have:
VALUES('967120411','864A90D40','CORP','Standard'
Can you show me the frame work...
April 27, 2024 at 4:44 pm
Good article. Thanks for taking the time to write it up and post it.
Just like humans, AI can use all the help it can get but (and just to say...
April 27, 2024 at 3:47 pm
Hi All,
I have couple questions related to Ola Hallengren's maintenance script. If anyone has the answers, please do reply.
1. In which order the rebuild and update stats run. Is...
April 27, 2024 at 1:40 am
Jeff,
How would data being in csv be handled differently?
Thanks.
If they send the CSV data in a file, then the data could be imported using BULK INSERT. This would be...
April 27, 2024 at 1:04 am
thanks The sqltoexec are passed in sql statements like:
INSERT INTO cstDetails (CompPartNbr,PartNbr,PlantCd,CostKey,usgQty,scrQty,totQty,UnitCost,usgCost,scrCost,totCost,StrJCost,StrMCost,SetUpQty,SetUpCost,CurrentOPRSetup) VALUES('967120411','864A90D40','CORP','Standard',0.2697,0.0043152,0.2740152,6.5,1.75305,0.0280488,1.7810988,0,0,0,0,0)
The CrtInsert table has a PK field called ID(int)
In the example how do I loop thru thousands...
April 26, 2024 at 5:07 pm
Viewing 15 posts - 556 through 570 (of 59,042 total)