Viewing 15 posts - 6,196 through 6,210 (of 59,070 total)
Ah... I just thought of something else it could be. Have the Developers check the connection strings for the apps. If it doesn't explicitly turn off MARS (multiple active result...
October 17, 2020 at 1:49 am
One simple way is to use xpDirtree to read the file names in the source directory and then use BULK INSERT or OPENROWSET with the ACE drivers (if you're trying...
October 17, 2020 at 1:08 am
You really haven't given us anything to go on. Just listing a bunch of code that returns a NULL result set isn't much of a clue.
Have you tried printing the...
October 17, 2020 at 12:16 am
I am looking to export data from SQL 2019 to sql 2017. What if the tables have primary key and foreign key relationship how would be the export is...
October 17, 2020 at 12:10 am
With the idea of teaching a person to fish, a temp table is still a table and you're trying to create one in each of the 3 procs. That's the...
October 16, 2020 at 11:47 pm
If the use of schemas gives one the heebee-jeebees, then a control table like yours or using prefixes on the table names would work just as well. I like your...
October 16, 2020 at 4:30 am
Just went through all that code and lordy.
8<
Many thanks for taking the time to wade through that lot Jeff, and I hope your blood pressure didn't rise too...
October 15, 2020 at 8:35 pm
You inspired me. I'm going to write an article based on this, as some of these things are interesting from a DR standpoint.
The very first recommendation in such an...
October 15, 2020 at 6:42 pm
We have a lot of such tables. I use the schema of a table to help and got everyone onboard with it.
If the table is supposed to have a really...
October 15, 2020 at 6:23 pm
i need to delete specific tables "_backup " which took before changes to the table, instead of deleting the table one by one , any script is there to...
October 15, 2020 at 5:37 pm
From the article:
Is this AI bot intelligent?
It's a funny thing... especially the Turing Test. My answer is that if it mimics humans, it's probably not "intelligent". 😀
October 15, 2020 at 2:56 pm
Again, as I stated, it took only 1 more byte to store YYYY vs YY. Dates were stored as numeric and not char, also to save space. YYMMDD took...
October 15, 2020 at 2:15 pm
If you're rebuilding the indexes, then don't update the statistics. An index rebuild updates the statistics with a full scan. You don't need to run that after a rebuild.
Just...
October 15, 2020 at 12:56 pm
It's an audit table, Scott. Most people are going to be doing a lot of reads from it. You're talking about doubling the size but a lot of people also...
October 15, 2020 at 7:12 am
I would run the stats rebuilds long before I ran the current industry standard for supposed "Best Practices" (Reorg between 5 and 30% logical fragmentation, REBUILD for more than 30%)......
October 14, 2020 at 9:47 pm
Viewing 15 posts - 6,196 through 6,210 (of 59,070 total)