Viewing 15 posts - 106 through 120 (of 2,893 total)
"...How to copy Fixed Path excel file to another path with same name combined with current date and fill data on it ?...."
I rename Excel files name to include the...
May 2, 2022 at 12:56 pm
Is your database in FULL , BULK_LOGGED or SIMPLE recovery mode?
Right click "Database" -> "Properties" -> "Options" look at "Recovery Model"
If FULL or BULK LOGGED, how frequent are your Transaction...
May 2, 2022 at 12:38 pm
You can configure a trace to run 24/7 ,which I found useful in the past for diagnosis.
Extended Events are the new & Improved option, but I have not had to...
April 29, 2022 at 6:57 pm
The first change I would try is to make ALL the fields in your format file SQLCHAR. Forget about SQLINT and SQLDATE.
Agreed. I often load into a temporary table...
April 29, 2022 at 3:18 pm
Try the REPLACE function, and replace with '' (no spaces)
https://docs.microsoft.com/en-us/sql/t-sql/functions/replace-transact-sql?view=sql-server-ver15
April 29, 2022 at 3:09 pm
Both will work, but they are different.
https://www.sqlshack.com/difference-between-sql-truncate-and-sql-delete-statements-in-sql-server/
You've been here 10 years. Easy to search for the answer, if not already known for some reason.
April 27, 2022 at 6:07 pm
This looks like "spam". There have been multiple identical posts from various accounts recently.
I suspect they start with a "valid" post, then will go into spam mode.
April 26, 2022 at 3:40 pm
What you need to do is determine the average growth rate - based on the activity in that system. Project that over the next 6 to 12 months...
April 25, 2022 at 2:47 pm
Are you doing frequent trans log backups ?
April 25, 2022 at 2:42 pm
You can make a loop to delete X number of records, and include a transaction log back up in each loop.
You will need disk space for the backups, but your...
April 25, 2022 at 2:30 pm
Isn't Case # 1 answer = 16 ?
15 apples @ $3 = $45
Plus 1 orange @ $5 = $50
16 fruit total
(Expensive cherries !)
April 22, 2022 at 6:31 pm
Can you later open the SSIS via V.S. to edit and set that option ?
April 22, 2022 at 1:06 pm
You can go into SQL Server Agent, open the job and see if the backup code is there, or perhaps points to a maintenance plan that you can look at,...
April 18, 2022 at 7:21 pm
I do look at that folder regularly as I have to delete older files or it fills up the drives.
Automate that to delete files older than 'X' days.
April 18, 2022 at 5:10 pm
Viewing 15 posts - 106 through 120 (of 2,893 total)