Viewing 15 posts - 4,201 through 4,215 (of 49,552 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 23, 2015 at 9:16 am
Many people don't understand error handling or transactions.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 23, 2015 at 6:02 am
Is this for licensing purposes?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 23, 2015 at 5:47 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 23, 2015 at 5:42 am
Viewing 15 posts - 4,201 through 4,215 (of 49,552 total)