Viewing 15 posts - 871 through 885 (of 2,654 total)
Steve have a look at this profile https://www.sqlservercentral.com/forums/user/papaku
I'm pretty sure I've reported them more than once - and there are similar profiles to this one - reply to one of...
June 5, 2022 at 10:33 am
how to write query detect numbers like IE only i need to write query detect numbers like IE only
you can only have exponentials if there datatype is a string...
June 5, 2022 at 10:05 am
how you see them in SSMS is not how the data is stored - that is an issue with how SSMS displays real/floats.
to see the real content you will need...
June 4, 2022 at 11:23 pm
If the database is FULL recovery, would it help to run t-log backups frequently during the process, to prevent a huge t-log ?
if insert is done in one go ...
June 3, 2022 at 10:11 pm
adding page compression is likely to reduce the size of that table to around 90 GB - overall result is that querying the table will require less IO and less...
June 3, 2022 at 3:48 pm
can you put the full DDL for the table - including indexes and data_compression clause. (you may need to change your ssms settings for generationg scripts for all these to...
June 3, 2022 at 1:02 pm
forgot to add that option to the list.
to sort it out add
@SortInTempdb = 'Y'
to that list of options
with regards to that long run - get a copy of sp_whoisactive and...
June 3, 2022 at 10:15 am
google - the information you need is very abundance and clear - and if you don't have access to install those modules speak with your admins to get it installed.
June 2, 2022 at 6:07 pm
or the one below - but output will never be the one you desire
Select *
from (select distinct VID
...
June 1, 2022 at 6:45 pm
then its time for you to read the manuals - keyword TRIM
May 31, 2022 at 4:31 pm
based on the code by Jeff the only way you get that error is if your file contains a line that has data and does not have a ":" or...
May 31, 2022 at 6:29 am
It is normal on the case of that table - it is a very small table and even if you rebuild it manually the fragmentation may not change - or...
May 31, 2022 at 6:06 am
you really have no idea of what you are doing neither do you follow the advise of this forum experts. on this case you decided to change the supplied code...
May 29, 2022 at 12:54 pm
on some of my busy and misbehaved servers I have the following query running every 10 seconds with output to a table.
with this table its easy to identify queries that...
May 29, 2022 at 11:05 am
I would add to that a verification - if number of posts = number of spam posts and user has more than 5/10 such posts just block them next time...
May 28, 2022 at 12:22 pm
Viewing 15 posts - 871 through 885 (of 2,654 total)