Viewing 15 posts - 1 through 15 (of 695 total)
No idea about performance, and don't know where some of those columns are coming from, but it looks like it could be simplified to something like this, which is at...
April 24, 2024 at 5:54 pm
Does your data (and business) have seasonal or annual surges of inserts? Is it relatively stable year-to-year
If not, then you can make somewhat useful projections, though they'd probably be more...
April 23, 2024 at 6:26 pm
Take a look at Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets & Hierarchies on Steroids #2: A Replacement for Nested Sets Calculations from Jeff...
April 23, 2024 at 1:37 pm
Note: You posted in SQL 2022 forum, though neither one of your target servers is 2022.
April 22, 2024 at 9:14 pm
Have you downloaded & installed the Microsoft Office 2010 Filter Packs? I'm not clear if that includes SP2, so you might also want Service Pack 2 for Microsoft...
April 22, 2024 at 3:28 pm
Don't reuse the same temp table for different sets of columns. It makes debugging confusing, and it subverts the way SQL Server manages temp tables.
One of the small optimizations SQL...
April 2, 2024 at 1:14 pm
March 27, 2024 at 1:09 pm
You mention "app team" a few times. Does this mean only developers, or does app team also include product owners? The question of data retention is a business concern in...
March 19, 2024 at 2:31 pm
"I tried to create a stored procedure on a database that would execute as owner (blindly believing it to be 'sa'). The create failed because the owner didn't...
March 15, 2024 at 7:01 pm
For some reason, you didn't ask -- perhaps deliberately -- about the simplest and probably the best option, which is just:
SELECT field1,field2
FROM table1
Because there is no where...
March 14, 2024 at 9:38 pm
Duplicate created when original appeared to time out.
Deleted.
March 14, 2024 at 7:35 pm
Are both servers running the same SQL Server version?
Are both databases using the same compatibility level?
Are both databases using the same transaction isolation level?
Are both databases/tables using the same collation?
Do...
March 14, 2024 at 7:32 pm
And if you truly don't care about the date entered when Type is not "Apple", you can simplify Emperor100's example to
ALTER TABLE [Testing]
ADD CONSTRAINT CHK_Dates CHECK
(
...
March 14, 2024 at 1:13 pm
Does your table already have a clustered index on the column you will use for partitioning? If not, it will need to. That presents the likelihood of downtime & locking...
March 7, 2024 at 5:28 pm
March 7, 2024 at 2:13 pm
Viewing 15 posts - 1 through 15 (of 695 total)