Viewing 15 posts - 1,261 through 1,275 (of 1,398 total)
Or maybe not even locate the page. Just a tally function and table cardinality from dm view.
November 4, 2019 at 6:35 pm
This article mentions the "cte trick" to pagination. I wonder how how fast it would be locating the page and then using a tally table on rownums and then without...
November 4, 2019 at 5:49 pm
Nadella is a big fan of relational databases. As a business it can't be beat. Who wants to swap it out for something else? Lol (head explodes)
https://www.youtube.com/watch?v=0ey91VaQsOY
November 2, 2019 at 12:14 pm
To split the partial weeks use GROUP BY month. To get the weeks to align with your preferred days use dateadd to move the window. To generate dates this code...
October 31, 2019 at 3:37 pm
scdecade interesting stuff! If / when you get a public project going you should drop us a note!
Thanks! Yes I'm going to hopefully come up with a plan. At...
October 30, 2019 at 10:32 pm
So is the class JsonResourceResultsHandler your own class(?) or part of the api? Couldn't google it %^)
It's part of a C# library called JsonAutoService I developed originally to help...
October 30, 2019 at 8:39 pm
Where you attempt to insert with an incorrect column name it results in a compile time error. Sql Server is not able to come up with an execution plan for...
October 30, 2019 at 6:56 pm
Did you try openrowset?
October 30, 2019 at 6:04 pm
I haven't played with net core, do you have any info on the type conversion differences? I can't find anything, weak google fu I guess.
In C# since 5 years...
October 30, 2019 at 4:14 pm
You're connecting Sql Server to Sql Server? Why not use a linked server?
October 30, 2019 at 2:51 pm
With .NET Core there's finally a way for Sql programmers to get out from under the yoke of C#'s type conversions.
October 30, 2019 at 1:22 pm
You have 2 types of GL Accounts: 5 series, and 6 series. For each type you have a matrix which defines the offset positions of data columns which include: location,...
October 29, 2019 at 9:28 pm
I couldn't assume such a thing for possible frequency. We work with documents and we go through 50,000 documents per day. The table size never changes because incoming is...
October 28, 2019 at 1:09 pm
How often do you add documents/nodes to this hierarchy?
According to the OP there are approximately 25k rows in the table. If this represents 5 years of activity, then...
October 27, 2019 at 1:09 pm
At one point I looked into this because we got called into one of those "we want to slap a UI on our database" jobs. Thankfully it didn't go anywhere. ...
October 25, 2019 at 1:12 pm
Viewing 15 posts - 1,261 through 1,275 (of 1,398 total)