Viewing 15 posts - 106 through 120 (of 2,897 total)
".... 2. Table aliases - you should get in the habit of aliasing your table references and using the alias on all column references. It is almost impossible for anyone...
May 6, 2022 at 5:19 pm
Going forward, get regular differential backups so you have fewer transaction logs to restore.
Some 3rd party backup tools would let you select all the t-logs in the restore GUI. Not...
May 3, 2022 at 2:43 pm
If you're feeling generous, document as much as you can in a central area, make sure backups run regularly without problems, and hand over as much information as possible to...
May 2, 2022 at 1:03 pm
"...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
Viewing 15 posts - 106 through 120 (of 2,897 total)