Viewing 15 posts - 91 through 105 (of 10,144 total)
If you can batch up those inserts so that they are taking place under your control every 24 hours rather than at random every few minutes or so, your whole...
May 24, 2019 at 3:04 pm
What version of SQL Server are you using?
May 24, 2019 at 1:17 pm
Hi Frederico, Thanks for the prompt reply - that's unfortunate as it would create a huge overhead for this table - does the same apply if the indexes exist...
May 24, 2019 at 8:01 am
And of course this is what you, Gail and Grant have been saying for years - except the fine detail of changing queries and indexing to work better with partitioning,...
May 20, 2019 at 1:59 pm
Soooo.... it wasn't actually the partitioning but column store that made the improvement?
I wasn't around when the table was converted to partitioned but the folks who were, claimed that...
May 20, 2019 at 12:47 pm
We found modest performance gains with one of our tables following partitioning. This was before my time so it's anecdotal. Where we found significant gains was with batch loading tons...
May 20, 2019 at 10:16 am
This is a "Works As Designed" feature that makes me wonder just what the logic was for that design. 40 years of experience shows a pattern to this; there...
April 18, 2019 at 1:18 pm
April 15, 2019 at 3:59 pm
I'm heartbroken here. The Corgi Completion Contest "discussion" hyperlink leads to the article on data compression (https://www.sqlservercentral.com/editorials/data-compression-double-take). <sniff><sniff>WAAAAAGGHHHH! @=(
Maybe the contest is to actually find...
April 15, 2019 at 3:36 pm
It depends on what you want to do with the copy, how "fresh" you need it, and what downtime is acceptable to you for refresh. Can you provide a few...
April 11, 2019 at 1:27 pm
It doesn't but there are a few TSQL equivalents around. I've written a Levenshtein workalike which is quite fast, but I'm having some trouble finding it!
Edit - found it:
April 11, 2019 at 12:14 pm
Unless you're planning to move to the most recent release of Sql Server, you cannot. A good alternative is to rework the UDF as an inline table-valued function. Jeff...
April 11, 2019 at 7:57 am
Great name for a beer!
Well, with the new leaderboard (https://www.sqlservercentral.com/contributors), we have our first millionaire.
Yay. Um, so what are those points redeemable...
April 10, 2019 at 2:10 pm
I've had a couple of chats with Steve about our move to a "modern" interface for SQL Server Central. It's insane how badly software is coded these days. We...
April 3, 2019 at 10:00 am
Try a slightly simplified and perhaps more common version of your "catch-all" query:
SELECT *
FROM SA.VAP_RESOURCE r
WHERE r.ETL_ACTIVE_FLG = 1
AND r.BUDGET_FLAG = 0
AND (@projectId IS NULL OR r.PROJECT_ID = @projectId)
AND...
April 2, 2019 at 8:33 am
Viewing 15 posts - 91 through 105 (of 10,144 total)