Viewing 15 posts - 4,201 through 4,215 (of 49,571 total)
Phil Parkin (11/24/2015)
Thank you, SSC, for helpfully encoding my 'less than' symbol 😀
Happens if the and [ /code] are on the same lime. Put a new line in...
November 24, 2015 at 1:49 am
Phil already told you what the problem is.
dt.Rows.Count < 0If no rows are returned, the count would equal zero, surely?
You're checking to see if the row count will be less...
November 24, 2015 at 1:49 am
benjamin.reyes (11/23/2015)
Unless the setting is allocating 200+ more GB of ram. 😀
Nothing wrong with allocating 200+GB memory to SQL, providing the server has it. I've got a client with...
November 23, 2015 at 3:30 pm
xsevensinzx (11/22/2015)
Can we put in a validation of user or use one of the captcha plugins for the forums to help reduce the spam? If not, then why?
Captchas don't work...
November 23, 2015 at 9:16 am
Many people don't understand error handling or transactions.
November 23, 2015 at 9:05 am
One shrink, multiple shrinks, both going to cause index fragmentation. Shrink it in small chunks, that's the usual advice for large shrink operations, LOB or no LOB.
November 23, 2015 at 9:02 am
GilaMonster (11/23/2015)
See https://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/ for how to start SQL without TempDB.
November 23, 2015 at 8:58 am
If you remove cores then yes, you will probably reduce performance. If you want to keep all the cores, then you need to licence all of them. Your choice. Lower...
November 23, 2015 at 7:51 am
Trace for a sensible period of time, set to autoclose and check the error log for startup messages. But ultimately it's a case of put some monitoring in place and...
November 23, 2015 at 7:34 am
The account that SQL server is running under needs full control permission of the folder where the files are. Check Config Manager, check the service it's running under and make...
November 23, 2015 at 7:11 am
antocasu (11/23/2015)
But we use server also for other services. If I reduce the core from bios, may I compromise the performance of my server?
Probably, yes
I thought I can reduce...
November 23, 2015 at 6:26 am
It limits which processors queries run on, it's not sufficient for reducing number of cores licensed.
https://www.microsoft.com/en-us/licensing/learn-more/brief-licensing-by-cores.aspx
You have the following two options for licensing under the per core licensing model:
1. Individual...
November 23, 2015 at 6:24 am
Then you'll need to disable the cores in the server's BIOS, If the cores are visible to Windows, they have to be licensed. Ask the sysadmins to do the BIOS...
November 23, 2015 at 6:02 am
Not touching that with a bargepole (and please can you edit your post in case someone tries to run whatever that is?)
Wipe that machine and get your IT security people...
November 23, 2015 at 5:42 am
Viewing 15 posts - 4,201 through 4,215 (of 49,571 total)