Viewing 15 posts - 151 through 165 (of 2,897 total)
"...I work on sql server 2019 ..."
Post in the SQL 2019 area next time. It's more visible, and others who are familiar with 2019 will see it.
March 4, 2022 at 6:04 pm
( Internet Translate ) Hello
I have a trace that saves in a table and triggered from sql profiler of my local instance but queries a production server (it traces all...
March 3, 2022 at 4:03 pm
It might be a good idea to take differential backups until you resolve the problem with full backups.
You could even add it as a job step, to run only if...
March 1, 2022 at 5:40 pm
I had to do something similar, importing a .CSV , but at least the date field was in it's own column
Month and day did not have a leading 0, so...
March 1, 2022 at 5:09 pm
Hey SQLAddict01
What did you end up doing? I have similar issue. I have last 3 months worth of data that is being used most of the time. Remaining 2...
February 24, 2022 at 9:15 pm
Thank you for your reply. I'm sorry for being such a beginner. Can you give me an example of how I would use SET to acomplish what I am...
February 17, 2022 at 2:41 pm
........... And understand the impact on your indexes from shrinking data files.
February 10, 2022 at 4:50 pm
Someone needs a "dope-slap" !!
"... someone expanded a string in a source component, didn't tell anyone, ..."
February 7, 2022 at 10:07 pm
Setting up transaction log backup is just a few different clicks. Jeffrey Williams' advice is good.
You can use a Maintenance Plan wizard and it's quite easy.
Make sure the database option...
February 7, 2022 at 3:38 pm
Edit: Duplicate post
February 7, 2022 at 3:37 pm
Thanks, I used SSIS to write file locally, then DOS COPY in a .BAT file to move it to the remote server.
Just curious - why not use the...
February 4, 2022 at 7:32 pm
Extended Events is our friend.
Take a look at the object_created event. You could filter by object_type and only see when indexes get created.
That will only work after...
February 4, 2022 at 4:25 pm
Thanks, I used SSIS to write file locally, then DOS COPY in a .BAT file to move it to the remote server.
February 3, 2022 at 9:56 pm
I was able to do it in SSIS by creating a separate "Preparation Task" and "Data Flow" task for each Excel spreadsheet tab.
January 31, 2022 at 6:03 pm
One more question ...
From a design perspective... is it better to have one script do it all or should there be different SSIS tasks for each?
My personal preference is...
January 25, 2022 at 2:07 pm
Viewing 15 posts - 151 through 165 (of 2,897 total)