Viewing 15 posts - 151 through 165 (of 290 total)
I was reading online that xp_cmdshell can expose me to security issues so is there a safe way to do what I am trying to do? I found this on...
March 11, 2023 at 4:25 am
What is the nature of the process that will be using the file? There's a lot of options to get a table out of SQL Server into a file...
March 11, 2023 at 3:38 am
thank you everyone
I got this far but there is no csv file being produced. Does anyone know why? I got the script from online.
-- To allow advanced...
March 11, 2023 at 3:13 am
the db is 11080.00 MB and the log is 17032.00 MB. Why do I need the log file? My DB is backed up so if something happens to the tables...
February 28, 2023 at 5:39 am
thanks everyone. i will review and get back to you if I have any questions
January 31, 2023 at 5:09 am
Can I change it? I would like it to grow as the data gets larger...not start off so big and then the data size doesn't justify the db size.
January 30, 2023 at 2:54 am
In Access, I would see that the DB size would keep increasing even after I deleted data. I had to shrink the database to get back to its true size. ...
May 1, 2022 at 9:29 pm
Here is an article you should review: https://www.sqlservercentral.com/articles/managing-transaction-logs (also linked to in my signature).
If your database is in full recovery model - you *must* perform frequent log...
May 1, 2022 at 9:25 pm
Thank you both for your replies. I will review. Coding isn't my strength so it will take a bit of time to process the suggestions. Thank you again!!
April 22, 2022 at 4:55 am
Even with the columnstore thing, the original issue on this thread has never been solved. What made the old query suddenly perform so poorly when the database was moved...
April 12, 2022 at 5:51 am
instead of having all your tables as heap and with additional non clustered indexes (columnstore or not) try and make one of them a clustered columnstore (or a normal...
April 11, 2022 at 9:46 pm
another question...
the execution plan says to create a non-clustered index on main table with the suggested fields:
Missing INdex (Impact 41.8205): Create Nonclustered index [<Name of missing index, sysname,>] on dbo.MyDB...
April 11, 2022 at 5:35 am
while looking into it - was there a reason for you to build a heap with columnstore indexes instead of making one of them a clustered columnstore index?
the query...
April 11, 2022 at 5:11 am
while looking into it - was there a reason for you to build a heap with columnstore indexes instead of making one of them a clustered columnstore index?
this worked! ...
April 11, 2022 at 4:59 am
Viewing 15 posts - 151 through 165 (of 290 total)