Viewing 15 posts - 961 through 975 (of 59,066 total)
Compatibility mode?
Sidebar: stop using DB..Table - specify the schema instead of expecting SQL Server to find the correct schema for the table. That is dependent on the default schema...
October 28, 2023 at 3:08 am
Just a post to expose page 2 because of the forum fault in that area.
October 27, 2023 at 9:10 pm
While I agree with Jeff in the sense that "if the system is designed in one way, why change it to work a different way", I think I would...
October 27, 2023 at 9:09 pm
To add another 2 cents, I totally agree with David Wiseman. Storing the full path instead of just a file name can be a horrible idea for the very reasons...
October 27, 2023 at 8:48 pm
The only time that I've used ONLINE Index Rebuild was during testing on some test tables. I've never tested for a "cancel" of an ONLINE Rebuild like you folks accidentally...
October 27, 2023 at 2:31 am
Imagine a view is created - that references a computed column which only exists to give the column a different name - and aliases the computed column...
October 26, 2023 at 9:40 pm
I'll likely be alone on my take on this but "It Depends" on a whole lot of things.
When I first started at a company that I do work for, they...
October 26, 2023 at 9:12 pm
Heh... not bad for something that used to be natively available on the f4 key until they came out with SQL Server 2005. 🙁 What a bummer that was (and...
October 26, 2023 at 7:43 pm
Have you considered just making a large test table and testing it?
October 26, 2023 at 5:48 pm
As a bit of a sidebar, I've not found any performance improvement that I can relate to the "new" CE but have a whole bunch of slowdowns that I can...
October 26, 2023 at 5:45 pm
You can also add a computed column to the table - but I really don't see the need or requirement to create a column with multiple names. It is...
October 26, 2023 at 12:38 am
Your singular table name indicate you have only one Rate.
Not if you understand that each row is unique and can have only one rate. Either convention is just...
October 25, 2023 at 9:25 pm
Hi
I have dataset like this
drop table if exists #dataset create table #dataset(CIF VARCHAR(255), PARENT_CIF VARCHAR(255), UP_CIF VARCHAR(255))
INSERT INTO #dataset SELECT 45218547, 54044082, 54044082 union all SELECT 54044082, 64349595, 64349595...
October 25, 2023 at 9:18 pm
I thought Elvis was dead.
😀
October 24, 2023 at 11:03 pm
It would appear that the author of the article has left the building. 🙁
October 24, 2023 at 6:25 pm
Viewing 15 posts - 961 through 975 (of 59,066 total)